Hi, after clicking on the "content" tab I get the following message:
Logged by net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab at 8/5/14 5:31 AM:
the stactrace is:
java.sql.SQLException: No MST is currently in progress, cannot declare another cursor.
at com.ingres.gcf.util.SqlExType.getSqlEx(SqlExType.java:127)
at com.ingres.gcf.util.SqlExFactory.get(SqlExFactory.java:96)
at com.ingres.gcf.jdbc.DrvObj.readError(DrvObj.java:852)
at com.ingres.gcf.jdbc.JdbcStmt.readError(JdbcStmt.java:2963)
at com.ingres.gcf.jdbc.DrvObj.readResults(DrvObj.java:636)
at com.ingres.gcf.jdbc.JdbcStmt.readResults(JdbcStmt.java:2860)
at com.ingres.gcf.jdbc.JdbcStmt.readResults(JdbcStmt.java:2811)
at com.ingres.gcf.jdbc.JdbcStmt.exec(JdbcStmt.java:1586)
at com.ingres.gcf.jdbc.JdbcStmt.executeQuery(JdbcStmt.java:485)
at com.ingres.gcf.jdbc.JdbcDBMD.getColumns(JdbcDBMD.java:7382)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1749)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1838)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab.createDataSet(ContentsTab.java:357)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:128)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:745)
For your your information: the database I am connected to is Actian
Vectorwise version 3.0.1. I use the iijdbc.jar jdbc driver.
In the faq (http://squirrel-sql.sourceforge.net/index.php?page=faq#faq6)
I found this hint:
Right-click on the schema in the explorer and select refresh,
objects should appear as normal.
Unfortunately this does not work. Can you help me to get this fixed or
can you confirm that this is a bug? My squirrel version is now 3.5.3 - in version 3.5.0 this worked fine.
Regards
ohuqh
I have the same problem with version 4.1.0 but I found a solution that worked for me:
I changed the driver properties for the connection to autocommit_mode: "multi".
Just right click on the alias in the "alias explorer", choose "Modify Alias..." and open the "Driver properties"-Tab. Check the box "Use driver properties" and then check the box next to "autocommit_mode" and choose the value: "multi".