wood burning stoves 2.0*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Native XA using the Oracle thin driver
 
Similar Threads
XA Exception
Oracle XA Data Source Problem using EJB
XAER_PROTO Exception
no ocijdbc9 in java.library.path in JDK 1.4.2
Connecting Websphere 5.0 to Oracle 8.1.7