Re: DBVisualizer Null Pointer Exception - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: DBVisualizer Null Pointer Exception
Date
Msg-id 1026133184.516.63.camel@inspiron.cramers
Whole thread Raw
In response to Re: DBVisualizer Null Pointer Exception  (Robert Treat <rtreat@webmd.net>)
Responses Re: DBVisualizer Null Pointer Exception
List pgsql-jdbc
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
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>






pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: [SOLVED]Re: Retrieving binary data
Next
From: Dave Cramer
Date:
Subject: Re: [Middlegen-user] Try other one of Postgresql JDBC Driver