Re: Postgres jdbc bulk insert stuck

Pretty sure we don't do single inserts.

Do you have a sense of where this breaks down. How many inserts it takes
before it fails ?

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 21 May 2016 at 16:34, dmachop <dmachop(at)gmail(dot)com> wrote:

> Tried with older version of postgres jdbc driver
> <
> http://mvnrepository.com/artifact/org.postgresql/postgresql/9.3-1104-jdbc41
> >
> and the issue still exists.
>
> I recollect reading from Stackoverflow that batch insert in postgres does
> individual inserts and recommends using copy. However, I cannot use copy
> due
> to certain reasons. That's the reason I have to resort to batch insert. Is
> there a way that I could change some parameters such that it might not hit
> the maximum limit? (Probably seems to be an issue with larger tables and
> batch insert works on smaller tables).
>
> Just an additional info that the data may contain non-ascii chars while
> insert (Chinese, German) and using utf-8 option on db as well as on jdbc
> connection properties. I don't see that as an issue since manual inserts
> are
> working good.
>
>
>
> --
> View this message in context:
> http://postgresql.nabble.com/Postgres-jdbc-bulk-insert-stuck-tp5904350p5904463.html
> Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>