Re: PG 8.2's JDBC, and Statement.executeUpdate(String, String[])

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