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.
Joined: Apr 16, 2003
in order to use setClob you need to have a Clob object. it can be created as mentioned below
Karthikeyan<br />SCJP 1.4, SCWCD.
Joined: Sep 13, 2001
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