The processing of stored procedures fails when IBM WebSphere Adapter for JDBC V126.96.36.199 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.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.