#370 Columns Tab doesn't show columns

2.2rc1
closed
Rob Manning
Core (461)
5
2014-08-20
2006-04-05
Anonymous
No

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.

Discussion

  • Rob Manning
    Rob Manning
    2006-04-05

    • assigned_to: colbell --> manningr
    • status: open --> pending
     
  • Rob Manning
    Rob Manning
    2006-04-05

    Logged In: YES
    user_id=1287991

    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
    <user.home>/.squirrel-sql/logs/squirrel-sql.log

    Rob Manning

     
  • 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.

    Regards

    Bastian

     
  • Rob Manning
    Rob Manning
    2006-04-06

    Logged In: YES
    user_id=1287991

    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.

    Rob

     
  • Logged In: YES
    user_id=1312539

    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).

     
    • status: pending --> closed
     
  • Rob Manning
    Rob Manning
    2006-04-20

    Logged In: YES
    user_id=1287991

    Bastian,

    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.

    Rob

     
  • Rob Manning
    Rob Manning
    2006-04-20

    Test driver to print columns of a synonym