It's not a secret anymore!*
The moose likes JDBC and the fly likes Inserting Clob data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Inserting Clob data" Watch "Inserting Clob data" New topic
Author

Inserting Clob data

Shane W
Ranch Hand

Joined: Aug 31, 2007
Posts: 30
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

Joined: Aug 31, 2007
Posts: 30
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

Joined: Dec 20, 2006
Posts: 2497
    
    8

I get class cast exception.
What does the exception say?

Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
Ugender Rekulampally
Ranch Hand

Joined: Nov 14, 2005
Posts: 130
Shane,
try reading that big string into character stream. it works for me.


'rpaXmlInputStr' is my big XML in string format.

Thanks,
Ugender
 
 
subject: Inserting Clob data