From: | Roger Bjärevall <roger(at)ideit(dot)com> |
---|---|
To: | Keve Müller <keve(at)keve(dot)hu> |
Cc: | pgsql-jdbc(at)postgresql(dot)org, Justin Clift <justin(at)postgresql(dot)org>, Rene Pijlman <rene(at)lab(dot)applinet(dot)nl> |
Subject: | Re: Need help with JDBC driver. Problem, - getExportedKeys= |
Date: | 2001-09-01 15:43:39 |
Message-ID: | 3B91022B.4F5B0305@ideit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
I've tried the jxdbcon driver now and it gives another view
of the actual database... I am not a PostgreSQL guy so I am
quite confused here. Anyway, this one seems to give the most
appropriate view of the database since the system tables
are listed which the pgsql drivers did not list. However, I do not
get anything back from any table when issuing the getExported/Imported
keys in DatabaseMetaData. This might be an effect of me not
having any tables with primary-foreign key mappings. Could anyone
point me to a place where I can download/get some simple SQL
statements to create at least relationsships between two tables?
I really would like to verify DbVisualizer with PostgreSQL since
more and more people requires support for it.
Best regards
Roger
Keve Müller wrote:
>
> Hi all.
>
> > He's right. The DatabaseMetaData.getExportedKeys() method is
> > simply not yet implemented, both in the jdb1 and the jdbc2
> > driver. Its open for development.
> >
> > If someone can write the query on the system catalogs I'll be
> > glad to implement the Java code and a test case. The
> > documentation of the info we need is available on
> > http://java.sun.com/j2se/1.3/docs/api/java/sql/DatabaseMetaData.html
> > (look for getExportedKeys).
>
> An initial version for get(Imported|Exported)Keys and getCrossReference is
> available in jxDBCon (http://jxbdcon.sf.net) the file can be extracted
> automatically from CVS under
> http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/~checkout~/jxdbcon/src/org/sourceforge/jxdbcon/postgresql/PGDatabaseMetaData.java?rev=1.21&content-type=text/plain
> Feel free to use it for a quick start.
>
> Initial means:
> - not tested
> - don't like its algorithm
> -> needs to be improved
> But nevertheless it works.
>
> Regargs,
>
> Keve
From | Date | Subject | |
---|---|---|---|
Next Message | Rene Pijlman | 2001-09-01 20:38:01 | Re: Re: Proposal to fix Statement.executeBatch() |
Previous Message | Rene Pijlman | 2001-09-01 14:05:33 | Re: max connections |