Need help with JDBC driver. Problem, - getExportedKeys = Driver.notImplemented() exception - Mailing list pgsql-jdbc

Hi all,

Does anyone know if we're planning on adding the Java
class/function/method/whatever called getExportedKeys?  (I'm not a Java
programmer).

I've been looking at the free Java product called DbVisualizer
(http://www.ideit.com/innovations/dbvis/), which can connect to a
database and create an ER diagram from it, including RI information and
everything.  Presently it supports several databases happily, but the
PostgreSQL JDBC 7.1.3 driver isn't passing information to it regarding
the RI relationships.  So for PostgreSQL it gives a nice display of all
the tables, but no display of their relationships.

Here's a screenshot of what it's supposed to display, when all the RI
relationships are shown :

http://www.ideit.com/innovations/dbvis/images/dbvis-4.gif

In discussing this with Roger (the Product Manager of Innovative-IT who
has created this program), he says  our JDBC driver gives a
Driver.notImplemented() exception when trying to find out the RI info.
(Email history detailed below).

Can anyone please assist with this?

Regards and best wishes,

Justin Clift

************

Justin,

Now I have a running 7.1.3 version of PostgreSQL.
Regarding the ref. integrity stuff. The driver
only implements getImportedKeys() but the getExportedKeys
throws a Driver.notImplemented() exception. Is there are
reason for this? (I mean if it is possible to return
imported keys then I assume exported keys could be returned
as well?)

Also, using a previous version of the driver just shows
functions in the tree while the 7.1.3 version shows
databases as well. Is this something that you are aware of?

Can you send me a SQL script that creates at least 2 tables and
the SQL to establish the foreign key relationsships between them
(referential integrity)? So I can manage to test this.
(I have browsed the documentation but cannot
find a word whether PostgreSQL supports ref. integrity or not).

Regards

Roger

Justin Clift wrote:
>
> Hi Roger,
>
> The place to get the latest RPM's for RedHat is :
>
> ftp://ftp.jack-of-all-trades.net/www.postgresql.org/binary/v7.1.3/RPMS/
>
> I would recommend making sure Ant and the 1.3.x JDK is installed on your
> system, then compiling PostgreSQL 7.1.3 from the source RPM or from
> source.
>
> There are JDBC drivers available from http://jdbc.fastcrypt.com, not
> sure which versions of the driver are there.
>
> One thing I did notice, is that DbVisualizer doesn't like the JDBC
> drivers for PostgreSQL 7.1.2 (which are supposed to work with any 7.1.x
> release), but it definitely DID like the JDBC drivers compiled with
> PostgreSQL 7.1.3.  That's my reason behind recommending compiling
> PostgreSQL 7.1.3 yourself, as the JDBC drivers are compiled along with
> it (./configure --enable-java if you need to know the command for the
> source archive).
>
> Hope all that's helpful.
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
> Roger Bjärevall wrote:
> >
> > Justin,
> >
> > If you could point me to a place where I can download the latest
> > RPM's and JDBC driver for Linux RedHat then I will give it a try
> > in a couple of days.
> >
> > Regards
> >
> > Roger
> >
> > Justin Clift wrote:
> > >
> > > Hi,
> > >
> > > Would you guys like some assistance getting DbVisualizer working with
> > > PostgreSQL?  The only thing I can see that is missing is the recognition
> > > of Referential Integrity relationships in PostgreSQL databases.
> > >
> > > :-)
> > >
> > > Regards and best wishes,
> > >
> > > Justin Clift
> > >
> > > --
> > > "My grandfather once told me that there are two kinds of people: those
> > > who work and those who take the credit. He told me to try to be in the
> > > first group; there was less competition there."
> > >      - Indira Gandhi
> >
> > --
> > Roger Bjärevall
> > Product Manager
> >
> > Innovative-IT
> > Södermannagatan 48
> > Box 20129
> > SE-104 60 Stockholm
> > Phone:  +46 8 55602760
> > Direct: +46 8 55602775
> > Mobile: +46 709 242012
> > roger.bjarevall@ideit.com
> > http://www.ideit.com
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
>      - Indira Gandhi

--
Roger Bjärevall
Product Manager

Innovative-IT
Södermannagatan 48
Box 20129
SE-104 60 Stockholm
Phone:  +46 8 55602760
Direct: +46 8 55602775
Mobile: +46 709 242012
roger.bjarevall@ideit.com
http://www.ideit.com