c3p0 连接池配置,,C3P0 可使用 pro
分享于 点击 26052 次 点评:15
c3p0 连接池配置,,C3P0 可使用 pro
C3P0 可使用 properties 配置文件方式,将c3p0.properties放在classpath目录下,如果为WEB应用,放在WEB-INF\classes下
## 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:chenchic3p0.driverClass=oracle.jdbc.driver.OracleDriverc3p0.user=hbota2c3p0.password=ty1234c3p0.minPoolSize=3c3p0.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=10com.mchange.v2.log.MLog=com.mchange.v2.log.log4j.Log4jMLog#com.mchange.v2.log.MLog=com.mchange.v2.log.jdk14logging.Jdk14MLog#com.mchange.v2.log.MLog=com.mchange.v2.log.FallbackMLogcom.mchange.v2.log.NameTransformer=com.mchange.v2.log.PackageNamescom.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL=ALL#com.mchange.v2.c3p0.VMID=poop//该片段来自于http://byrx.net
用户点评