Fetch/state errors when output params returned  Custom socket implementation error

Chapter 3: Troubleshooting

Stored procedure executed in unchained transaction mode

Sybase Error 7713 - Stored Procedure can only be executed in unchained transaction mode.

JDBC attempts to put the connection in autocommit(true) mode. The application can change the connection to chained mode using Connection.setAutoCommit(false) or by using a “set chained on” language command. This error occurs if the stored procedure was not created in a compatible mode.

To fix the problem, use:

sp_procxmode procedure_name,"anymode"




Copyright © 2003. Sybase Inc. All rights reserved. Custom socket implementation error

View this book as PDF