[teiid-issues] [JBoss JIRA] (TEIID-4919) Sybase 15.7: running into'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

[Ivan Chan (JIRA)]

Ivan Chan created TEIID-4919:
--------------------------------

             Summary: Sybase 15.7:  running into'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.
                 Key: TEIID-4919
                 URL: https://issues.jboss.org/browse/TEIID-4919
             Project: Teiid
          Issue Type: Bug
          Components: JDBC Connector
    Affects Versions: 9.1.1
            Reporter: Ivan Chan
            Assignee: Steven Hawkins


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



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)