Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes distributed transactions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "distributed transactions" Watch "distributed transactions" New topic
Author

distributed transactions

Kalpesh Soni
Ranch Hand

Joined: Jan 02, 2001
Posts: 312
I need to access two different db servers
one is oracle and other is mssql2000
i need some code to be in single transaction, which talks to these two dbs
I think i can do that with JTA but then i would need ap server like weblogic
can i use distributed transactions with jdbc ?
how ?
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8927

http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/jdbc20/DistributedTransaction/Readme.html


Groovy
Sainudheen Mydeen
Ranch Hand

Joined: Aug 18, 2003
Posts: 218
In a distributed database, can JDBC's Savepoint be used?
------------------
Sainudheen
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8927

I dont think so. Any one thinks so?
Originally posted by Sainudheen Mydeen:
In a distributed database, can JDBC's Savepoint be used?
------------------
Sainudheen
 
Have you checked out Aspose?
 
subject: distributed transactions
 
jQuery in Action, 3rd edition