JDBC Driver for SQL/MX Programmer's Reference

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

HP JDBC Driver for SQL/MX Programmer's Reference (529777-001)