File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 2565

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!