my dog learned polymorphism*
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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