Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes 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...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic