jQuery in Action, 2nd edition
The moose likes JDBC and the fly likes Cannot update Clob to Oracle by using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Cannot update Clob to Oracle by using JDBC" Watch "Cannot update Clob to Oracle by using JDBC" New topic
Author

Cannot update Clob to Oracle by using JDBC

jammy chen
Greenhorn

Joined: Aug 24, 2009
Posts: 25
I used the following codes to update clob to oracle by using jdbc


after ran above codes, I checked "bbbbbbbbbbbbbbbbbbaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" was stored in the db, why? it should be "bbbbbbbbbbbbbbbbbb", right? As we can see the later string "bbbbbbbbbbbbbbbbbb" just appended. but I want it to be replaced.
I


Java tutorial
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19216

Add this between flushing and closing the writer:


SCJP 1.4 - SCJP 6 - SCWCD 5
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Cannot update Clob to Oracle by using JDBC
 
Similar Threads
Use two connections individually for a clob selection and updating statment.
unable to update CLOB data using Commons DBCP connection.
How to update string to Oracle Clob
How to update clob field in oracle
help: lock problem during Clob update