We have been trying to insert data (batch inserts) using a JAVA app which uses prepared statements with parameterized queries to insert data .We are able to insert data with small batch size however when we increase the batch size to a higher value data ingestion fails . We are using pgbouncer for connection pooling on database side wich is running in session mode and server_reset_query set to "DISCARD ALL" . Please suggest the how can we bulk load data with higher batch size .Below the error logs that we are getting from the application end.
2016-06-07T11:33:04.50-0700 [App/2] OUT at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2959) ~[postgresql-9.4-1205-jdbc41.jar!/:9.4]
2016-06-07T11:33:04.50-0700 [App/2] OUT at com.exelon.drillinginfo.service.PdenDescService.createDrillingInfo(PdenDescService.java:337) ~[app/:na]
2016-06-07T11:34:35.04-0700 [App/1] OUT 2016-06-07 18:34:35.048 INFO 29 --- [io-64887-exec-1] c.e.d.service.PdenDescService : Run id: 33842
2016-06-07T11:34:35.05-0700 [App/1] OUT 2016-06-07 18:34:35.051 INFO 29 --- [io-64887-exec-1] c.e.d.service.PdenDescService : running inserts ********---------------------------------------------------------------***********
2016-06-07T11:34:35.05-0700 [App/1] OUT 2016-06-07 18:34:35.058 INFO 29 --- [io-64887-exec-1] c.e.d.service.PdenDescService : running inserts ********---------------------------------------------------------------***********
2016-06-07T11:34:35.06-0700 [App/1] ERR org.postgresql.util.PSQLException: ERROR: prepared statement "S_3" does not exist
2016-06-07T11:34:35.06-0700 [App/1] ERR at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
2016-06-07T11:34:35.06-0700 [App/1] ERR at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
2016-06-07T11:34:35.06-0700 [App/1] ERR at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338)
2016-06-07T11:34:35.06-0700 [App/1] ERR at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2959)
2016-06-07T11:34:35.06-0700 [App/1] ERR at com.exelon.drillinginfo.service.PdenDescService.createDrillingInfo(PdenDescService.java:337)
2016-06-07T11:34:35.06-0700 [App/1] ERR at com.exelon.drillinginfo.service.PdenDescService$$FastClassBySpringCGLIB$$3080db7d.invoke(<generated>)
2016-06-07T11:34:35.06-0700 [App/1] ERR at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)