• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inserting Clob data

 
Shane W
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2599
12
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I get class cast exception.
What does the exception say?

Regards, Jan
 
Ugender Rekulampally
Ranch Hand
Posts: 135
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Shane,
try reading that big string into character stream. it works for me.


'rpaXmlInputStr' is my big XML in string format.

Thanks,
Ugender
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic