JDBC Driver for SQL/MX Programmer's Reference

PreparedStatement ps = conn.prepareStatement("insert

into myTable (myBlobColumn) values (?)");

ps.setBinaryStream(1, inputBinary, blobLen);

ps.executeUpdate();

The JDBC/MX driver reads the data from FileInputSteam and writes the data to the LOB

table. The JDBC/MX driver substitutes the next-available data locator for the parameter of the

BLOB column in the table.

Inserting a Blob Object by Using the setBlob

Method

Your JDBC application cannot directly instantiate a Blob object. To perform an equivalent

operation:

Obtain a Blob object by using the getClob method of the ResultSet interface.1.

Insert the Blob object into another row by using the setBlob method of the

PreparedStatement interface.

In this situation, the JDBC/MX driver generates a new data locator and copies the contents of

the source Blob into the new Blob object when the application issues the setBlob method

of the PreparedStatement interface.

Reading Binary Data from a BLOB

Column

You can read binary data from the BLOB column by using the Blob interface or

InputStream. The following code illustrates how to read the binary data from the BLOB

column by using the Blob interface:

// Obtain the Blob from ResultSet

Blob myBlob = rs.getBlob("myBlobColumn");

// Obtain the input stream to read Blob data

InputStream is = myBlob.getBinaryStream();

// read Blob data using the InputStream

byte[] myBlobData = new byte[length];

is.read(myBlobData, offset, length);

To read binary data from the BLOB column by using InputStream

// obtain the InputStream from ResultSet

InputStream is = rs.getBinaryStream("myBlobColumn");