Hibernate version:
jboss 4.0.2RC1 hibernate 2,
Name and version of the database you are using:
postgresql 8.0

I met following problem when I tried to lock a record using

HibernateUtil.getSession().lock(account, LockMode.UPGRADE);

the thread was stopped waiting a result from the db. It was waiting for a very long time.
Could anyone share with me his experience how to use timeouts on db queries for postgresql to prevent the thread to hang for undefined time?

I found a <new-connection-sql> inside data-source.xml
But how it behaves on reusable connections staying in the pool ?

Thanx in advance
Alex