ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sven Boden <list...@pandora.be>
Subject Re: Sybase Stored procedure transaction mode
Date Sat, 04 Mar 2006 20:13:33 GMT

Has been seen before as in 

 From the Sybase manuals:

"Sybase Error 7713: Stored Procedure can only be executed in unchained 
transaction mode" error

This error occurs when either:

    * The JDBC attempts to put the connection in *autocommit(true)* mode.
    * A stored procedure is not created in a compatible mode.

To fix the *autocommit(true)* mode problem, let the application change 
the connection to chained mode using the 
*Connection.setAutoCommit(false)* mode, or use a *set chained on* 
language command.

To resolve the stored procedure problem, use the sp_procxmode 
/procedure_name/ "anymode" command.


Suman.Mishra@ubs.com wrote:

>I am executing Sybase stored procedure through iBatis. Exception occurs when the 
>procedure is defined in "unchained" mode. If I set the mode as "anymode", it 
>works fine.
>Can someone please let me know how to get the procedures working while I have 
>procs in "unchained" transaction mode.
>Note: Its sybase error no - 7713
>Suman Mishra
>Visit our website at http://www.ubs.com
>This message contains confidential information and is intended only 
>for the individual named.  If you are not the named addressee you 
>should not disseminate, distribute or copy this e-mail.  Please 
>notify the sender immediately by e-mail if you have received this 
>e-mail by mistake and delete this e-mail from your system.
>E-mail transmission cannot be guaranteed to be secure or error-free 
>as information could be intercepted, corrupted, lost, destroyed, 
>arrive late or incomplete, or contain viruses.  The sender therefore 
>does not accept liability for any errors or omissions in the contents 
>of this message which arise as a result of e-mail transmission.  If 
>verification is required please request a hard-copy version.  This 
>message is provided for informational purposes and should not be 
>construed as a solicitation or offer to buy or sell any securities or 
>related financial instruments.

View raw message