java.sql.SQLException: not all varaibles bound

[Rudra Nath]

I did following in JAVA:

String query = "update mytable set image=? where column1= \'" +columnvalue+"\'";
PreparedStatement st1=conn.prepareStatement(query);
st1.setBinaryStream(1,new FileInputStream(myImg),(int)myImg.length());
st1.executeUpdate();

where myImg contains full path with filename where an image is stored.

But I am getting follwoing error:
java.sql.SQLException: not all varaibles bound.

What to do?

[Winston Gutkowski]

Rudra Nath wrote:But I am getting follwoing error:
java.sql.SQLException: not all varaibles bound.

It would be useful if you supply the exact error (ie, the first few lines of the stacktrace), along with an indication of precisely which line is throwing it.

However, that said, your statement looks very odd. Specifically, I'm not at all sure that you can set a BLOB with a simple '=' assignment (but I may be wrong).

Winston

[Jeff Verdegan]

Also, you should be using a PS parameter for your columnvalue as well:

"... where column1 = ?"; 
...
st1.setString(2, columnValue);

[Martin Vajsar]

What database and JDBC driver are you using? Sometimes approaches that work with one database/driver might fail with another.

[Wendy Gibbons]

Martin Vajsar wrote:What database and JDBC driver are you using? Sometimes approaches that work with one database/driver might fail with another.

yes blobs are vendor specific.