Meaningless Drivel is fun!
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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: 13026
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.....
jQuery in Action, 3rd edition