Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CLONE -Batch insert with setBinaryStream inserts an empty BLOB SUB_TYPE TEXT [JDBC433] #474

Closed
firebird-automations opened this issue May 10, 2016 · 9 comments

Comments

@firebird-automations
Copy link

Submitted by: Maurice Gasco (mgasco83)

I created a clone of Issue JDBC312 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.

Commits: 8592a73 4d1c00c

@firebird-automations
Copy link
Author

Modified by: Maurice Gasco (mgasco83)

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.

=>

I created a clone of Issue JDBC312 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.

environment: Windows 7
JDK 1.7
Firebird 2.5
jaybird-jdk17

=>

Windows 2008R2
JDK 1.7
Firebird 2.5
jaybird-jdk17

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

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

@firebird-automations
Copy link
Author

Commented by: Maurice Gasco (mgasco83)

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.

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

Thanks. I will see if it is a similar problem.

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

Version: Jaybird 2.2.10 [ 10723 ]

Fix Version: Jaybird 2.2.11 [ 10751 ]

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

It was indeed the same issue as JDBC312, but then for SUB_TYPE TEXT. Commit fix to 2.2 and master.

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

summary: CLONE -Batch insert with setBinaryStream inserts an empty BLOB => CLONE -Batch insert with setBinaryStream inserts an empty BLOB SUB_TYPE TEXT

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment