oracle c3p0配置文件,c3p0 连接池配置

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

C3P0 可使用 properties 配置文件方式,将c3p0.properties放在classpath目录下,如果为WEB应用,放在WEB-INF\classes下 c3p0.properties #

# This file is detritus from various testing attempts

# the values below may change, and often do not represent # reasonable values for the parameters. #

c3p0.jdbcUrl=jdbc:oracle:thin:@127.0.0.1:1521:chenchi c3p0.driverClass=oracle.jdbc.driver.OracleDriver c3p0.user=hbota2

c3p0.password=ty1234

c3p0.minPoolSize=3 c3p0.maxPoolSize=20

#c3p0.testConnectionOnCheckout=true #c3p0.testConnectionOnCheckin=true

#c3p0.checkoutTimeout=2000 #c3p0.idleConnectionTestPeriod=5 #c3p0.maxConnectionAge=10 #c3p0.maxIdleTime=2

#c3p0.maxIdleTimeExcessConnections=1 #c3p0.propertyCycle=1

#c3p0.numHelperThreads=10

#c3p0.unreturnedConnectionTimeout=15

#c3p0.debugUnreturnedConnectionStackTraces=true #c3p0.maxStatements=30

#c3p0.maxStatementsPerConnection=5 #c3p0.maxAdministrativeTaskTime=3 #c3p0.preferredTestQuery=SELECT 1

#c3p0.preferredTestQuery=SELECT a FROM emptyyukyuk WHERE a = 5 #c3p0.preferredTestQuery=SELECT a FROM testpbds WHERE a = 5 #c3p0.usesTraditionalReflectiveProxies=true #c3p0.automaticTestTable=PoopyTestTable #c3p0.acquireIncrement=4

#c3p0.acquireRetryDelay=1000 #c3p0.acquireRetryAttempts=60

#c3p0.connectionTesterClassName=com.mchange.v2.c3p0.test.AlwaysFailConnectionTester #c3p0.initialPoolSize=10

com.mchange.v2.log.MLog=com.mchange.v2.log.log4j.Log4jMLog

#com.mchange.v2.log.MLog=com.mchange.v2.log.jdk14logging.Jdk14MLog


本文来自互联网用户投稿,文章观点仅代表作者本人,不代表本站立场,不承担相关法律责任。如若转载,请注明出处。 如若内容造成侵权/违法违规/事实不符,请点击【内容举报】进行投诉反馈!

相关文章

立即
投稿

微信公众账号

微信扫一扫加关注

返回
顶部