I wonder what you might have found if you searched the hibernate forum, but the
answer is: configure your datasource to check the validity of the connnection
before using it.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4034202#4034202
Reply to the post :
Hint:
http://wiki.jboss.org/wiki/Wiki.jsp?page=WhatHappensToJBossIfIRestartTheDatabase
Martin
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4034231#4034231
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4034231
___
I have just posted on the Hibernate forum to
The solution of mputz is for a JBoss AS but I work on a Tomcat server.
Is there a similar solution on Tomcat?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4034426#4034426
Reply to the post :
http://www.jboss.com
in that case, just look at the tomcat docu ;-)
"validationQuery - SQL query that can be used by the pool to validate
connections before they are returned to the application. If specified, this
query MUST be an SQL SELECT statement that returns at least one row."
Martin
View the original post :
I have the a similair problem, where my MySQL connection seems to die with a
socket connection error. I am going to try the following:
In hibernate.cfg.xml file, use:
java:comp/env/jdbc/JbpmDS
| instead of the direct jdbc connection.
In my webapps context.xml which should be found in
tomcat\
By the way, here is a link that should help you sort out your problem:
http://michaelstudman.com/fullfathomfive/articles/2004/06/07/mysql-dropping-connections-and-hibernate
Here is also more info the the hibernate.C3p0 config:
http://www.hibernate.org/214.html
If my tomcat datasource with maxIdl
A quick update: I no longer seem to have dropped connections after creating the
datasource in tomcat, and setting the maxIdle parameter.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4111515#4111515
Reply to the post :
http://www.jboss.com/index.html?module=
great... as with many 'problems' not jBPM related ;-)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4111608#4111608
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4111608
___
j