How to create a java.sql.Blob object in Java SE 1.5.0 with a byte[] input?
I want to create a Blob obj开发者_运维知识库ect 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?
An example, using SerialBlob:
import java.sql.Blob;
import javax.sql.rowset.serial.SerialBlob;
byte[] byteArray = .....;
Blob blob = new SerialBlob(byteArray);
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);
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.
精彩评论