[Squirrel-sql-users] No Object tree for Informix SE

[Gang C. <gan...@sp...>]

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 ?=20

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(JdbcOdbcDatabaseMetaDa=
ta.java:2471)
	at =
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDa=
tabaseMetaData.java:353)
	at =
net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox.setConnection(SQL=
CatalogsComboBox.java:70)
	at =
net.sourceforge.squirrel_sql.client.session.SessionSheet$MyToolBar.<init>=
(SessionSheet.java:367)
	at =
net.sourceforge.squirrel_sql.client.session.SessionSheet.createUserInterf=
ace(SessionSheet.java:304)
	at =
net.sourceforge.squirrel_sql.client.session.SessionSheet.<init>(SessionSh=
eet.java:90)
	at =
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasComman=
d$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.j=
ava: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.ObjectTr=
ee  - 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(JdbcOdbcDatabaseMetaDa=
ta.java:2471)
	at =
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDa=
tabaseMetaData.java:353)
	at =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expander=
s.DatabaseExpander.createCatalogNodes(DatabaseExpander.java:159)
	at =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expander=
s.DatabaseExpander.createChildren(DatabaseExpander.java:122)
	at =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr=
ee$TreeLoader.loadChildren(ObjectTree.java:668)
	at =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr=
ee$TreeLoader.execute(ObjectTree.java:619)
	at =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr=
ee.expandNode(ObjectTree.java:355)
	at =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr=
ee.access$600(ObjectTree.java:63)
	at =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTr=
ee$ExpansionController.run(ObjectTree.java:576)
	at =
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:6=
5)
	at java.lang.Thread.run(Thread.java:534)