File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes CLOB field.... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "CLOB field...." Watch "CLOB field...." New topic

CLOB field....

Vimala Shirur

Joined: Jan 12, 2001
Posts: 12
I want to store and retrieve a java object into/from a CLOB field. It looks like setClob(int, clob) method requires a clob object. Also, when i retrive the clob [getClob()] from the database i need to get back as a java object. How do we do this? I know we can store it as a stream into the clob field but how do we get back as an object.

Thanks and appreciate your help!
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32818

getClob() returns you an object. It is a database specific implementation of the clob interface.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: CLOB field....
It's not a secret anymore!