IBM Support

Using WebSphere Adapter for JDBC V7.0.0.3 with Sybase database stored procedures

Technote (troubleshooting)


The processing of stored procedures fails when IBM WebSphere Adapter for JDBC V7.0.0.3 tries to execute Sysbase stored procedures in chained mode.


IBM WebSphere Adapter for JDBC generates the following error in the logs when trying to execute Sysbase stored procedures:

ResourceException thrown in J2CMethodBindingImpl.invoke() javax.resource.ResourceException: Stored procedure 'db.SP_ac_temp' may be run only in unchained transaction mode.


This error is thrown when Adapter tries to execute the stored procedures in chained mode, while Sysbase runs its stored procedures in unchained transaction mode by default.

Resolving the problem

To work around this restriction, you must turn on the auto commit feature of the Adapter. This allows each transaction to be committed irrespective of any settings in the client's stored procedures.

To set the Auto commit Connection factory setting:
- Check the AutoCommit checkbox during Adapter configuration in the external service wizard.

To set the Auto commit on Embedded/Standalone Adapters:
- The setting logged in the Administration Console takes precedence over the setting logged in the Adapter.
- In the Administration Console, select Resources => Resource Adapters => Deployed Adapter.
- Set AutoCommit to true and save the changes.

Document information

More support for: WebSphere Adapters Family
Adapter for JDBC

Software version: 7.0,,,

Operating system(s): All Platforms

Reference #: 1617168

Modified date: 27 December 2012

Translate this page: