YNU_JEUS/app_home/batch/resources/batch-db.properties

db2.driver.simple=com.ibm.db2.jcc.DB2Driver
db2.driver.pooled=com.ibm.db2.jcc.DB2ConnectionPoolDataSource
db2.driver.xa=com.ibm.db2.jcc.DB2XADataSource

db2.driver=com.ibm.db2.jcc.DB2XADataSource

oracle.driver.simple=oracle.jdbc.driver.OracleDriver
oracle.driver.pooled=oracle.jdbc.pool.OracleConnectionPoolDataSource
oracle.driver.xa=oracle.jdbc.xa.client.OracleXADataSource

oracle.driver=oracle.jdbc.xa.client.OracleXADataSource

hisdb.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn1adgdb2)(PORT=1521))(CONNECT_DATA=(SID=HIS031)))
misdb.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=MIS030)))
crmdb.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=CRM030)))
cendb.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn1adgdb2)(PORT=1521))(CONNECT_DATA=(SID=CEN030)))
asishisdb.url=jdbc:oracle:thin:@192.168.100.224:1521/HIS
asishis7db.url=jdbc:oracle:thin:@172.18.10.75:1521/HIS7
kuhsmsdb.url=jdbc:oracle:thin:@192.168.100.222:1521/OBD
hisdb_his031.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn1adgdb2)(PORT=1521))(CONNECT_DATA=(SID=HIS031)))
hisdb_his032.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn1adgdb2)(PORT=1521))(CONNECT_DATA=(SID=HIS032)))

########################################################
# KNU Batch DB
########################################################
comdb.jdbc.driver=${oracle.driver}
comdb.jdbc.connectionurl=${hisdb.url}
comdb.jdbc.username=comu02
comdb.jdbc.password=knuhknuh@
comdb.jdbc.defaultautocommit=false
comdb.pool.maximumactiveconnections=1
comdb.pool.maximumidleconnections=1
comdb.pool.timetowait=0

nxcomdb.jdbc.driver=${oracle.driver.pooled}
nxcomdb.jdbc.connectionurl=${hisdb.url}
nxcomdb.jdbc.username=comu02
nxcomdb.jdbc.password=knuhknuh@
nxcomdb.jdbc.defaultautocommit=true
nxcomdb.pool.maximumactiveconnections=1
nxcomdb.pool.maximumidleconnections=1
nxcomdb.pool.timetowait=0
nxcomdb.sql.readtimeout=10

hisdb.jdbc.driver=${oracle.driver}
hisdb.jdbc.connectionurl=${hisdb.url}
hisdb.jdbc.username=hisu01
hisdb.jdbc.password=knuhknuh@
hisdb.jdbc.defaultautocommit=false
hisdb.pool.maximumactiveconnections=1
hisdb.pool.maximumidleconnections=1
hisdb.pool.timetowait=0

nxhisdb.jdbc.driver=${oracle.driver.pooled}
nxhisdb.jdbc.connectionurl=${hisdb.url}
nxhisdb.jdbc.username=hisu01
nxhisdb.jdbc.password=knuhknuh@
nxhisdb.jdbc.defaultautocommit=true
nxhisdb.pool.maximumactiveconnections=1
nxhisdb.pool.maximumidleconnections=1
nxhisdb.pool.timetowait=0
nxhisdb.sql.readtimeout=10

misdb.jdbc.driver=${oracle.driver}
misdb.jdbc.connectionurl=${misdb.url}
misdb.jdbc.username=misu01
misdb.jdbc.password=misu01
misdb.jdbc.defaultautocommit=false
misdb.pool.maximumactiveconnections=1
misdb.pool.maximumidleconnections=1
misdb.pool.timetowait=0

tisdb.jdbc.driver=${oracle.driver}
tisdb.jdbc.connectionurl=${cendb.url}
tisdb.jdbc.username=tisu01
tisdb.jdbc.password=tisu01
tisdb.jdbc.defaultautocommit=false
tisdb.pool.maximumactiveconnections=1
tisdb.pool.maximumidleconnections=1
tisdb.pool.timetowait=0

crmdb.jdbc.driver=${oracle.driver}
crmdb.jdbc.connectionurl=${crmdb.url}
crmdb.jdbc.username=crmu01
crmdb.jdbc.password=crmu01
crmdb.jdbc.defaultautocommit=false
crmdb.pool.maximumactiveconnections=1
crmdb.pool.maximumidleconnections=1
crmdb.pool.timetowait=0

