Thread: is anyone use executeQuery with autogeneratedkeys function ?
Hi,
I'm trying to use a new function jdk 1.4.0 named executeQuery(sql,autogeneratedkeysFlag) with postgresql 7.2.
Is this function implemented and ready to use with a new jdk1.4.0 compiled jdbc driver ?
thanks for the answer.
Ludovic SMADJA
Webcell
ICQ#:70047519
tel. 01 40 47 56 31
fax. 01 40 47 56 34
port. 06 72 28 78 71
Ludovic,
Unfortunately no, none of the jdbc3.0 functions have been implemented.
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of ludovic smadja
Sent: Tuesday, March 05, 2002 4:18 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] is anyone use executeQuery with autogeneratedkeys function ?Hi,I'm trying to use a new function jdk 1.4.0 named executeQuery(sql,autogeneratedkeysFlag) with postgresql 7.2.Is this function implemented and ready to use with a new jdk1.4.0 compiled jdbc driver ?thanks for the answer.Ludovic SMADJA
Webcell
ICQ#:70047519
tel. 01 40 47 56 31
fax. 01 40 47 56 34
port. 06 72 28 78 71
Thanks for the answer,
Is there a road map for this implementation.
Ludovic
-----Message d'origine-----
De : Dave Cramer [mailto:Dave@micro-automation.net]
Envoyé : mardi 5 mars 2002 14:23
À : 'ludovic smadja'; pgsql-jdbc@postgresql.org
Objet : RE: [JDBC] is anyone use executeQuery with autogeneratedkeys function ?Ludovic,Unfortunately no, none of the jdbc3.0 functions have been implemented.Dave-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of ludovic smadja
Sent: Tuesday, March 05, 2002 4:18 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] is anyone use executeQuery with autogeneratedkeys function ?Hi,I'm trying to use a new function jdk 1.4.0 named executeQuery(sql,autogeneratedkeysFlag) with postgresql 7.2.Is this function implemented and ready to use with a new jdk1.4.0 compiled jdbc driver ?thanks for the answer.Ludovic SMADJA
Webcell
ICQ#:70047519
tel. 01 40 47 56 31
fax. 01 40 47 56 34
port. 06 72 28 78 71
Ludovic,
No, not really, postgres is developed by volunteers, as such we don't really have timelines. We could however use more volunteers <hint, hint>
Dave
-----Original Message-----
From: ludovic smadja [mailto:lsmadja@webcell.fr]
Sent: Tuesday, March 05, 2002 8:33 AM
To: Dave@micro-automation.net; pgsql-jdbc@postgresql.org
Subject: RE : [JDBC] is anyone use executeQuery with autogeneratedkeys function ?Thanks for the answer,Is there a road map for this implementation.Ludovic-----Message d'origine-----
De : Dave Cramer [mailto:Dave@micro-automation.net]
Envoyé : mardi 5 mars 2002 14:23
À : 'ludovic smadja'; pgsql-jdbc@postgresql.org
Objet : RE: [JDBC] is anyone use executeQuery with autogeneratedkeys function ?Ludovic,Unfortunately no, none of the jdbc3.0 functions have been implemented.Dave-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of ludovic smadja
Sent: Tuesday, March 05, 2002 4:18 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] is anyone use executeQuery with autogeneratedkeys function ?Hi,I'm trying to use a new function jdk 1.4.0 named executeQuery(sql,autogeneratedkeysFlag) with postgresql 7.2.Is this function implemented and ready to use with a new jdk1.4.0 compiled jdbc driver ?thanks for the answer.Ludovic SMADJA
Webcell
ICQ#:70047519
tel. 01 40 47 56 31
fax. 01 40 47 56 34
port. 06 72 28 78 71
I just checked in a number of patches to try to get the source tree up to date. Unfortunately it appears that one of them broke the driver. I will be looking at this immediately, but I wanted to warn everybody before getting the latest source from cvs. Dave
Ludovic, No it does not support the new methods in JDBC3. You can use the current driver under jdk1.4 as long as you stick to the JDBC2 level methods. thanks, --Barry ludovic smadja wrote: > Hi, > > > > I'm trying to use a new function jdk 1.4.0 named > executeQuery(sql,autogeneratedkeysFlag) with postgresql 7.2. > > > > Is this function implemented and ready to use with a new jdk1.4.0 > compiled jdbc driver ? > > > > thanks for the answer. > > > > Ludovic SMADJA > Webcell > *ICQ#:70047519* > tel. 01 40 47 56 31 > fax. 01 40 47 56 34 > port. 06 72 28 78 71 > > >
The source of the problem was rectified, and the driver now runs. A number of patches have been applied and at this point the driver s/b considered in a beta state. If anyone has time I would appreciate it if additional unit test cases can be written. See the test directory for details on how to write them The following test cases would be useful 1) test the cancel query function 2) test the SQL Warnings 3) test get column on numeric with various numeric columns. 4) test for an empty array Any others people feel are usefull Thanks, Dave -----Original Message----- From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Dave Cramer Sent: Tuesday, March 05, 2002 10:15 AM To: pgsql-jdbc@postgresql.org Cc: Bruce Momjian Subject: [JDBC] Status of jdbc repository - broken driver I just checked in a number of patches to try to get the source tree up to date. Unfortunately it appears that one of them broke the driver. I will be looking at this immediately, but I wanted to warn everybody before getting the latest source from cvs. Dave ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org