This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Inserting Clob data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Inserting Clob data" Watch "Inserting Clob data" New topic

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 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

Jan Cumps

Joined: Dec 20, 2006
Posts: 2562

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

Regards, Jan

OCUP UML fundamental and ITIL foundation
Ugender Rekulampally
Ranch Hand

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

'rpaXmlInputStr' is my big XML in string format.

I agree. Here's the link:
subject: Inserting Clob data
It's not a secret anymore!