Oracle 11g Tables Schemas Catalogs do no display in Objects tab

I can connect to my Oracle 11g and 10g servers using SQuirreLSQL but in the Objects tab when I click on the
TABLE node nothing shows up. In the Schemas tab nothing shows up also. Can someone provide a screenshot of
what I should see in the Objects tree view with TABLE clicked? Is there some way to select a schema to view
tables from the SQuirreLSQL UI? I did include my schema name in the "Edit Objects Filter" and refreshed the
tree and cache to no avail.

This looks like an issue with the metadata. I downloaded the latest SQuirreLSQL code and got it to build run
and debug in eclipse. I also downloaded the debug version of the Oracle 11g JDBC driver and turned
debugging on in the JDBC driver. I did notice that the JDBC driver generated some SQL (select 'nothing' as
table_cat from dual where 1 = 2) that I don't understand to get the catalogs. I ran the SQL from SQuirreLSQL
and it returns 0 rows. What are catalogs used for in the SQuirreLSQL UI. I also wanted to mention that the
Oracle user name I logon with is not the same as the schema I want to see. For example my user name is FOO_USER
and database schema is FOO. The getSchemas() method lists all the schemas in the database and
getCatalogs() return nothing.

Apr 7, 2010 9:16:56 PM oracle.jdbc.OracleDatabaseMetaData getCatalogs
TRACE_1: Public Enter: 
Apr 7, 2010 9:16:56 PM oracle.jdbc.driver.OracleStatement doExecuteWithTimeout
CONFIG: SQL: select 'nothing' as table_cat from dual where 1 = 2
Apr 7, 2010 9:16:56 PM oracle.jdbc.OracleDatabaseMetaData getCatalogs
TRACE_1: return: oracle.jdbc.driver.OracleResultSetImpl <at> 3861e6
Apr 7, 2010 9:16:56 PM oracle.jdbc.OracleDatabaseMetaData getCatalogs
TRACE_1: Exit

I use JDBC and eclipse daily so I can help debug if some one can point me to the code that's responsible for the
Objects view. I did a little digging around and found SchemaInfo and SchemaInfoCache that look like the
classes involved in getting and caching the mata data.

Thanks in advance!
JR 

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users