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.