[ 
http://issues.apache.org/jira/browse/IBATIS-266?page=comments#action_12367362 ] 

Mohamed Asad commented on IBATIS-266:
-------------------------------------

After few more research on the problem . IBATIS does handle the SPStatus but 
the reason of crash was because the Stored procedure has
multiple out parameters. Because of the rollback the out parameters are set to 
null. and this is crashing the server. I got around this problem 
by setting default values in Stored procedure for out paremeter during a 
rollback.  In this case I get the SP Status back with the error value. 





>  when a roll back occurs in stored procedure. The status is not being handled 
> by IBATIS causing it to crash.
> ------------------------------------------------------------------------------------------------------------
>
>          Key: IBATIS-266
>          URL: http://issues.apache.org/jira/browse/IBATIS-266
>      Project: iBatis for Java
>         Type: Bug
>     Versions: 2.1.5
>  Environment: Websphere Studio Application Developer running on Windows XP . 
> Stored procedure being called is  in  DB2.
>     Reporter: Mohamed Asad

>
> IBATIS does not handle SP Status returned back from the Stored procedure when 
> a roll back is occured
> The rollback command is in the StoredProcedure  and not in the Java Code.  
> When the Stored procedure
> is rolled back in DB2 .  The iBATIS code just crashes.  
> I tried calling the Same SP from websphere tool and it did recieve a 
> SPStatus.   

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to