[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.

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