Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4919

Sybase 15.7: running into'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • 9.1.1
    • JDBC Connector
    • None

    Description

      When I try to build VDB with sybase ASE 15.7 odb schema, I run into the following error:

      Caused by: java.sql.SQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

      at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybStatement.nextResult(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybStatement.nextResult(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybCallableStatement.executeQuery(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.if(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.getColumns(Unknown Source)
      at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:218)
      at org.teiid.translator.jdbc.JDBCMetdataProcessor.getColumns(JDBCMetdataProcessor.java:382)
      at org.teiid.translator.jdbc.JDBCMetdataProcessor.getTables(JDBCMetdataProcessor.java:334)
      at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:173)
      at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:306)
      ... 182 more

      I am using this driver: jconn4.jar [ com.sybase.jdbc4.jdbc.SybDriver ]
      And org.teiid.translator.jdbc.sybase.SybaseExecutionFactor

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            mchantibco Ivan Chan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: