This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Native XA using the Oracle thin driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Native XA using the Oracle thin driver" Watch "Native XA using the Oracle thin driver" New topic
Author

Native XA using the Oracle thin driver

James Adams
Ranch Hand

Joined: Sep 12, 2003
Posts: 188
I am currently developing an application which requires database XA transactions in order to make use of a JTA Transaction Manager. Although I am using the latest Oracle thin driver, which is supposed to support native XA by default (see this page) I still can't get my data inserts to stick once the XA transaction has been committed. There is no exception thrown, I just never see the new data row in the table.

This application works as expected when I use a PostrgreSQL database. So I assume that the problem is either with the Oracle driver (maybe I'm not actually using the thin driver that I think I am), or with the Oracle database configuration itself.

Am I mistaken thinking that I'm using the thin Oracle driver rather than the OCI or KPRB drivers by having ":thin:" included in the JDBC URL (my JDBC URL is "jdbcracle:thin:@dev.mycom.com:1521:TESTDB")?

Is it possible that the Oracle database could be configured in such a way that XA is disabled? If so then what settings would I check to confirm that this is the case?

Thanks in advance for any ideas/suggestions etc.


--James
James Adams
Ranch Hand

Joined: Sep 12, 2003
Posts: 188
It appears that distributed (XA) transactions aren't enabled in Oracle by default, which is what caused this problem.

--James
 
GeeCON Prague 2014
 
subject: Native XA using the Oracle thin driver