DBCP Reconnection Trouble

[Mike Grundvig <mi...@electrotank.com>]

Hi all! I'm using DBCP with Spring, Hibernate, and MySQL and running into 
reconnection issues. Basically, all is fine and good for a few days and then 
sudden the connection pool fails to connect to the database. This is 
becoming a real embarasment because our app keeps going down even though 
nothing in the app is wrong. I'm reasonably sure it's a network hiccup or a 
database restart that triggers the problem but we can't seem to get it 
fixed. I'd expect the pool to re-establish the connection but after 3 tries 
it gives up and no where in the documentation can I see a way to increase 
that (or ideally never give up at all). As it stands, I've enabled every 
setting I can to make it just hammer the connections into submission but we 
always fail for the same reason. I've included the settings and the 
exception below. Any help would be greatly appreciated!

DBCP Settings

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" 
destroy-method="close" abstract="false" singleton="true" lazy-init="default" 
autowire="default" dependency-check="default">
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />
     <property name="url" 
value="jdbc:mysql://*****:3306/*****?autoReconnect=true&autoReconnectForPools=true&initialTimeout=1" 
/>
     <property name="username" value="*****" />
    <property name="password" value="*****" />
    <property name="initialSize" value="5" />
    <property name="maxIdle" value="5" />
    <property name="maxActive" value="20" />
    <property name="validationQuery" value="select 0" />
    <property name="testWhileIdle" value="true" />
    <property name="testOnBorrow" value="true" />
    <property name="timeBetweenEvictionRunsMillis" value="30000" />
    <property name="numTestsPerEvictionRun" value="10" />
    <property name="minEvictableIdleTimeMillis" value="60000" />
</bean>

Exception - This occurs for every connection in the pool and once we see it, 
all hope is lost for it never recovers:

2006/12/01 05:38:19.274 SEVERE [13]
(JDBCExceptionReporter.logExceptions): Server connection failure during 
transaction. Due to underlying exception: 'java.net.SocketException: 
java.net.ConnectException: Connection refused'.

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
at 
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2690)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at 
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at 
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at 
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
at 
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at 
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at 
org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
at 
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
at 
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at 
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:93)
at 
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
at 
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
at 
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2163)
at 
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
at 
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)
at 
org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:91)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at 
org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:394)
at 
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at 
org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:655)
at 
org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:651)
at com.***.trivia.loadbalancer.LobbyDao.updateLobby(LobbyDao.java:73)
at com.***.trivia.loadbalancer.LobbyDao.saveLobby(LobbyDao.java:21)
at 
com.***.trivia.loadbalancer.LoadBalancerPlugin.scanRooms(LoadBalancerPlugin.java:79)
at 
com.***.trivia.loadbalancer.LoadBalancerPlugin$RoomScanTimerTask.run(LoadBalancerPlugin.java:132)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)


** END NESTED EXCEPTION **

Attempted reconnect 3 times. Giving up.


Michael Grundvig
Electrotank, Inc
http://www.electrotank.com 



---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org