File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes XML and Related Technologies and the fly likes Storing as CLOB data in the database..... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Storing as CLOB data in the database....." Watch "Storing as CLOB data in the database....." New topic

Storing as CLOB data in the database.....

Mandy S Smith

Joined: Jan 20, 2002
Posts: 24
I have marshalled the xml data into an outputStream, now how do i read the data from the outputstream and store that data as CLOB object in the database? I am using oracle database.
Could anyone help me on this.
Appreciate your response !
William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 13037
Doesn't the java.sql.Clob interface have a setCharacterStream() to get a Writer and setAsciiStream() to get an OuputStream?
Navjeet Nehra

Joined: Sep 18, 2003
Posts: 13
The code below uses the getCharacterOutputStream() to get the writer. Hope it helps
Clob clob = null;

// writing the message into the Clob Object.
Writer wr =
(( clob).getCharacterOutputStream();
char[] b = message.toCharArray();
String updateClobQuery = "UPDATE {Table} SET CLOB_MESSAGE = ? " +

preparedStatement = conn.prepareStatement(updateClobQuery);
preparedStatement.setClob(1, clob);
preparedStatement.setString(2, timeStamp);
I agree. Here's the link:
subject: Storing as CLOB data in the database.....
It's not a secret anymore!