No. I've only dug a little bit more but haven't really turned up
anything new. I was going to try a different jdk to see if the
interaction was any different, but then had issues with dbvisualizer
itself (I think it was a configuration issue). Given that there seems to
be some other problems with the DatabaseMetaData functions (see Aslak
Hellesoy post from last week) that probably wasn't going in the right
direction anyway.
Robert Treat
On Mon, 2002-07-08 at 08:59, Dave Cramer wrote:
> Robert,
>
> Did you get this sorted out?
>
> Dave
> On Thu, 2002-06-27 at 10:48, Robert Treat wrote:
> > I wondered about that, but in this case all of my tables are lowercase.
> > Since I've had to clean up mixed case implementations before, I also
> > lowercase everything else as well (functions, views, etc...)
> >
> > I decided to create a test database to see if I could further isolate
> > the problem. I used the following schema in that database:
> >
> > create table people (name char(10), number char(15));
> > insert into people values ('jenny','8675309');
> >
> > now I am able to select from the table with no problems, but when I try
> > to use the object browser, I now get this error:
> >
> > java.sql.SQLException: ERROR: no such attribute or function 'oid'
> > at org.postgresql.Connection.ExecSQL(Connection.java:533)
> >
> >
> > On the one hand this seems to imply that DatabaseMetaData.getTables is
> > working ok, but I think that maybe there is a problem with
> > DatabaseMetaData.getColumns?
> >
> >
> > Robert Treat
> >
> > On Thu, 2002-06-27 at 05:42, Holger Mitterwald wrote:
> > > Hello Robert,
> > >
> > > Robert Treat wrote:
> > >
> > > >[DEBUG] DB=myserver::mydb Cat=null Sch=null
> > > >Exception occured during event dispatching:
> > > >java.lang.NullPointerException
> > > > at
> > > > org.postgresql.jdbc2.DatabaseMetaData.getTables(DatabaseMetaData.java:1707)
> > > > at se.pureit.dbvis.Selector.getTablesFor(Selector.java:679)
> > > > etc...
> > > >
> > > >
> > > Just a blind guess as I run into the same exception with an other program:
> > >
> > > DatabaseMetaData.getTables() is case-sensitive, but PostgreSQL expects
> > > table names as lowercase (if not quoted with "'").
> > > So rename all your tables to lowercase.
> > >
> > > Best regards,
> > > Holger
> > >