Previous Topic: JDBC Naming AttributeNext Topic: Connector Xpress Logging


Sybase Stored Procedures Failure

Valid on Windows and UNIX

Symptom:

The following exception is reported when invoking Sybase stored procedures:

Nested exception is com.sybase.jdbc3.jdbc.SybSQLException: Stored procedure 'AddObject_Instead_Parameter' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

Solution:

CA IAM CS requires that Sybase stored procedures have the set chained option to on.

Set the chained option to on for all Sybase stored procedures.