CODEWITHSUNDEEP
javajdbcblob
ssethupathi
ssethupathi

Reputation: 363

How to create a java.sql.Blob object in Java SE 1.5.0 with a byte[] input?

I want to create a Blob object from a byte[] input to update a table using PreparedStatement#setBlob(). In J2SE 6, we have java.sql.Connection#createBlob() to get this done. Is there anything similar to this available in J2SE 1.5.0? What is the best way to update a BLOB type column with a byte[] data in J2SE 1.5.0?

Upvotes: 19

Views: 43230

Answers (3)

Matt Ball
Matt Ball

Reputation: 359776

You don't have to worry about creating Blob objects at all. Treat them as blobs on the database, and byte[]s in Java. For example:

@Entity
@Table(name = "some.table")
public class MyEntity
{
    @Id
    int myId;

    @Lob
    byte[] myBlob;

    // snip getters & setters
}

If you're really intent on creating a Blob instance yourself, you can use the SerialBlob implementation:

byte[] bytes = ...;
Blob myBlob = new SerialBlob(bytes);

Upvotes: 8

Buhake Sindi
Buhake Sindi

Reputation: 89169

An example, using SerialBlob:

import java.sql.Blob;
import javax.sql.rowset.serial.SerialBlob;

byte[] byteArray = .....;
Blob blob = new SerialBlob(byteArray);

Upvotes: 29

Mike Thomsen
Mike Thomsen

Reputation: 37506

You don't need to actually create the Blob itself. When doing a prepared statement, use a ByteArrayInputStream for the parameter when setting the blob parameter.

Upvotes: 0

Related Questions