aspose file tools*
The moose likes Object Relational Mapping and the fly likes Conflict with Hibernate's Pool and Mysql? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Conflict with Hibernate Watch "Conflict with Hibernate New topic
Author

Conflict with Hibernate's Pool and Mysql?

Ben Anis
Greenhorn

Joined: Jul 28, 2011
Posts: 4
hello, is there conflict with Hibernate's Pool and Mysql? I have a web application in mysql and I use hibernate for the management of connexion.but after hours of use of the applications I have an exception when connecting:


What could be the reason for this error?


This is my hibernate configuration file :


Regards.
Waswani Naresh
Ranch Hand

Joined: May 01, 2008
Posts: 66
Hi Ben,

Looks like the connection pool is out of DB connections. Reason could be that the connections were not released properly i.e. session objects were not release/closed properly.

Could you please check if the session objects were closed properly after the transactions were over ?

Regards,
Naresh Waswani


Naresh Waswani
Ben Anis
Greenhorn

Joined: Jul 28, 2011
Posts: 4
Hi Naresh ,
Normally all connections are closed after each transaction.
Regards.
Ben Anis
Greenhorn

Joined: Jul 28, 2011
Posts: 4
I got even more detailed than:

So the cause is :

What explanation given in this case.
Ben Anis
Greenhorn

Joined: Jul 28, 2011
Posts: 4
For further identified the problem I add this: When it is blocked from the deployed application on the net, if I access the same database but with a deployed application on my computer, I have no problem connecting. So if I open a connection tool database (sql manager), I have no problem to run queries. So it's not a problem transaction not closed.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Conflict with Hibernate's Pool and Mysql?