Hi, i have a problem that i want to now best maner to resolve it.
My problem(by the way sorry for my english):

I have to maintain an app that uses hibernate 2.0. This app is using two databases, one in local ( hypersonic ) and one in remote ( MS SQL Server 2000 )

Recently we have suffering lock problem in some tables with high concurrence. To solve this we accord with our clients to reduce the response of the JDBC connection timeout.

In Query interface we have a method to put a timeout for the QueryImpl when i use the createSQL from session. But when i use methods like session.update(Object) i cant find any way to input some timeout for this operations.

I read about the c3p0 implementation but i no want to use a connection pool in this application.

Exists any other way to input a timeout in the session or session factory to make that all database operations have a timeout?

Thks in advance for your help.
Cheers.