IBM Support

WebSphere Adapter for JDBC Enterprise Service Discovery fails when trying to import a stored procedure from a Sybase database

Troubleshooting


Problem

At design time, the WebSphere Adapter for JDBC enterprise service discovery fails when it tries to import a stored procedure.

Symptom

The WebSphere Adapter for JDBC enterprise service discovery fails with the following error:

Cannot add object to selection:

com.sybase.jdbc2.jdbc.SybSQLException: The "CREATE TABLE" is not
allowed within a multi-statement transaction in 'tempdb' database.

The problem appears when using the jConnect driver, for both version 5.5
(jdbc2 from jconn2.jar) and 6.0 (jdbc3 from jconn3.jar). The problem does not occur when using the jTDS 1.2.2 driver.

Cause

Autocommit is not set during enterprise service discovery.

Resolving The Problem

Apply JDBC 6.0.2.3 IF1 or above. Contact IBM Software Support to obtain this Interim Fix. After applying the Interim Fix, set Autocomit by expanding Advanced properties and selecting Autocommit.

You can contact IBM Software Support in one of two ways:

[{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter for JDBC","Platform":[{"code":"PF033","label":"Windows"}],"Version":"6.2","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 June 2018

UID

swg21292988

Page Feedback