File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes SQLException in distributed application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLException in distributed application" Watch "SQLException in distributed application" New topic
Author

SQLException in distributed application

mohan kumar r
Ranch Hand

Joined: Jan 19, 2006
Posts: 38
i am getting the bellow exception when there is rollBack() state ment in my code.

java.sql.SQLException: Cannot call Connection.rollback in distributed transaction. Transaction Manager will commit the resource manager when the distributed transaction is committed. at weblogic.jdbc.wrapper.JTSConnection.rollback

may i know the meaning for the exception.


mohan
Nathan Pruett
Bartender

Joined: Oct 18, 2000
Posts: 4121

This isn't really a "Distributed Java" question, even though "distributed" is mentioned in the error... The error is because your transaction depends on more than 1 "resource" - either your transaction spans multiple databases, or you're using JMS and the transaction spans both the database and the JMS message store.

Moving to the JDBC forum, since it's really more about transactions and SQL...
[ September 18, 2006: Message edited by: Nathan Pruett ]

-Nate
Write once, run anywhere, because there's nowhere to hide! - /. A.C.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQLException in distributed application
 
Similar Threads
Conneection Error In Split Directory structure
Exceptions
Resource-local transaction and JTA transaction together
JDBC transactions, JTA transactions, Transaction demarcation
Distributed transaction , connnection.commit