c3p0配置
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property> <property name="hibernate.c3p0.max_size">20</property> <property name="hibernate.c3p0.min_size">5</property> <property name="hibernate.c3p0.timeout">120</property> <property name="hibernate.c3p0.max_statements">100</property> <property name="hibernate.c3p0.idle_test_period">120</property> <property name="hibernate.c3p0.acquire_increment">2</property> |
proxool配置
<property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property> <property name="hibernate.proxool.pool_alias">xjgame</property> <property name="hibernate.proxool.xml">proxool.xml</property> |
<?xml version="1.0" encoding="ISO-8859-1"?> <something-else-entirely> <proxool> <alias>xjgame</alias> <driver-url>jdbc:oracle:thin:@123.123.123.12:1521:game</driver-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <driver-properties> <property name="user" value="a"/> <property name="password" value="a"/> </driver-properties> <maximum-connection-count>20</maximum-connection-count> <house-keeping-test-sql>select CURRENT_DATE from dual</house-keeping-test-sql> </proxool> </something-else-entirely> |
这和你的c3p0的配置有关。
数据源里所有的连接都已经断开,当然无法访问了。
你可以加以下几个参数:
acquireRetryAttempts : 失败尝试次数
acquireRetryDelay : 两次尝试的间隔时间(秒)
breakAfterAcquireFailure : (true或者false) true的话就是指经过acquireRetryAttempts 指定的尝试次数仍然无法获得connection后,连接池永久中断. false的话所有的线程将等待连接池取得数据库连接,