From: | dmachop <dmachop(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Postgres jdbc bulk insert stuck |
Date: | 2016-05-21 20:34:02 |
Message-ID: | 1463862842105-5904463.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2016-05-21 22:06:27 | Re: [BUGS] BUG #13856: JDBC driver 1207 not picking up properties |
Previous Message | danap | 2016-05-21 17:37:10 | Re: [BUGS] BUG #13856: JDBC driver 1207 not picking up properties |