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.