posted 12 years ago
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...