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
