Re: [JDBC] Need help with JDBC driver. Problem, - getExportedKeys =

2001-09-16 Thread Justin Clift
Hi René, Did you see my email to the JDBC mailing list earlier today, in response to someone question regarding finding out RI information from the PostgreSQL system catalogs? >From that email, the SQL needed to find out the RI triggers is : SELECT c.relname as "Trigger Table", substr(f.proname

Re: [JDBC] Need help with JDBC driver. Problem, - getExportedKeys=

2001-09-09 Thread Rene Pijlman
On Sat, 01 Sep 2001 17:43:39 +0200, you wrote: >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 list

Re: [JDBC] Need help with JDBC driver. Problem, - getExportedKeys

2001-09-04 Thread Gunnar Rønning
* Keve Müller <[EMAIL PROTECTED]> wrote: | | An initial version for get(Imported|Exported)Keys and getCrossReference is | available in jxDBCon (http://jxbdcon.sf.net) the file can be extracted Do you only concentrate on compliance or is performance important as well ? Have you done any performan

Re: [JDBC] Need help with JDBC driver. Problem, - getExportedKeys=

2001-09-04 Thread Roger Bjärevall
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. Howeve

Re: [JDBC] Need help with JDBC driver. Problem, - getExportedKeys

2001-09-04 Thread Keve Müller
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 > docume

Re: [JDBC] Need help with JDBC driver. Problem, - getExportedKeys = Driver.notImplemented() exception

2001-09-01 Thread Rene Pijlman
On Sat, 01 Sep 2001 21:26:52 +1000, Justin Clift wrote: >Does anyone know if we're planning on adding the Java >class/function/method/whatever called getExportedKeys? ... >In discussing this with Roger (the Product Manager of Innovative-IT who >has created this program), he says our JDBC driver g

[JDBC] Need help with JDBC driver. Problem, - getExportedKeys = Driver.notImplemented() exception

2001-09-01 Thread Justin Clift
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