Re: PG 8.2's JDBC, and Statement.executeUpdate(String, String[]) - Mailing list pgsql-jdbc

From Ken Johanson
Subject Re: PG 8.2's JDBC, and Statement.executeUpdate(String, String[])
Date
Msg-id 4580DEA7.2030604@kensystem.com
Whole thread Raw
In response to PG 8.2's JDBC, and Statement.executeUpdate(String, String[]) causing AbstractMethodError  (Ken Johanson <pg-user@kensystem.com>)
List pgsql-jdbc
Kris Jurka wrote:
>
>
> On Wed, 13 Dec 2006, Ken Johanson wrote:
>
>> Hello all,
>>
>> I'm getting a:
>>
>> AbstractMethodError:
>> org.postgresql.jdbc2.Jdbc2Statement.executeUpdate(Ljava/lang/String;[Ljava/lang/String;)I
>>
>>
>> when I call Statement.executeUpdate(String, String[]) on the PG 8.2
>> distro's JDBC driver (I did not check any other versions).
>>
>
> executeUpdate(String, String[]) is a JDBC3 method, but you are evidently
> using a JDBC2 driver.  When you use a JDBC3 driver you will get a
> SQLException reporting that this method is not implemented if you
> supply anything other than an array of zero length.  Actually this
> should probably also allow a null array as now it will throw a NPE when
> it shouldn't.
>
> Kris Jurka
>
>
>
>

Thank you Kris. Yes, I just now noticed that. Had both 2 and 3 drivers
in my classpath. Removed the V2 drivers, but now I get a:

org.postgresql.util.PSQLException: Returning autogenerated keys is not
supported

I'll have to do some searching to find out why this features isn't
supported (unless someone has quick pointers to docs :).

Thank you again,

Ken



pgsql-jdbc by date:

Previous
From: Ken Johanson
Date:
Subject: PG 8.2's JDBC, and Statement.executeUpdate(String, String[]) causing AbstractMethodError
Next
From: Ken Johanson
Date:
Subject: Synthesize support for Statement.getGeneratedKeys()?