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

[Mandy S Smith]

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 !
Thanks.

[William Brogden]

Doesn't the java.sql.Clob interface have a setCharacterStream() to get a Writer and setAsciiStream() to get an OuputStream?
Bill

[Navjeet Nehra]

Hi,
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 =
((weblogic.jdbc.vendor.oracle.OracleThinClob) clob).getCharacterOutputStream();
char[] b = message.toCharArray();
wr.write(b);
wr.flush();
String updateClobQuery = "UPDATE {Table} SET CLOB_MESSAGE = ? " +
"WHERE TIME_STAMP_LOG = ?";

preparedStatement = conn.prepareStatement(updateClobQuery);
preparedStatement.setClob(1, clob);
preparedStatement.setString(2, timeStamp);
preparedStatement.execute();
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++