• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

: transaction problem involving multiple databases

 
bill williams
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am sorry if it is out of topic. I posted it on JDBC board, but that board does not have much traffic.

http://www.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=3&t=002529
 
Chris Mathews
Ranch Hand
Posts: 2712
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You would need to use a 2-Phase Commit to manage this. The gotcha for 2-PC is that your JDBC Driver and J2EE Application Server must both support them. If you fit both of these requirements then it is actually pretty easy.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good answer Chris. He is right to do that you must be able to do two phase commits. I believe some App Servers have this, and some haven't implemented it yet.
Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic