Howdy,
I've been having trouble getting Connection Pooling working with either C3P0 or DBCP and using MySQL... the connection dies after some number of hours and the next time the webapp is used, it hangs, and an ioException is logged with a connection failure.
I have been told there is some type of 'connection validation' that is configurable and now i have learned that it is required in order to make pooled connections work and not fail when the db/driver times out.
Can someone please explain *exactly* which hibernate.cfg.xml parameters need to be set (and to what values) to get pooling working and exactly how one sets up this 'Connection Validation' that i have heard about?? FYI: I'm using Hibernate 2 and MySQL 4 and (trying) C3P0.
I'm sorry if this is an old/tired question to some, but combing the mailing lists, i see a variety of answers that do not seem clear to me and i can find no information on the website regarding Connection Validation. Can someone please give a redux on how to do all this 'the right way'???
many thanks,
-dave
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
