|
From: Colin B. <col...@bi...> - 2004-04-01 11:17:18
|
On Mon, Mar 08, 2004 at 01:10:41PM -0500, Gang Cheng wrote: > Hi: > > I am a first time user. When configuring it to point an Informix SE (standard engine), I do not get the object tree, > although I can issue sql statements from the sql editor. I tried to use both the JDBC driver from Informix and the JDBC-ODBC bridge > from Sun, both have the same problem. Does anyone experience the same problem for Informix database ? I tried the same driver on another > tool DB Visualizer (http://www.minq.se/products/dbvis) with the same JDBC driver, I can see the object tree there. May be a bug in > the object tree rendering code of Squirrel ? > > I am using SQuirreL SQL Client Version 1.1final1. My JVM version is SUN JDK 1.4.2_03-b02. > > I do not get error message in the JDBC driver case. For the JDBC-ODBC driver, I am getting > this error: > > 123393 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.client.session.SessionSheet - Unable to retrieve catalog info > java.sql.SQLException: [Informix][Informix ODBC Driver]Driver does not support this function. > at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) > at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) > at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5519) > at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcDatabaseMetaData.java:2395) > at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getCatalogs(JdbcOdbcDatabaseMetaData.java:2471) > at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDatabaseMetaData.java:353) > at net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox.setConnection(SQLCatalogsComboBox.java:70) > at net.sourceforge.squirrel_sql.client.session.SessionSheet$MyToolBar.<init>(SessionSheet.java:367) > at net.sourceforge.squirrel_sql.client.session.SessionSheet.createUserInterface(SessionSheet.java:304) > at net.sourceforge.squirrel_sql.client.session.SessionSheet.<init>(SessionSheet.java:90) > at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:419) > at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178) > at java.awt.EventQueue.dispatchEvent(EventQueue.java:454) > at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) > at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) > at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) > at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) > at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) > 123549 [Thread-1] ERROR net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree - Error: SE ODBC > java.sql.SQLException: [Informix][Informix ODBC Driver]Driver does not support this function. > at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) > at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) > at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5519) > at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcDatabaseMetaData.java:2395) > at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getCatalogs(JdbcOdbcDatabaseMetaData.java:2471) > at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDatabaseMetaData.java:353) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander.createCatalogNodes(DatabaseExpander.java:159) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander.createChildren(DatabaseExpander.java:122) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.loadChildren(ObjectTree.java:668) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.execute(ObjectTree.java:619) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.expandNode(ObjectTree.java:355) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.access$600(ObjectTree.java:63) > at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$ExpansionController.run(ObjectTree.java:576) > at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:65) > at java.lang.Thread.run(Thread.java:534) > > > This error says that the ODBC driver doesn't support the function required to list the database tables. What error do you get with the native JDBC driver? -- Colin Bell http://squirrel-sql.sf.net |
