I am a beginner in connection pooling. I have used connection pooling in hibernate with MySQL using c3p0.
Here, I have two doubts:
1. Shouldc3p0.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.
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