In the "Columns" tab I always get a empty table with
the headers "COLUMN_NAME" etc. but no table content.
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Oracle Thin Driver
Squirrel 2.1 seems to be affected too.
Logged In: YES
We are going to need you to look at your log file to get
the exception(s) being thrown. I routinely use the 10g
driver to access 10g and 9i servers. I've never seen this
behavior. So, in order to help you with this, we'll need
the log file or parts of it (exceptions) to further analyze
the origin of the problem. The log is in
Logged In: NO
Sorry, there are no Exceptions in the log file.
Anyway, I tracked down the Problem further: Only the columns
for tables in "SYNONYM" node (a subnode of my schema node)
aren't listed. If I open the same tables from the other
schema, where they are a subnode of the "TABLE" node the
columns are shown. Hope this was clear enough.
Yes, that would explain it. A synonym is not a table, but an
alias for a table in another schema. I'll have a look at the
code and get back to you.
Logged In: YES
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).
I'm pretty sure this is a bug in Oracle.
I get the same behavior with Oracle 9i and
the 10g driver. I've attached a simple test
driver that you can modify to test against
your database if you want. It demonstrates
the API call that we use in SQuirreL to get
the column information. Apparently in Oracle,
this returns results for TABLE type objects,
but not for SYNONYM type objects. Best
thing to do would be to submit a bug to
Oracle - if you have a customer account.
I'm closing this since there isn't much we
can do about it.
Test driver to print columns of a synonym