Preparedstatement updates to Oracle 10g BLOB ingnored

[Matthew Snow]

Here is my code.

Connection dconn = DriverManager.getConnection("jdbc:oracle:thin:@"+HOST+":"+PORT+":"+DBNAME, USERNAME, PASSWORD);
BufferedImage bimage = toBufferedImage(new ImageIcon(ImageIO.read(imageFile)).getImage());

ByteArrayOutputStream baos = new ByteArrayOutputStream(8192);
ImageIO.write(bimage, "jpg", baos);
byte[] buffer = baos.toByteArray();
baos.close();

ByteArrayInputStream bais = new ByteArrayInputStream(buffer);

PreparedStatement pstmt = dconn.prepareStatement("update sysadm.ps_empl_photo set employee_photo = ? where emplid = '"+emplid+"'");
pstmt.setBinaryStream(1, bais, buffer.length);

pstmt.execute();

bais.close();
dconn.close()

When I run pstmt.execute() it returns a false with pstmt.getResultSet() returning null and pstmt.getUpdateCount() returning 1. If I use pstmt.executeUpdate(), it returns 0. Could someone explain to me why this Update statement wont execute? Thanks.

Update: if I change the statement to an Insert with a new value, I get the following error: ORA-01460: unimplemented or unreasonable conversion requested.

[Matthew Snow]

Apparently this is a bug introduces in Oracle 10g, Bug ID 5872943. Apparently it's resolved in 11.2g.