|
From: Robert M. <rob...@gm...> - 2006-10-19 01:43:24
|
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 |
