Raible, Matt wrote:
You can remedy this problem with MySQL by adding autoReconnect=true in your
JDBC URL. For instance:
jdbc:mysql://localhost/mydatabase?autoReconnect=true
thanks a lot for your suggestion
I will try, and let you know if it does work :))
Bye bye
Enrico
I've also heard that adding a validationQuery parameter will have a similar
effect (at least with Oracle):
<parameter>
<name>validationQuery</name>
<value>SELECT 1 FROM DUAL</value>
</parameter>
I'm having a similar problem with Oracle - I wonder if anyone else has seen
this. When using Tomcat's connection pool (DBCP) and Oracle - everything
works great for about two hours - and then Oracle seems to close the
connection. I don't know if this is Hibernate related or what, but I'm
using a JNDI connection and there's no timeout set on the Oracle user. No
one is using the system right now, so I'm guessing the connection is being
closed either by Tomcat or by Hibernate.
Thanks,
Matt
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
