I UNselected "Auto Commit SQL" on the "SQL" tab of "New
Session Properties", closed my old session, and started
a new one. Now if I select a table name in the Objects
view to see its properties, the properties window
remains blank and this error is written to the log:
275120 [Thread-2] ERROR
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab
-
com.sybase.jdbc3.jdbc.SybSQLException: The 'CREATE
TABLE' command is not allowed within a multi-statement
transaction in the 'tempdb' database.
at com.sybase.jdbc3.tds.Tds.processEed\(Tds.java:2942\)
at com.sybase.jdbc3.tds.Tds.nextResult\(Tds.java:2246\)
at
com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at
com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
at
com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
at
com.sybase.jdbc3.jdbc.SybStatement.queryLoop(SybStatement.java:1698)
at
com.sybase.jdbc3.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.java:103)
at
com.sybase.jdbc3.jdbc.SybDatabaseMetaData.returnResults(SybDatabaseMetaData.java:2543)
at
com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getColumns(SybDatabaseMetaData.java:1983)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDatabaseMetaData.java:1846)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDatabaseMetaData.java:1867)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ColumnsTab.createDataSet(ColumnsTab.java:71)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:534)
Database is: Sybase Adaptive Server
Enterprise/12.5.2/EBF 12054 ESD#2/P/Sun_svr4/OS
5.8/ase1252/1844/64-bit/FBO/Thu Aug 12 10:51:11 2004
JDBC driver is: jConnect (TM) for JDBC(TM)/6.0(Build
25308)/P/EBF11817/JDK14/Fri Feb 27 20:57:29 2004
Logged In: YES
user_id=233132
Does this still occur in SQuirreL .23final?
Logged In: YES
user_id=1169199
Yes it does still happen in .23 final.
Logged In: YES
user_id=233132
This is a problem with the JDBC driver. Certain metadata
driver calls run DDL in thetemp dataabse which causes this
problem. Is there a more up to date version of the driver?
Logged In: YES
user_id=233132
If a later version of the driver doesn't fix the issue you
could try the following:
Right click on the alis and take "Alias properties". Click
on the Properties button, then click on the 'driver
properties' tab. Activate the "use driver properties"
checkbox. Click on the checkbox USE_METADATA and change
its value to false. Press OK
If that doesn't work then try:
Right click on the alis and take "Alias properties". Click
on the Properties button, then click on the 'driver
properties' tab. Activate the "use driver properties"
checkbox. Click on the checkbox 'SQLInitString' and change
its value to "set chained off". Press OK