how to recover transaction that is interrupted

[cjz002]

Hello, there,

I have an application that need to recover from network failure. We found a way to do that if the server is idle. But if the server is in middle of a transaction and the network dropped, the application server can not recover from the transaction, and has to restart the db server to recover it.

Is there any way to recover the transaction in the middle? I am using JBoss3.2.1 and Oracle.

Any input will be appreciated.

-jz

[ioparra]

XA Transaction or Local?

[cjz002]

Hi, thanks for your reply.

Let me give you mroe details of our application. We have typical 3 tiers configuration, client, server (jboss), and db server (oracle). We have a problem to recover the network disconnection if the DB server is disconnected while in middle of a transaction. And we have to restarted the DB server to recover. I know that JBoss 3.2.1 and Oracle could automatically recover the db network problem. But I am not sure that it is been handled very well if it is in middle of a transaction.

I am seeking for a solution that could handle the network problem in middle of tx.

Thanks,
-jz