jbpm persistance fails after running for a while

[frinux]

Hi,
I've got a problem difficult to trace. My application works well, but after a while (I leave in the evening and come back the day after), the persistance is over.

I'm running jBPM 3.3.1GA and MySQL 5.1.11, with the JDBC connector mysql-connector-java-5.1.7

here is the log I get:
http://pastebin.com/m1c2c39e9

Lika I said, it's hard to debug because it's happening only after a while. Moreover, the MySQL server is still active and running (I also have a login process in my application, and it still works), so I think that the problem comes form jBPM.

Here is an example of my code that uses jBPM API, in case of the use of persistance is wrong :
http://pastebin.com/m4e20e430

Do you see something wrong?

[kukeltje]

looks like a problem with your datasource/connectionpool and not jBPM related. Connections seem to be 'partially' closed, so try to finda solution in that direction

[frinux]

What do you mean by 'partially' ??? When the bug appeared, I checked the connection and everything was alright. I don't know how a connection could be partially closed.

[kukeltje]

it's partially closed if one end thinks it is still open and the other end doesn't. The dbms can be still up, opening a fully new connection works and even other connectionpools, e.g. configured differently might still work. All basic JEE stuff.

[frinux]

And do you know where I could maybe have a look to fix this? I have no idea. Or maybe should I ask MySQL experts?