check connection ThreadLocalSessionContext blocks thread

daniel.vesely · **Joined:** Tue Jan 02, 2007 6:48 am **Posts:** 3

Hi all,

I use hibernate in standalone (swing) application. Application is using contextual sessions and context is configured as ThreadLocalSessionContext. I need to test database connections therefore I wanted to use:

Code:

Session s = factory.getCurrentSession();
Transaction tx = s.beginTransaction();
connectionOK = s.isConnected() && !s.connection().isClosed();
tx.commit();

I am using c3p0 to pool connections. But if network connection is lost, thread that runs this code is blocked on line s.beginTransaction and I have SQLException messages in log comming from c3p0.

Does anyone has a glue what to do or what is the best method to test connection?

steckemetz · **Posted:** Wed Apr 18, 2007 7:49 am

I think in this case, the connection testing should be done by c3p0.
It usually does this. Please read the c3p0 docs, I am not an expert
in this case.

daniel.vesely · **Joined:** Tue Jan 02, 2007 6:48 am **Posts:** 3

Yes, c3p0 tests pooled connections and it has several settinngs to do it. But I haven't found method to propagate such a connection loosing into hibernate layer. Any ideas?

steckemetz wrote:

I think in this case, the connection testing should be done by c3p0.
It usually does this. Please read the c3p0 docs, I am not an expert
in this case.

steckemetz · **Posted:** Mon May 14, 2007 11:32 am

c3p0 has some methods like this

Code:

PoolBackedDataSource pooled = (PoolBackedDataSource) ds;
pooled.getLastAcquisitionFailureDefaultUser();

There are some more of these methods.
Maybe you can find a solution here.