Hi All,

I have a byte[] array data that i want to insert/update into a table in
mysql.

here is the code:

Connection conn = ....
Statement stmt = conn.createStatement();

String sql = "UPDATE cards SET BlobField = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setBytes(1, "hghghfhgf".getBytes());

stmt.executeUpdate(sql);


I have tried to set the table field to longblob, blob, but failed with
error indicating syntax error "?"

Zab

DBArtisan wrote:
Try passing a string of the form
X'<hexdigits>'
e.g., in your example
X'686768676866686766'

toby wrote:
Eh, never mind, that can't really help...

DBArtisan wrote:
Shouldn't that be:

pstmt.executeUpdate();


There is nothing tying stmt to the set parameter in pstmt, so
stmt.executeUpdate(sql) causes the stmt to simply pass sql to the
database which has "?" in it...thus the syntax problem.

greg.fenton