Details
-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
9.1.1
-
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