squirrel-sql-users

[Squirrel-sql-users] Oracle: No tables shown

[David H. <dav...@jp...>]

I am using SQuirreL 2.2final with the Oracle 10.1.0.2.0 JDBC client to
connect to an Oracle 10g database cluster.  The cluster has a large number
of database instances.  Once connected (speed is normal compared to the
other databases I connect), the available tables and instances are not shown
within the Objects tab.  The folder browser is shown, just nothing in them
to select or browse.  SQL commands do work against the various tables. 
Connections to other non-clustered Oracle 10g databases work as expected,
being I am able to see and browse the various objects.  Earlier versions of
the JDBC had the same result.  Is there a program setting or definition I've
mis-configured?
-- 
View this message in context: http://www.nabble.com/Oracle%3A-No-tables-shown-tf1902336.html#a5205199
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] Oracle: No tables shown

[Maury H. <ml1...@sh...>]

David:

> I am using SQuirreL 2.2final with the Oracle 10.1.0.2.0 JDBC client to
> connect to an Oracle 10g database cluster.  The cluster has a large number
> of database instances.  Once connected (speed is normal compared to the
> other databases I connect), the available tables and instances are not shown
> within the Objects tab.  The folder browser is shown, just nothing in them
> to select or browse.  SQL commands do work against the various tables. 
> Connections to other non-clustered Oracle 10g databases work as expected,
> being I am able to see and browse the various objects.  Earlier versions of
> the JDBC had the same result.  Is there a program setting or definition I've
> mis-configured?

I haven't seen that problem, but I have access to a couple of Oracle 
clusters so I can see if it happens to me as well.  What are you using 
for your connection string?


Maury



-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.9/382 - Release Date: 04/07/2006

Re: [Squirrel-sql-users] Oracle: No tables shown

[David H. <dav...@jp...>]

Connection string used with cluster farm:
jdbc:oracle:thin:@indigo.de.ifs.net:1968:ecqsprd
-- 
View this message in context: http://www.nabble.com/Oracle%3A-No-tables-shown-tf1902336.html#a5253091
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] Oracle: No tables shown

[Maury H. <ml1...@sh...>]

David:
> Connection string used with cluster farm:
> jdbc:oracle:thin:@indigo.de.ifs.net:1968:ecqsprd

I used a connection string similar to yours to connect to a database on 
our cluster and had no problems at all -- I was using the same versions 
of SQuirreL and the Oracle JDBC driver.  I don't remember if you said 
what version of Oracle you're running.

In your original message you said something like "Each cluster has a lot 
of database instances".  Did you actually mean "instances" or did you 
mean "schemas"?

Since you're only connecting to one instance at a time, the number of 
database instances on a server shouldn't matter to SQuirreL, but if you 
meant many schemas in a database, then maybe (and this is a WAG) there 
are too many schemas in your database for SQuirreL to handle and 
something overflows causing the problem with the Object tab.  If you did 
mean schemas, how many do you have in the database?  If you didn't mean 
schemas, then I'm not sure why you would have problems.

Maury


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.0/388 - Release Date: 7/13/2006

Re: [Squirrel-sql-users] Oracle: No tables shown

[David H. <dav...@jp...>]

It's not a Squirrel problem.  Did some checking with other tools. Seems to be
a quirk with the way the cluster is configured (or my account).

Although the connection string connects me to the proper database/schema
(and this is the strange part), it does not make that database/schema the
default for queries.  So if I do a 'DESC TABLE_A', the query will fail as it
doesn't know which database/schema the table belongs.  If I do 'DESC
ECQSPRD.TABLE_A', it'll work.

Doesn't matter that I can't see or have rights any other database/schema
other than ECQSPRD.  Using 'ALTER SESSION SET current_schema=ECQSPRD' 
doesn't make a difference to anything but the command line session.

Even Oracle's tools (SQLPlus, SQL Developer) have the same problem.  They
can't see the table, but will allow me to manually query/view them provided
I specify which database/schema has the target table.

Would there be a setting in Squirrel that would allow me to bypass this
quirk (I'd love to be able to browse tables through the GUI)?  My DBAs swear
the cluster configuration is correct (not a bug, but a feature thing).
-- 
View this message in context: http://www.nabble.com/Oracle%3A-No-tables-shown-tf1902336.html#a5745528
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] Oracle: No tables shown

[Robert M. <rob...@gm...>]

On 8/10/06, David Holsinger <dav...@jp...> wrote:
> Would there be a setting in Squirrel that would allow me to bypass this
> quirk (I'd love to be able to browse tables through the GUI)?  My DBAs swear
> the cluster configuration is correct (not a bug, but a feature thing).

David,

So if you look in the object tree, and click on the root node, then
click on the
"Schemas" tab, you see no schemas, is that correct?

Some jdbc drivers accept properties that allow you to modify some session
defaults using the jdbc url.  I don't believe that Oracle's jdbc
driver reports any
properties (at least they don't appear in the properties list when I modify an
Oracle alias - which indicates that the driver reported no user modifiable
properties).  But you may want to verify this with your driver and/or driver
documentation.

Rob