Hi All I need to insert a very large text formed by appendng names.So i created table with Column as Clob When I try to insert this string using pStmt.setString() method,i get the foll error java.sql.SQLException: Data size bigger than max size for this type:
I know that i have the pStmt.setClob() method available, but string can't be cast as Clob.How do i achieve this? Please note that i have to form the string by appending,no other way out.
Joined: Aug 31, 2007
Hi all I've tried using the foll piece of code oracle.sql.CLOB newClob = oracle.sql.CLOB.createTemporary(conn, false, oracle.sql.CLOB.DURATION_CALL);
This works fine if i run a standalone piece of code.But when i use it in my app,running on JBoss, I get class cast exception.
Any clue why this is happeing? Using oracle 9.2 and JBoss 4.1