Can you share what the workarounds were?

OT:
 So far we have gotten
around issues such as not having a handle on the connection to retrieve
RAISERROR messages from a stored procedure as well as limiting the number
of
results.


thanks,
Lambert

Lambert Torres
NBA Information Technology
Web Technology Group
100 Plaza Drive
Secaucus, NJ 07094
Ph : (201) 974-6785
Fax: (201) 974-6001



                                                                           
             BenBaril                                                      
             <[EMAIL PROTECTED]                                             
             bn.ca>                                                     To 
                                       user-java@ibatis.apache.org         
             05/18/2007 06:43                                           cc 
             PM                                                            
                                                                   Subject 
                                       Retrieve stored proc return code    
             Please respond to                                             
             [EMAIL PROTECTED]                                             
                apache.org                                                 
                                                                           
                                                                           
                                                                           





Hi All,

I know this issue has come up before, but I'm curious if there is a
solution. I am in the process of evaluating iBatis (and we have pretty much
decided on it) as the sql mapper for our IT-Revitalization project. We have
over 1000 Stored Procedures in a Sybase database. So far we have gotten
around issues such as not having a handle on the connection to retrieve
RAISERROR messages from a stored procedure as well as limiting the number
of
results.

Our problem right now is that we cannot retrieve the return code from an
SP.
We rely heavily on return codes to determine why a stored procedure may
have
failed, and we need these codes to propagate back up the Java stack so we
can have a handle on them.

Is there a way to do this using iBatis right now?

Thank you,
Benjamin Baril
--
View this message in context:
http://www.nabble.com/Retrieve-stored-proc-return-code-tf3780537.html#a10691634

Sent from the iBATIS - User - Java mailing list archive at Nabble.com.



Reply via email to