Postgres Pro
Downloads
Home   >   mailing lists

PGStatement#setUseServerPrepare breaking PreparedStatement#executeUpdate return value? - Mailing list pgsql-jdbc

From Guillaume Cottenceau
Subject PGStatement#setUseServerPrepare breaking PreparedStatement#executeUpdate return value?
Date
Msg-id 87wtszxmzr.fsf@meuh.mnc.ch
Whole thread Raw
Responses Re: PGStatement#setUseServerPrepare breaking  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Tree view 
Hi,

I use postgres-7.4.5 with postgresql-7.4.5.jar built out of it.

I have noticed that the int result from
PreparedStatement#executeUpdate for a DELETE statement is always
1 for me, even if 0 rows were affected by the statement, breaking
the JDBC API (or at least its documentation).

I have experimented and noticed that removing my call to
PGStatement#setUseServerPrepare(true) workarounds the bug.

Is there any way to workaround it otherwise? Is it a known and/or
normal bug?

Thanks,

--
Guillaume Cottenceau

pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Socket timeouts (probably)
Next
From: peter royal
Date:
Subject: Re: DatabaseMetaData.getIndexInfo and function-based indexes