Hi All,
I have developed standalone program which talks to two different oracle databases. As the program is small it doesn't require a application server to run on. The sql inserts on two different oracle database should happen in a trasaction. I won't be able to use sophisticated JTA or EJBs as they run inside container. I am left with using
JDBC transactions. I am aware that JDBC transactions aren't distributed. Please can somebody suggest any way of achiving distributed transaction behaviour with JDBC?
Cheers,
Rohit