blob data partially inserted in database

Question

When I insert blob data into Oracle database, it is partially inserted. Iam using the following code for insertion.

oracle.sql.BLOB newBlob =oracle.sql.BLOB.createTemporary(conn, false, oracle.sql.BLOB.DURATION_SESSION);
newBlob.putBytes(1, str.getBytes());
ps.setBlob(1, newBlob);

I checked whether the data got inserted or not by querying the data and converting it into jpeg image, sometimes I am getting partial image. Rest of the image is grey. Most of the time I am getting full image perfectly. What may the reason for this partial insertion?

What is str? How are you extracting it? I'm not sure if it's clear whether the problem is in the insertion, storage, retrieval or something else. — Alex Poole
– Alex Poole, Commented Oct 9, 2012 at 19:19

parsifal · Accepted Answer · 2012-10-09 19:21:37Z

1

You're storing the bytes of a string in the BLOB, using the default encoding. This is wrong in at least one of the following ways:

if you're storing character data, use a CLOB
if you're storing binary data, don't put it into a string.

Since you then say that you're dealing with a JPEG, I'd say that the string conversion is where you're having a problem. Trying to store a bunch of bytes in a Java String (which deals with characters) and then converting it back to bytes is just a bad idea. Use a byte[].

answered Oct 9, 2012 at 19:21

parsifal

2261 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vincent Malgrat Over a year ago

str might be an input stream, not string :)

parsifal Over a year ago

@VincentMalgrat - except that java.io.InputStream doesn't have a getBytes() method. And the OP's symptoms sound exactly like what would happen when using a string to hold bytes.

Collectives™ on Stack Overflow

blob data partially inserted in database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related