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
Joined: Jul 17, 2003
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.