AnsweredAssumed Answered

Can't recover from connection interruption to Oracle

Question asked by hawkeyeerik on Feb 3, 2011
Latest reply on Jul 5, 2013 by jbarrez
Hello Activiti friends,

Activiti 5.1, Oracle 10G 10.2 database, JDK 1.6.0_16, Tomcat 6.0

Our Oracle database performs a warm backup each night.  I'm not aware of any other scheduled tasks/processes that might interrupt a connection.

The next morning Activiti can't connect and throws the attached exception.  I've tried ojdbc5.jar and ojdbc6.jar version 11.2.  Restarting the applications resolves the issue.

I'll play with it a bit but was hoping someone'd seen this already.  Not sure if it is an Oracle driver or iBatis configuration issue.

Thanks!
Erik

### Error querying database.  Cause: java.sql.SQLRecoverableException: No more data to read from socket
### The error may involve org.activiti.persistence.selectUserById-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLRecoverableException: No more data to read from socket
org.springframework.extensions.webscripts.WebScriptException: 01030000 Wrapped Exception (with status template):
### Error querying database.  Cause: java.sql.SQLRecoverableException: No more data to read from socket
### The error may involve org.activiti.persistence.selectUserById-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLRecoverableException: No more data to read from socket
….
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.sql.SQLRecoverableException: No more data to read from socket
### The error may involve org.activiti.persistence.selectUserById-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLRecoverableException: No more data to read from socket

Outcomes