Re: [GENERAL] How does postgresql jdbc driver implement prepared batch?

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: Jinhua Luo <luajit(dot)io(at)gmail(dot)com>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [GENERAL] How does postgresql jdbc driver implement prepared batch?
Date: 2016-04-25 11:29:38
Message-ID: CAB=Je-ESwGSzMN066Q04iu+1QatppkFHSJ+HagaF-m=j4fg8CA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Jinhua>So that's what I mean prepared statement should be created dynamically
Jinhua>depending how much you calls addBatch() before executeBatch().

Just grab the current pgjdbc master branch (e.g. via 9.4.1209-SNAPSHOT
maven snapshot),
and add reWriteBatchedInserts=true connection property.

We'll be glad to hear your results on the feature.

The feature is not yet enabled by default, however it might be changed
in the future.

See more in https://github.com/pgjdbc/pgjdbc/pull/491

Vladimir

In response to

Browse pgsql-general by date

  From Date Subject
Next Message david 2016-04-25 12:57:44 Re: Background worker plus language handler for Andl: OK?
Previous Message Jinhua Luo 2016-04-25 11:20:03 Re: [GENERAL] How does postgresql jdbc driver implement prepared batch?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bear Giles 2016-04-25 11:33:23 Re: Kerberos problem with pg_ident that happens with JDBC but not with PSQL.
Previous Message Jinhua Luo 2016-04-25 11:20:03 Re: [GENERAL] How does postgresql jdbc driver implement prepared batch?