Re: Batches of single-insert statements vs batches ofmulti-insert statements

Поиск
Список
Период
Сортировка
От Christopher Deckers
Тема Re: Batches of single-insert statements vs batches ofmulti-insert statements
Дата
Msg-id CADFnS4SFdXVNr6pLeu_t-37pvqGFeV2=QTuYTT+sR+Op_GoopA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Batches of single-insert statements vs batches of multi-insert statements  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Ответы Re: Batches of single-insert statements vs batches ofmulti-insert statements  (Jeremy Whiting <jwhiting@redhat.com>)
Список pgsql-jdbc
Дерево обсуждения
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

Вложения

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Vladimir Sitnikov
Дата:
Сообщение: Re: Batches of single-insert statements vs batches ofmulti-insert statements
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Batches of single-insert statements vs batches of multi-insertstatements