Re: JPA consumer reconnection

I've tried several connection pools with no success. The problem is that JPA is keeping the connection, I guess. I've solved my problem by switching to the hibernate Camel component and reconnection works fine with C3P0. On Tue, Jan 5, 2016 at 10:06 PM, SaurabhNayar wrote: > That's not good fro

Re: JPA consumer reconnection

That's not good from c3p0. You can try a different connection pool altogether. Apache DBCP is compatible with Hibernate http://commons.apache.org/proper/commons-dbcp/ Here are some more details on Hibernate connection pooling: http://www.informit.com/articles/article.aspx?p=353736&seqNum=4 --

Re: JPA consumer reconnection

Nayar, I've configured c3p0 to do all that and the logs at the beginning seems to confirm that, but since the broken connection is still holded, it cannot do anything. Hence this message, I guess: com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable [c3p0] A PooledConnection that has alrea

Re: JPA consumer reconnection

Please refer to: http://www.mchange.com/projects/c3p0/index.html#configuring_connection_testing You can use: /idleConnectionTestPeriod preferredTestQuery/ parameters to make the c3p0 connection pool reconnect wit