byte[] to blob

[azhar bharat]

How do i convert a byte array to a Blob(java.sql.Blob) object?

[Scott Selikoff]

Check out the PreparedStatement API. In particular look at setBinaryStream(), setUnicodeStream(), and setAsciiStream() which can be used to convert a stream to a blob during an insert/update statement.

[azhar bharat]

I am aware of other options in prepared statements api.
But, i just want to know how to convert byte[] to Blob.

[Jeanne Boyarsky]

Azhar,
You can create a ByteArrayInputStream from your byte[] and use that.

To create a Blob directly, you would have to write database specific code - something that should be avoided without a good reason.