Re: [Squirrel-sql-users] Cannot browse object tree nodes

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

On 10/18/06, Lars Heill <Lar...@su...> wrote:
> Lars Heill wrote:
> > Hi,
> >
> > I have am trying to work against a local database.
> > Setting up SQuirreL to work with my own jdbc driver,
> > connecting and executing SQL was a snap.
> >
> > However, I was hoping to browse my db using the object tree.
> > Only I do not see any of my tables or views in the various
> > schemas, just a generic
> >
> >  <alias>
> >    <schema>
> >      SYSTEM TABLE
> >      TABLE
> >      VIEW
> >      UDT
> >
> > Refreshing "Tree and Cache" or "Item", I see my table names
> > flash by on the status line, but no tables/views show up in
> > the object tree.
> >
> > Might this be related to the FAQ item "I don't see an object
> > tree with PostgreSQL"?  If so, which metadata is my database
> > failing to supply?

DatabaseMetaData is used to build the object tree.  supportsSchemas or
supportsCatalogs need to return true.  Beyond that getTables needs to return
the tables for the selected schema/catalog.

>
> In case it matters: it is a JDBC 3.0 driver, and the database
> has 72 schemas.

I believe I've seen this issue with SQLBase in the past due to an incomplete
driver implementation.  What database and driver are you using?  Any exceptions
in the log?

Rob