Re: Batch Inserts: Bug in 9.4.1208? Wrong binary data format - Mailing list pgsql-jdbc

From Vladimir Sitnikov
Subject Re: Batch Inserts: Bug in 9.4.1208? Wrong binary data format
Date
Msg-id CAB=Je-ENZ7SQ6cWFmLkP2=2=+iOGafaDEZaouxACmqZXMWOu3g@mail.gmail.com
Whole thread Raw
In response to Batch Inserts: Bug in 9.4.1208? Wrong binary data format  ("Merder, Markus" <Markus.Merder@adesso.de>)
Responses Re: Batch Inserts: Bug in 9.4.1208? Wrong binary data format
List 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

pgsql-jdbc by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: Batch Inserts: Bug in 9.4.1208? Wrong binary data format
Next
From: Radoslav Petrov
Date:
Subject: Re: Batch Inserts: Bug in 9.4.1208? Wrong binary data format