aspose file tools*
The moose likes JDBC 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
Bookmark "distributed transactions" Watch "distributed transactions" New topic
Author

distributed transactions

Kalpesh Soni
Ranch Hand

Joined: Jan 02, 2001
Posts: 311
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: 8898

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: 8898

I dont think so. Any one thinks so?
Originally posted by Sainudheen Mydeen:
In a distributed database, can JDBC's Savepoint be used?
------------------
Sainudheen
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: distributed transactions
 
Similar Threads
Remote Transactions
2 phase commit
Connecting to multiple databases using different jdbc drivers
2 databases access with EJB ?
Transactions!