Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Conflict with Hibernate's Pool and Mysql?

 
Ben Anis
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ben Anis
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Naresh ,
Normally all connections are closed after each transaction.
Regards.
 
Ben Anis
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I got even more detailed than:

So the cause is :

What explanation given in this case.
 
Ben Anis
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic