Re: [JDBC] Batch Update problem

From: Kris Jurka <books(at)ejurka.com>
Date: Sun Jan 06 2008 - 21:55:52 EST

On Sun, 30 Dec 2007, Hadraba Petr wrote:

> I have a global PreparedStatement pStmt that handles the UPDATE
> statement.
>
> In for-cycle I'm doing the following:
> - prepare values for the UPDATE
> - call pStmt.clearParameters();
> - call pStmt.setObject(paramOrderID, paramValue) for each value with
> the right paramID and value
> - call pStmt.addbatch();
>
> After the for-cycle I'm calling the pStmt.executeBatch(); and
> pStmt.close();
>
> Please note, no Exceptions are thrown — the SQL code is correct and no
> primary key nor foreign key valoations are occuring.
>
> I'm able to post full source code and more info.
>

Please post a full test case. I don't see any reason why Jdbc3 vs Jdbc3g would be any different.

Kris Jurka

---------------------------(end of broadcast)---------------------------

TIP 4: Have you searched our list archives?

               http://archives.postgresql.org Received on Sun Jan 6 21:57:47 2008