• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

db2 and oracle XA problem

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 775
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Richard Relos
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic