This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Customer Requirements for Developers and have Marcho Behler on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Cannot update Clob to Oracle by using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 20050
    
  30

Add this between flushing and closing the writer:


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Cannot update Clob to Oracle by using JDBC
 
It's not a secret anymore!