Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Hibernate c3p0.timeout and MySQL wait_timeout

 
Daia Yum
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am a beginner in connection pooling. I have used connection pooling in hibernate with MySQL using c3p0.

Here, I have two doubts:

1. Should c3p0.timeout and wait_timeout (MySQL) values be same?
1. Is c3p0.timeout overriding MySQL wait_timeout?
2. If not, what is the use of setting a higher c3p0.timeout than MySQL wait_timeout. Here, "what is use of pooling a connection that has already timeout?"

I want to clear these up as soon as possible.

Please help me out.

Thanks...
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!