How can I connect ODBC connection in XA 2PC transaction?
Our application uses ODBC to communicate with the database (both DB2 and Oracle, if that matters) and delegates Java business logic to JNI (therefore uses Java and C).
I would like to know what tools / software / libraries are needed to allow business logic (Java / JDBC) and application framework (C / ODBC) to participate in a two phase commit protocol.
We are running Linux for this project, but we generally support Solaris and Windows, so multiplatform solutions are preferred.
source to share
Your question is confusing - could you describe your system better? You say "uses ODBC" and then "java / JDBC" ... what language did you implement the application in and how does it interact with databases?
If your code is anything other than java and uses ODBC, then you are asking on the wrong forum if it is in java then use JDBC, and since both Oracle and DB2 support XA, you will need to use the XA monitor. and he needs a job.
source to share