Issue Details (XML | Word | Printable)

Key: JDBC-433
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Mark Rotteveel
Reporter: Maurice Gasco
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Jaybird JCA/JDBC Driver

CLONE -Batch insert with setBinaryStream inserts an empty BLOB SUB_TYPE TEXT

Created: 10/May/16 07:17 AM   Updated: 20/Aug/16 01:13 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 2.2.10
Fix Version/s: Jaybird 2.2.11, Jaybird 3.0.0

Environment:
Windows 2008R2
JDK 1.7
Firebird 2.5
jaybird-jdk17


 Description  « Hide
I created a clone of Issue JDBC-312 since I have the same problem with a BLOB sub_type 1 instead of BLOB sub_type 0.

Here is the original description :
When using setBinaryStream(int, InputStream, int) with batch execution, the rows in the second batch (and the following) contain an empty BLOB.
The rows in the first batch get correctly inserted.
All rows get correctly inserted when not using batch execution.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 10/May/16 08:44 AM
Which Jaybird version are you using? Also are you actually using setBinaryStream for a BLOB sub_type 1? Using setBinaryStream is atypical for a BLOB sub_type 1.

If not could you please update the ticket to include the code you use

Maurice Gasco added a comment - 10/May/16 08:54 AM
I am using jaybird-jdk17 2.2.10

I am using Hibernate 3.6.5 so I need to check if It's using setBinaryStream. Other than that, same problem only rows of the first batch get the BLOB populated.

Mark Rotteveel added a comment - 10/May/16 09:03 AM
Thanks. I will see if it is a similar problem.

Mark Rotteveel added a comment - 12/Jun/16 01:30 PM
It was indeed the same issue as JDBC-312, but then for SUB_TYPE TEXT. Commit fix to 2.2 and master.