[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)]

    [ https://issues.jboss.org/browse/TEIID-4919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13409220#comment-13409220 ] 

Ivan Chan commented on TEIID-4919:
----------------------------------

Let me try it out.  I will get back to you soon.  Thanks!

> 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)