• 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
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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.
 
Who knew that furniture could be so violent? Put this tiny ad out there to see what happens:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic