Batch insert algorithm

[Danilo Reinert]

Does jDBI disable autocommit before performing a batch insert?

This is one suggestion of PostgreSQL documentation.

See more at: http://www.postgresql.org/docs/current/interactive/populate.html.

Atenciosamente,
Danilo Reinert

[Steven Schlansker]

On May 7, 2013, at 11:47 AM, Danilo Reinert <danilo...@gmail.com> wrote:

> Does jDBI disable autocommit before performing a batch insert?
>
> This is one suggestion of PostgreSQL documentation.
>
> See more at: http://www.postgresql.org/docs/current/interactive/populate.html.

It is probably best to just wrap your batches in an inTransaction block, rather
than relying on implicit behavior. Then it is clear both that it always happens,
even if jDBI changes for some reason, and it is clear to people reading the code.

[Danilo Reinert]

That makes sense!