JDBC Driver for SQL/MX Programmer's Reference

Statement stmt0 = conn1.createStatement();
stmt0.execute("delete from blobdatatbl");
stmt0.execute("delete from blobtiff");
conn1.setAutoCommit(false);
}
catch (Exception e1) {
e1.printStackTrace();
}
// PreparedStatement interface example - This technique is
// suitable if the LOB data is already on the
// NonStop system disk.
try {
System.out.println("PreparedStatement interface LOB insert...");
String stmtSource1 = "insert into blobtiff values (?,?)";
PreparedStatement stmt1 = conn1.prepareStatement(stmtSource1);
stmt1.setInt(1,recKey);
stmt1.setBinaryStream(2,iXstream,numBytes);
stmt1.executeUpdate();
conn1.commit();
}
catch (SQLException e) {
e.printStackTrace();
SQLException next = e;
do {
System.out.println("Messge : " + e.getMessage());
System.out.println("Error Code : " + e.getErrorCode());
System.out.println("SQLState : " + e.getSQLState());
} while ((next = next.getNextException()) != null);
}
// Blob interface example - This technique is suitable when
// the LOB data is already in the app, such as having been
// transfered in a msgbuf.
try {
// insert a second base table row with empty LOB column
System.out.println("BLOB interface LOB insert...");
String stmtSource2 = "insert into blobtiff
values (?,EMPTY_BLOB())";
PreparedStatement stmt2 = conn1.prepareStatement(stmtSource2);
stmt2.setInt(1,recKey+1);
stmt2.executeUpdate();
Blob tiff = null;
System.out.println("Obtaining BLOB data to