Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JTA with IMS Transactions

 
Stephen Nimmo
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ok.
Here we go. I am trying to access multiple databases for updates and want them all within the same transaction. The kicker is that one of the databases is IMS on OS/390. We want to use JDBC for all connectivity. Here is some pseudocode of what I want to be able to do:
Get New Transaction;
Begin Transaction;
try{
Update Oracle Database(data);
Update DB2 Database(data);
Update IMS Database(data);
Commit Transaction;
} catch {
RollBack Transaction;
}
Here are the questions:
1) Does anyone know of a JDBC driver product that allows 2-Phase commits with IMS via JDBC?
2) Will JTA be able to handle the transaction if it hits multiple databases?
3) Will JTA support the transaction with IMS?
and even more the question is...Can I ACTUALLY do this? Right now, our solution is to use JTA to handle all the work except for the IMS updates and then if the IMS transction is successful, then commit the other database updates.
Any help will be greatly appreciated.
Stephen
 
Kyle Brown
author
Ranch Hand
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, this can be done on WebSphere, but not using JDBC that I know of. You can do it by combining the WebSphere support for IMS through JCA with the "Last Participant Support" for 2PC transactions with 1PC resources available in WebSphere Enterprise Edition.
Kyle
 
Stephen Nimmo
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you, Kyle, for the quick response.
I have found the documentation at IBM. You wouldn't happen to have any source code for an example?
For the solution, here is what I found.
http://www.redbooks.ibm.com/redbooks/pdfs/sg246932.pdf
[ October 23, 2003: Message edited by: Stephen Nimmo ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic