Hi,

I have configured hibernate to use C3P0. Whenever I stopped my application, the postgresql server that I am using will log a lot of "unexpected EOF on client connection
". And I did some investigation ...... I turned on my C3P0 logging. And I found that when I call configuration.buildSessionFactory(), I will have 1 + (number of mapping resources I've got in my configuration file) connection pools created. If i have 3 mapping resources then 4 connection pools get created! Did I do anything wrong? I only got one hibernate configuration file.

Thanks

What does your hibernate configuration file look like? Especially the c3p0 properties? We are using hibernate 3 w/c3p0, but with Spring as our bean factory framework and the pooling seems to be working just fine. One thing I did read is that c3p0 (default setting) is to create 3 helper threads (I believe per connection), so you might see a surge in connections, then they die away.

Hope this helps!