* 개요

sybase DB풀 설정 방법

* 상세 설명

sybase의 경우 로컬 db설정과 서버 db설정이 다를수 있습니다.

sybase DB 연동

로컬 설정

###

###    DataBase Connection Pool Properties

###    Last Modified : Tue Dec 04 15:33:18 KST 2007

###

#

#  BCT

#

BCT.vendor=SYBASE

BCT.dsn=Tds

BCT.serverAddress=[IP]

BCT.portNo=[PORT]

BCT.dbName=[dbName]

BCT.user=[User]

BCT.password=[Pass]

BCT.maxconns=20

BCT.initconns=1

BCT.timeout=5

BCT.initSqls=

BCT.closeSqls=

BCT.doConnectionCheck=false

BCT.testQueryString=

BCT.sessionQuery=

#

#  BCT_JC3

#

BCT_JC3.vendor=USER

#    for Custom JDBC Driver

BCT_JC3.driver=com.sybase.jdbc3.jdbc.SybDriver

BCT_JC3.url=jdbc:sybase:Tds:[IP]:[PORT]/[DataSourse]?CHARSET=eucksc

BCT_JC3.props=user=[Uer];password=[Pass];CHARSET=eucksc

BCT_JC3.user=bct

BCT_JC3.password=bct

BCT_JC3.maxconns=20

BCT_JC3.initconns=1

BCT_JC3.timeout=5

BCT_JC3.initSqls=

BCT_JC3.closeSqls=

BCT_JC3.doConnectionCheck=false

BCT_JC3.testQueryString=

BCT_JC3.sessionQuery=

서버 설정

###

###    DataBase Connection Pool Properties

###    Last Modified : Tue Dec 04 16:45:43 KST 2007

###

#

#  BCT

#

#

#  BCT_JC3

#

BCT_JC3.vendor=USER

#    for Custom JDBC Driver

BCT_JC3.driver=com.sybase.jdbc3.jdbc.SybDriver

BCT_JC3.url=jdbc:sybase:[dsn]:[IP]:[Port]/[DataSourse]

BCT_JC3.props=user=User;password=[Pass];CHARSET=eucksc

BCT_JC3.serverAddress=

BCT_JC3.portNo=0

BCT_JC3.serverName=

BCT_JC3.dbName=

BCT_JC3.user=bct

BCT_JC3.password=bct

BCT_JC3.maxconns=20

BCT_JC3.initconns=1

BCT_JC3.timeout=5

BCT_JC3.initSqls=

BCT_JC3.closeSqls=

BCT_JC3.doConnectionCheck=false

BCT_JC3.testQueryString=

BCT_JC3.sessionQuery=

###    End.