Atomikos Forum

Can Atomikos gracefully recover after a session has been killed?

We are using Atomikos on top of Oracle JDBC. Our web app runs on Tomcat 6. Every night, the database is update with new stored procedures at which time the DBA kills all open sessions from Tomcat to Oracle.

After this operation, the first call to a stored procedure results in: raised -3: the XA resource detected an internal error

JDBC logging reveals that this due to the following error in OJDBC:
ORA-00028: your session has been killed

Is there a way Atomikos can gracefully recover from this without actually raising an exception all the way back to the caller? I was thinking along the lines of establishing a new session on the fly after having encountered this error?

Any ideas? Possible? Feasible?

Thanks!
Rik Gruwez Send private email
Thursday, September 16, 2010
 
 
Did you try setting a testQuery?

HTH
Guy Pardon Send private email
Thursday, September 16, 2010
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics