The sybase Java eway throws com.sybase.jdbc2.jdbc.SybSQLException exceptions regarding transaction mode.

(Doc ID 1027397.1)

Last updated on OCTOBER 25, 2016

Applies to:

Sun e*Gate - Version 4.1.2 and later
Oracle Solaris on SPARC (32-bit)
Oracle Solaris SPARC (32-bit)
****Checked for relevance on 26-Sep-2013****

Symptoms

The Sybase Java eway throws 'com.sybase.jdbc2.jdbc.SybSQLException' exceptions,  regarding transaction mode:

    Stored procedure 'MessageFlow.dbo.proc_sample' may be run only in unchained transaction mode.
    
    The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms