I use the C3PO pool connection for Hibernate, but after a period of time is get the following error:

C3P0PooledConnection closed. [com.mchange.v2.c3p0.impl.C3P0PooledConnection@646bfb]

I searched the forum and i searched google, but no answers found for my problem. I hope someone here can help me or someone has a good alternative for C3PO.

Try setting hibernate.c3p0.validate=true

Hi. The message you're seeing is not an error at all -- it is a debug trace message I inadvertantly left on. If this is the only message you're seeing, it isn't a problem!

regards,
Steve Waldman
(c3p0 maintainer)

Ok that's nice to know. But what exactly happens when that debug message appears?

I think the pool shouldn't be closed at anytime. But maybe i'm misunderstanding the debug message, that is very good possible.

And is it possible to turn that debug message off?

nl_age,

Sorry about the delayed response. The pool is not being closed at all -- only a single PooledConnection. This might happen if c3p0 has detected that a Connection has gone stale, or if a Connection has exceeded its maximum idle time in the pool.

Please feel free to write me with any c3p0 issues at swaldman@mchange.com (or use c3p0-users@lists.sourceforge.net). I monitor the hibernate forums only very intermittently, but I do try to respond to c3p0-related email quckly!)

Steve

p.s. there is no way to turn off the debug message -- c3p0's logging strategy is rudimentary: I need to comment out the System.err.println(...) statement! (I know... I know... in this day and age...) It'll be gone in the next minor release of c3p0.

Ok thanx, it's really clear now.

For futher questions about c3po i will use the mailing list.