Re: Batch Update problem

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