# mysql
db.database=mysql
#Local set
#db.url=jdbc:log4jdbc:mysql://localhost:3306/#DBName
db.url=jdbc:log4jdbc:mysql://IP:Port/#DBName
db.username=#ID db.password=#PW
db.driverClassName=com.mysql.db.Driver
#mysql DB config
db.conn.maxTotal=50 db.conn.maxIdle=5
db.conn.maxWaitMillis=30
db.conn.validationQuery=SELECT 1;
db.conn.validationInterval=30000
db.conn.testWhileIdle=true
db.conn.removeAbandoned=true
db.conn.removeAbandonedTimeout=60
#######################################################
# mssql
jdbc.db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc.db.url=jdbc:sqlserver://IP:Port;DataBaseName=#DBName
jdbc.db.username=#ID
jdbc.db.password=#PW
jdbc.db.conn.maxTotal=50
jdbc.db.conn.maxIdle=5
jdbc.db.conn.maxWaitMillis=30
jdbc.db.conn.validationQuery=SELECT 1;
jdbc.db.conn.removeAbandonedTimeout=60
#######################################################
# oracle
jdbc.db.driver=oracle.jdbc.driver.OracleDriver
jdbc.db.url=jdbcc:oracle:thin:@IP:Port:#DBName
jdbc.db.username=#ID
jdbc.db.password=#PW
#oracle DB config
jdbc.db.conn.maxTotal=50
jdbc.db.conn.maxIdle=5
jdbc.db.conn.maxWaitMillis=30
jdbc.db.conn.validationQuery=SELECT 1;
jdbc.conn.removeAbandonedTimeout=60