File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes Unable to commit connection in global Tran Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Unable to commit connection in global Tran" Watch "Unable to commit connection in global Tran" New topic
Author

Unable to commit connection in global Tran

kishore goswami
Greenhorn

Joined: Aug 13, 2003
Posts: 18
Hi friends

I am getting this error when iam calling a Stored Procedure :

java.lang.illegalStateException : Unable to commit connection in global Tran

I have checked there is no problem with the SP.

any suggestion.
any idea why this error comes.


Regards
Kishore goswami
Amit Jaipaul
Greenhorn

Joined: Jul 17, 2003
Posts: 16
Hi Kishore,

Can u post code for JSP and SP, as it is difficult to say as to why this problem might be coming. However one thing is sure, that some operation you are trying to do after starting the transaction which is illegal. Perhaps that is the reason for IllegalStateException and failure of the transaction.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Does your container support two-phase commit?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to commit connection in global Tran
 
Similar Threads
Distributed transactions across multiple databases
Global transaction error
query on setAutoCommit()
Illegal operation exception while trying rollback..
Regarding the Connection interface