nxcrmdb.jdbc.driver=${oracle.driver.pooled}
nxcrmdb.jdbc.connectionurl=${crmdb.url}
nxcrmdb.jdbc.username=crmu01
nxcrmdb.jdbc.password=crmu01
nxcrmdb.jdbc.defaultautocommit=false
nxcrmdb.pool.maximumactiveconnections=1
nxcrmdb.pool.maximumidleconnections=1
nxcrmdb.pool.timetowait=0

cendb.jdbc.driver=${oracle.driver}
cendb.jdbc.connectionurl=${cendb.url}
cendb.jdbc.username=cenu01
cendb.jdbc.password=cenu01
cendb.jdbc.defaultautocommit=false
cendb.pool.maximumactiveconnections=1
cendb.pool.maximumidleconnections=1
cendb.pool.timetowait=0

asishisdb.jdbc.driver=${oracle.driver}
asishisdb.jdbc.connectionurl=${asishisdb.url}
asishisdb.jdbc.username=medi
asishisdb.jdbc.password=medi123
asishisdb.jdbc.defaultautocommit=false
asishisdb.pool.maximumactiveconnections=1
asishisdb.pool.maximumidleconnections=1
asishisdb.pool.timetowait=0

asishis7db.jdbc.driver=${oracle.driver}
asishis7db.jdbc.connectionurl=${asishis7db.url}
asishis7db.jdbc.username=medi
asishis7db.jdbc.password=medi123
asishis7db.jdbc.defaultautocommit=false
asishis7db.pool.maximumactiveconnections=1
asishis7db.pool.maximumidleconnections=1
asishis7db.pool.timetowait=0

kuhsmsdb.jdbc.driver=${oracle.driver}
kuhsmsdb.jdbc.connectionurl=${kuhsmsdb.url}
kuhsmsdb.jdbc.username=emma
kuhsmsdb.jdbc.password=emma000
kuhsmsdb.jdbc.defaultautocommit=false
kuhsmsdb.pool.maximumactiveconnections=1
kuhsmsdb.pool.maximumidleconnections=1
kuhsmsdb.pool.timetowait=0

nxmedidb.jdbc.driver=${oracle.driver.pooled}
nxmedidb.jdbc.connectionurl=${asishisdb.url}
nxmedidb.jdbc.username=MEDI2005
nxmedidb.jdbc.password=medi123
nxmedidb.jdbc.defaultautocommit=false
nxmedidb.pool.maximumactiveconnections=1
nxmedidb.pool.maximumidleconnections=1
nxmedidb.pool.timetowait=0

hisdb_his031.jdbc.driver=${oracle.driver}
hisdb_his031.jdbc.connectionurl=${hisdb_his031.url}
hisdb_his031.jdbc.username=hisu01
hisdb_his031.jdbc.password=knuhknuh@
hisdb_his031.jdbc.defaultautocommit=false
hisdb_his031.pool.maximumactiveconnections=2
hisdb_his031.pool.maximumidleconnections=2
hisdb_his031.pool.timetowait=0

hisdb_his032.jdbc.driver=${oracle.driver}
hisdb_his032.jdbc.connectionurl=${hisdb_his032.url}
hisdb_his032.jdbc.username=hisu01
hisdb_his032.jdbc.password=knuhknuh@
hisdb_his032.jdbc.defaultautocommit=false
hisdb_his032.pool.maximumactiveconnections=2
hisdb_his032.pool.maximumidleconnections=2
hisdb_his032.pool.timetowait=0

cons031db.jdbc.driver=${oracle.driver}
cons031db.jdbc.connectionurl=${his031db.url}
cons031db.jdbc.username=consu01
cons031db.jdbc.password=cons03399
cons031db.jdbc.defaultautocommit=false
cons031db.pool.maximumactiveconnections=1
cons031db.pool.maximumidleconnections=1
cons031db.pool.timetowait=0

cons033db.jdbc.driver=${oracle.driver}
cons033db.jdbc.connectionurl=${his033db.url}
cons033db.jdbc.username=consu01
cons033db.jdbc.password=cons03399
cons033db.jdbc.defaultautocommit=false
cons033db.pool.maximumactiveconnections=1
cons033db.pool.maximumidleconnections=1
cons033db.pool.timetowait=0

nxcons033db.jdbc.driver=${oracle.driver.pooled}
nxcons033db.jdbc.connectionurl=${his033db.url}
nxcons033db.jdbc.username=consu01
nxcons033db.jdbc.password=cons03399
nxcons033db.jdbc.defaultautocommit=true
nxcons033db.pool.maximumactiveconnections=1
nxcons033db.pool.maximumidleconnections=1
nxcons033db.pool.timetowait=0
nxcons033db.sql.readtimeout=10