File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to insert CLOB object into DB? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to insert CLOB object into DB?" Watch "How to insert CLOB object into DB?" New topic
Author

How to insert CLOB object into DB?

Gurumurthy Ramamurthy
Ranch Hand

Joined: Feb 13, 2003
Posts: 272
Guys,

I have a huge string which I want to insert into DB as CLOB object using setClob.

I am struggling to creating a java.sql.Clob object with this huge string.

Can anyone help me?

Guru
Joe Nguyen
Ranch Hand

Joined: Apr 20, 2001
Posts: 161
This oracle document would help you to get the job done (You may need to create userid/pwd to access the page).
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to insert CLOB object into DB?