How to update the BLOB column in Oracle database with java

Question

I'm trying to update the picture what I inserted into the database. I tried with update statement. But it produces error ORA-00933: SQL command not properly ended.

What I tried is:

 StringBuilder sb=new StringBuilder(1024);
 sb.append("update ").append(uname).append("PROFILEPICTURE set PROFILEPICT=? where ID=1 for update");
 String query = sb.toString();
 PreparedStatement ps = con.prepareStatement(query);
 ps.setBinaryStream(1, is);

I don't know how to update the BLOB content please anyone tell me how to update the BLOB column... Thanks...

jarnbjo · Accepted Answer · 2013-02-26 18:43:11Z

2

You cannot issue an SQL statement "update ... for update". Just remove the trailing " for update" and your statement may work.

Since you don't tell us the content of uname, there may of course be other problems with your statement as well.

answered Feb 26, 2013 at 18:43

jarnbjo

34.4k7 gold badges75 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to update the BLOB column in Oracle database with java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related