>> will it re-create and re-prepare update statement on every call to update the row ? or will it be able to cache one prepared update statement and only subsistute new parameters during the whole loop ?
>
> Former - on each row application might update different rows and we want
> to change only them. So the update statement is re-prepared each time.

Sorry, I meant "different columns".

So, if the columns that will be updated is known, it is better to use a
separate PreparedStatement.

Roman