Hibernate Connection Lost

[luowp]

I have a strange problem. I developed some web-services (AXIS-based). DB using mysql 5.0.26.

In jbpm start kit, it works stable. The service works for more than 1 month never down.

Then I deployed to Geronimo 1.1, after several hours (more than 8). The connection seems lost. The error message as below:
soapenv:Server.userException] org.jbpm.JbpmException: problem closing services {persistence=org.jbpm.persistence.JbpmPersistenceException: couldn't commit hibernate session}

I use below code to initailize jbpm for each servive:

JbpmConfiguration jconf = JbpmConfiguration.getInstance();
JbpmContext jContext = jconf.createContext();

Could somebody give me some suggestions? Thanks...

[hannes]

do you use c3p0? you can configure an idle time, so the db server doesn't disconnect from the connection. but it can reconnect too.

[luowp]

Sorry. I do not know c3p0.

How to reconnect the connection by using jbpm API.?Thanks.

[kukeltje]

You do not reconnect useing the jbpmAPI. Database connections are managed by your connectionpool. For production it is advised to use (and configure) the one that comes with your appserver, for development purposes you could use the c3p0 (look at the hibernate docs for this)