saving Very Very long string to Oracle DB

[Praveena Surapaneni]

Hi All

I have a problem saving a very, very long string to oracle database, using JDBC2.0. Here are the approaches I used and the resulting errors I got.

1) using a pstmt.setString() which bounces with string literal too long
2) using setClob() which throws an abrtract method error when I try to convert the string to clob using java.sql.Clob's setString(). (obvious because java.sql.Clob is an interface). If anyone could point me to a class that implements all these methods that would be helpful.
3) I tried using setAsciistream() got a class cast error.

coming to specs I am using JDK1.4 and oracle9.2

If anyone had an experince with this kinda thing, please help me.

Thanks
Praveena

[Karthikeyan Rajendraprasad]

in order to use setClob you need to have a Clob object. it can be created as mentioned below

  
oracle.sql.CLOB b = oracle.sql.CLOB.createTemporary((oracle.jdbc.driver.OracleConnection) conn, true, oracle.sql.CLOB.DURATION_SESSION);
b.open(oracle.sql.CLOB.MODE_READWRITE);
OutputStream out = b.getAsciiOutputStream();
out.write(txt.getBytes());
out.close();

[Praveena Surapaneni]

But the Clob in setClob method needs to be java.sql.Clob and not Oracle.sql.CLOB. Any other ideas on changing the string to clob

[Karthikeyan Rajendraprasad]

pstmt.setObject(colno, b, java.sql.Types.CLOB)

its not java.sql.Clob its java.sql.Types.CLOB

this should solve it...

[ August 17, 2005: Message edited by: Karthikeyan Rajendraprasad ]