This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes saving Very Very long string to Oracle DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "saving Very Very long string to Oracle DB" Watch "saving Very Very long string to Oracle DB" New topic
Author

saving Very Very long string to Oracle DB

Praveena Surapaneni
Greenhorn

Joined: Sep 13, 2001
Posts: 17
Hi All

I have a problem saving a very, very long string to oracle database, using JDBC2.0. Here are the approaches I used and the resulting errors I got.

1) using a pstmt.setString() which bounces with string literal too long
2) using setClob() which throws an abrtract method error when I try to convert the string to clob using java.sql.Clob's setString(). (obvious because java.sql.Clob is an interface). If anyone could point me to a class that implements all these methods that would be helpful.
3) I tried using setAsciistream() got a class cast error.

coming to specs I am using JDK1.4 and oracle9.2

If anyone had an experince with this kinda thing, please help me.

Thanks
Praveena
Karthikeyan Rajendraprasad
Ranch Hand

Joined: Apr 16, 2003
Posts: 70
in order to use setClob you need to have a Clob object. it can be created as mentioned below



Karthikeyan<br />SCJP 1.4, SCWCD.
Praveena Surapaneni
Greenhorn

Joined: Sep 13, 2001
Posts: 17
But the Clob in setClob method needs to be java.sql.Clob and not Oracle.sql.CLOB. Any other ideas on changing the string to clob
Karthikeyan Rajendraprasad
Ranch Hand

Joined: Apr 16, 2003
Posts: 70
pstmt.setObject(colno, b, java.sql.Types.CLOB)

its not java.sql.Clob its java.sql.Types.CLOB

this should solve it...

[ August 17, 2005: Message edited by: Karthikeyan Rajendraprasad ]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: saving Very Very long string to Oracle DB