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

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

C3P0 可使用 properties 配置文件方式，将c3p0.properties放在classpath目录下，如果为WEB应用，放在WEB-INFclasses下 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