I have an update sql query which does not work with PreparedStatement object. Heres the code snippet:
pstmt = con.prepareStatement(
"UPDATE item_articles SET dataFile=? WHERE itemID=?");
numUpd = pstmt.executeUpdate();
What I am doing here is that setBinaryStream(...) will upload a file into the DB. The query executes, theres no exception thrown, but my table shows empty field for the file. Note, there are no exceptions thrown from this query.
If I do the same thing for an INSERT statement, it works. The file gets into the DB. So , the file is there on disk, and theres no problem with it. Just that it does not work with UPDATE.....any clues ???