JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

System.out.println("Obtaining BLOB data to
update (EMPTY in this case)...");
PreparedStatement stmt3 = conn1.prepareStatement("select tiff
from blobtiff where col1 = ? for update");
stmt3.setInt(1,recKey+1);
ResultSet rs = stmt3.executeQuery();
if (rs.next()) tiff = rs.getBlob(1); // has to be there
else the base table insert failed
System.out.println("Writing data to previously
empty BLOB...");
OutputStream os = tiff.setBinaryStream(1);
byte[] bData = k.getBytes();
os.write(bData); os.close();
conn1.commit();
}
catch (SQLException e) {
e.printStackTrace();
SQLException next = e;
do {
System.out.println("Messge : " + e.getMessage());
System.out.println("Vendor Code : " + e.getErrorCode());
System.out.println("SQLState : " + e.getSQLState());
} while ((next = next.getNextException()) != null);
}
} // main
} // class
116 Sample Programs Accessing CLOB and BLOB Data