• 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

Hibernate c3p0.timeout and MySQL wait_timeout

 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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...
reply
    Bookmark Topic Watch Topic
  • New Topic