Re: DBVisualizer Null Pointer Exception

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
>