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

Technote (troubleshooting)


Problem(Abstract)

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.

Symptom

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.

Cause

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.


Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Adapters
Adapter for JDBC

Software version:

7.0, 7.0.0.1, 7.0.0.2, 7.0.0.3

Operating system(s):

All Platforms

Reference #:

1617168

Modified date:

2012-12-27

Translate my page

Machine Translation

Content navigation