aspose file tools*
The moose likes JDBC and the fly likes db2 and oracle XA problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "db2 and oracle XA problem" Watch "db2 and oracle XA problem" New topic
Author

db2 and oracle XA problem

Richard Relos
Greenhorn

Joined: Feb 15, 2006
Posts: 3
In WebSphere, connecting to different XA datasources (all oracle) is ok. For discussion purposes, let's call it connectionA and connectionB.

However, when I mix the connection wherein one datasource is db2 and the other is oracle (connectionA=DB2, connectionB=oracle), I keep on having this error no matter how the connection pool or the RDBMS (oracle) is set:

WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMERR. The exception stack trace follows: oracle.jdbc.xa.OracleXAException.

Thanks.
Reid M. Pinchback
Ranch Hand

Joined: Jan 25, 2002
Posts: 775
It sounds like either the db2 data source is a local data source, or it uses a transaction manager that you don't have access to for some reason. Not familiar with db2 specifics, but I know with sqlserver you have to jump through some significant hoops on some wintel platforms (e.g. xp) to get access to the transaction manager in order to have XA work.


Reid - SCJP2 (April 2002)
Richard Relos
Greenhorn

Joined: Feb 15, 2006
Posts: 3
Found the answer to the problem. The problem lies in the transaction isolation level supported by WebSphere and in conjunction with DB2 and Oracle. More info on this site:

http://rrelos.net/techblog/?p=171
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: db2 and oracle XA problem
 
Similar Threads
Connection Pooling in JBoss v5.0 with IBM DB2
Not able to config the database!
Connection Pooling in JBoss v5.0 with IBM DB2
Oracle XA Data Source Problem using EJB
getting org.jboss.resource.adapter.jdbc.WrapperDataSource cannot be cast to javax.sql.XADataSource