Unable to commit connection in global Tran

[kishore goswami]

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]

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]

Does your container support two-phase commit?