Hey guys...im getting this odd exception:
com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.CallableStatementProxy is closed
Im executing a transaction from a 1.4
J2EE application to a SQL Server 7.
I call a storedprocedure on the DB and the procedure executes many internal calls and tasks...after 45min i get the error: "CallableStatementProxy is closed". The application uses Spring Framework to control the DB access. The Datasource used in this process doesnt have any time paremeter set as 45min.
After 2 attemps i started the storedprocedure call within the DB....that solved my problem but i wont be able to do that everytime we decide to execute the process.
We are using DataDirect SQLLink driver, type 4.
Please send a post if you have experienced any similar problem and know how to solve it.
thanks,
best regards!
