Hi I'm facing a trouble when I'm been using hibernate with spring framework, the server is blocked after opening JDBC connection.

Any idea ?

my best regards

Hibernate version:
3.0

Name and version of the database you are using:
mysql 5.0

Debug level Hibernate log excerpt:
DEBUG http-8080-Processor23 com.mtsa.ebonus.core.db.UsedTableDbDAO - finding UsedTableDb instance by example (with params)
DEBUG http-8080-Processor23 org.springframework.orm.hibernate3.SessionFactoryUtils - Opening Hibernate Session
DEBUG http-8080-Processor23 org.hibernate.impl.SessionImpl - opened session at timestamp: 4718642005274624
DEBUG http-8080-Processor23 org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 3)
DEBUG http-8080-Processor23 org.hibernate.jdbc.ConnectionManager - opening JDBC connection

Did you get a resolution to this??

yes I solved this by adding a property in the applicationContext properties file

<prop key="hibernate.connection.release_mode">auto</prop>

we found it too....though a different way

we were using spring's dao support class to manage sessions (until i get off my lazy butt and put a filter on the app for transactional mgmt). I didn't read the spring javadoc completely, though. In some places I was using the HibernateTemplate class. In others (mostly simple cases), I was using getSession(). Stupidly, I didn't realize that I aslo needed to call release session when I was done with it. So, adding that fixed the problem as well.

I will look into the auto property, too. It seems interesting to prevent errors like this in the future.

Thanx for the help,
LES