Postgres Pro
Downloads
Home   >   mailing lists

Re: Batches of single-insert statements vs batches ofmulti-insert statements - Mailing list pgsql-jdbc

From Christopher Deckers
Subject Re: Batches of single-insert statements vs batches ofmulti-insert statements
Date
Msg-id CADFnS4SFdXVNr6pLeu_t-37pvqGFeV2=QTuYTT+sR+Op_GoopA@mail.gmail.com
Whole thread Raw
In response to Re: Batches of single-insert statements vs batches of multi-insert statements  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Responses Re: Batches of single-insert statements vs batches ofmulti-insert statements
List pgsql-jdbc
Tree view
Hi Vladimir,

Thanks for your answer! It explains well the current situation.

Believe me or not, pgjdbc has already that feature implemented.

Oh good! But it definitely needs more testing and fixing :)
I got: "Batch entry 0 INSERT INTO XXXX".
Next exception: "VALUES lists must all be the same length".

I narrowed down the issue to a simple test case, see attached file.

Funny enough, if I change the name of the table, it seems to work. I used the convention that we have in our production code.
Note that this test case does not produce any error if I remove the "reWriteBatchedInserts=true" parameter.

Please let me know if I can be of any help!
-Christopher

Attachment

pgsql-jdbc by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: Batches of single-insert statements vs batches ofmulti-insert statements
Next
From: Thomas Kellerer
Date:
Subject: Re: Batches of single-insert statements vs batches of multi-insertstatements