Re: [PATCH] NPE in meta data getPrimaryKeys() - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: [PATCH] NPE in meta data getPrimaryKeys()
Date
Msg-id 1040148296.17038.269.camel@inspiron.cramers
Whole thread Raw
In response to Re: [PATCH] NPE in meta data getPrimaryKeys()  (Daniel Serodio <daniel@checkforte.com.br>)
Responses Re: [PATCH] NPE in meta data getPrimaryKeys()
List pgsql-jdbc
Have you tried getPrimaryKeys(null, "", "%");

This should give you all the primaryKeys

Dave
On Tue, 2002-12-17 at 12:44, Daniel Serodio wrote:
> On Tue, 2002-12-17 at 15:36, Anders Hermansen wrote:
> > * Daniel Serodio (daniel@checkforte.com.br) wrote:
> > > Old Javadoc indeed. I'm using 1.3.1. I can't recall right now, is the
> > > JDBC in Java 1.3.1 is JDBC2? Maybe the app (reversedb) should try to
> > > find out if it's talking to JDBC2 or JDBC3, then use table=null or not
> > > accordingly. Is this viable?
> >
> > At what we have found out here, it should not use table=null in either
> > case. Right?
>
> Right. Sorry, I meant to say schema=null
>
> > But this "extension" (table=null) must work with some database drivers
> > since it is in OJB. Maybe it is an "extension" that postgresql driver
> > should also have?
> >
> > If this "extension" is not available then reversedb must iterate through
> > every table and do very many getPrimeryKeys, this will probably need a
> > lot more computer power?
>
> If I understand this correctly, if we were to implement this
> functionality in the PostgreSQL driver, the driver would have to iterate
> thru every table, so the only difference is where the iteration is done
> (reversedb X postgresql driver).
>
> > Anders
> >
> > --
> > Anders Hermansen
> > YoYo Mobile as
--
Dave Cramer <Dave@micro-automation.net>


pgsql-jdbc by date:

Previous
From: Daniel Serodio
Date:
Subject: Re: [PATCH] NPE in meta data getPrimaryKeys()
Next
From: Carlos Correia
Date:
Subject: Strange behaviour of JDBC driver for PostgreSQL