8 Apr 2010 06:08
Re: Oracle 11g Tables Schemas Catalogs do no display in Objects tab
Robert Manning <robert.m.manning <at> gmail.com>
2010-04-08 04:08:32 GMT
2010-04-08 04:08:32 GMT
Hi JR,
In an Oracle database, the user always has a schema with the same name. This common case is supported without additional configuration. However, in some database instances, the user has been granted access to other schemas, in which case you can configure them to be loaded into the object tree via "Alias Properties" (Right-click on the Alias). In the dialog choose the Schemas tab and click "Specify Schema loading and caching" and choose "Load and cache" or "Load and don't cache" for the objects (Tables, Views and Procedures) in the schemas that you have access to and want to see loaded into the object tree. After which, future connections to the database should populate the object tree according to your preferences.
Rob
On Wed, Apr 7, 2010 at 11:25 PM, JR Ruggentaler <jr <at> mpv.com> wrote:
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 getCatalogsTRACE_1: Public Enter:Apr 7, 2010 9:16:56 PM oracle.jdbc.driver.OracleStatement doExecuteWithTimeoutCONFIG: SQL: select 'nothing' as table_cat from dual where 1 = 2Apr 7, 2010 9:16:56 PM oracle.jdbc.OracleDatabaseMetaData getCatalogsTRACE_1: return: oracle.jdbc.driver.OracleResultSetImpl <at> 3861e6Apr 7, 2010 9:16:56 PM oracle.jdbc.OracleDatabaseMetaData getCatalogsTRACE_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
------------------------------------------------------------------------------ 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
RSS Feed