aspose file tools*
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
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: saving Very Very long string to Oracle DB