• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Conflict with Hibernate's Pool and Mysql?

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic