**jeusmain.xml - 운영 서버
<data-source>
<database>
<vendor>sybase</vendor>
<export-name>sybasetkd</export-name>
<data-source-class-name>com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource</data-source-class-name>
<data-source-type>ConnectionPoolDataSource</data-source-type>
<database-name>***</database-name>
<data-source-name>com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource</data-source-name>
<password>****</password>
<encryption>false</encryption>
<port-number>4100</port-number>
<server-name>***.***.***.16</server-name>
<user>****</user>
<connection-pool>
<pooling>
<min>30</min>
<max>40</max>
<step>5</step>
<period>600000</period>
</pooling>
<wait-free-connection>
<enable-wait>false</enable-wait>
<wait-time>10000</wait-time>
</wait-free-connection>
<operation-to>30000</operation-to>
</connection-pool>
</database>
</data-source>
**webmain.xml - 운영 서버
<db-connection-pool>
<pool-name>sybasepool</pool-name>
<pool-type>shared</pool-type>
<pooling-rule>stack</pooling-rule>
<connection-url>jdbc:sybase:Tds:***.***.***.16:4100/TAEKWONDO2?CHARSET=eucksc</connection-url>
<driver-class-name>com.sybase.jdbc3.jdbc.SybDriver</driver-class-name>
<connection-argument>user=***;password=***</connection-argument>
<db-pool-control>
<min>60</min>
<max>60</max>
<step>1</step>
</db-pool-control>
</db-connection-pool>
** 개발 jeusmain.xml
<data-source>
<database>
<vendor>sybase</vendor>
<export-name>sybasetkd</export-name>
<data-source-class-name>com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource</data-source-class-name>
<data-source-type>ConnectionPoolDataSource</data-source-type>
<database-name>***</database-name>
<data-source-name>com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource</data-source-name>
<password>****</password>
<encryption>false</encryption>
<port-number>4100</port-number>
<server-name>***.***.***.16</server-name>
<user>****</user>
<connection-pool>
<pooling>
<min>30</min>
<max>40</max>
<step>5</step>
<period>600000</period>
</pooling>
<wait-free-connection>
<enable-wait>false</enable-wait>
<wait-time>10000</wait-time>
</wait-free-connection>
<operation-to>30000</operation-to>
</connection-pool>
</database>
</data-source>
** 개발 webmain.xml
<db-connection-pool>
<pool-name>sybasepool</pool-name>
<pool-type>shared</pool-type>
<pooling-rule>stack</pooling-rule>
<connection-url>jdbc:sybase:Tds:***.***.***.16:4100/TAEKWONDO4?CHARSET=eucksc</connection-url>
<driver-class-name>com.sybase.jdbc3.jdbc.SybDriver</driver-class-name>
<connection-argument>user=****;password=****</connection-argument>
<db-pool-control>
<min>60</min>
<max>60</max>
<step>1</step>
</db-pool-control>
</db-connection-pool>
지금 프로젝트 하고 있는 곳의 sysbase의 커넥션 관련입니다.
자바에서
d = (Driver)Class.forName("jeus.jdbc.pool.Driver").newInstance();
c = d.connect("jdbc:jeus:pool:sybasepool", null);
이런식으로 커넥션을 가져오면 webmain.xml에 있는 <pool-name>sybasepool</pool-name> 의
데이터베이스 정보를 가져오는게 맞나요?
지금 운영과 개발이 계정정보가 디비명만 다르고 아이피나 포트, id, 패스워드가 모두 같습니다.
즉, TAEKWONDO2(운영), TAEKWONDO4(개발)만 다릅니다.
그래서 webmain.xml을 수정하고 서버 다운, 부트로 다시 조회해 보았으나
개발이 아니라 운영으로 붙는거 같아요.
뭐가 문제가 있을까요?
|