Re: Batch Inserts: Bug in 9.4.1208? Wrong binary data format

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: "Merder, Markus" <Markus(dot)Merder(at)adesso(dot)de>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Batch Inserts: Bug in 9.4.1208? Wrong binary data format
Date: 2016-06-16 12:21:50
Message-ID: CAB=Je-ENZ7SQ6cWFmLkP2=2=+iOGafaDEZaouxACmqZXMWOu3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi Markus,

>Removing the affected lines in the source file didn’t solve the problem
and after some investigation I found out, that a workaround is to use
PreparedStatment. setObject(int parameterIndex, Object x, int sqlType)
instead of setObject(int parameterIndex, Object x). I know this method is
the recommended one anyway, but I still believe it is an unknown bug in
9.4.1208. because it was working in 9.3.

Do you have a small testcase by chance that reproduces the issue?

I think there are similar testcases in the regression suite, however it
looks like your case is somewhat special.

Vladimir

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Radoslav Petrov 2016-06-17 16:13:01 Re: Batch Inserts: Bug in 9.4.1208? Wrong binary data format
Previous Message Merder, Markus 2016-06-16 09:20:16 Batch Inserts: Bug in 9.4.1208? Wrong binary data format