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
> 




---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx