# Database properties for the Biology Workbench SDK

database.driverClass=com.mysql.jdbc.Driver
database.useConnectionPool=true
database.fileRoot=${database.fileRoot}
database.tempFileRoot=${database.tempFileRoot}

# These variable's values come from the build profile via ~/.m2/settings.xml
database.username=${database.username}
database.password=${database.password}

database.url=${database.url}


# These variables values come from the build profile.
# c3p0 configuration
database.c3p0.acquireIncrement=1
database.c3p0.idleConnectionTestPeriod=30
database.c3p0.initialPoolSize=1
database.c3p0.maxIdleTime=18000
database.c3p0.maxIdleTimeExcessConnections=300
database.c3p0.maxPoolSize=${database.maxPoolSize}
database.c3p0.maxStatements=0
database.c3p0.minPoolSize=${database.minPoolSize}

# database.c3p0.checkoutTimeout=5000

# connection debugging
database.c3p0.debugUnreturnedConnectionStackTraces = ${database.debugUnreturnedConnectionStackTraces} 
database.c3p0.unreturnedConnectionTimeout = ${database.unreturnedConnectionTimeout}

#tomcat jdbc connection pool 
database.tomcatPool.jmxEnabled = true
database.tomcatPool.testWhileIdle = false
database.tomcatPool.testOnBorrow = true
database.tomcatPool.validationQuery = SELECT 1
database.tomcatPool.testOnReturn = false
database.tomcatPool.validationInterval = 30000
database.tomcatPool.timeBetweenEvictionRunsMillis = 30000
database.tomcatPool.maxActive = 50
database.tomcatPool.initialSize = 10
database.tomcatPool.maxWait = 10000
database.tomcatPool.removeAbandonedTimeout = 300 
database.tomcatPool.minEvictableIdleTimeMillis = 30000
database.tomcatPool.minIdle = 10
database.tomcatPool.logAbandoned = true
database.tomcatPool.removeAbandoned = true
database.tomcatPool.jdbcInterceptors = org.apache.tomcat.jdbc.pool.interceptor.ConnectionState; org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer