Inserting Clob data

[Shane W]

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.

SHane

[Shane W]

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

Shane

[Jan Cumps]

I get class cast exception.

What does the exception say?

Regards, Jan

[Ugender Rekulampally]

Shane,
try reading that big string into character stream. it works for me.

StringReader inputreader = null;
inputreader = new StringReader( rpaXmlInputStr);
pStatement.setCharacterStream(5,inputreader,  rpaXmlInputStr.length());

'rpaXmlInputStr' is my big XML in string format.

Thanks,
Ugender