From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: [PATCH] NPE in meta data getPrimaryKeys() |
Date: | 2002-12-17 19:22:14 |
Message-ID: | 1040152934.16014.278.camel@inspiron.cramers |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Actually, I had a look at the spec more carefully and what i wrote
earlier will not work nor should it
in the jdk 1.4 docs catalog, and schema can be null, but table can't be
null, it has to match exactly, so it is true, either the driver iterates
through all the tables, or the user and since the spec indicates that
the user should, then I think the driver is correctly implemented
Dave
On Tue, 2002-12-17 at 13:04, Dave Cramer wrote:
> 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(at)checkforte(dot)com(dot)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(at)micro-automation(dot)net>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2002-12-17 19:42:47 | Re: Strange behaviour of JDBC driver for PostgreSQL |
Previous Message | Dave Cramer | 2002-12-17 18:04:57 | Re: [PATCH] NPE in meta data getPrimaryKeys() |