Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

saving Very Very long string to Oracle DB

 
Praveena Surapaneni
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
in order to use setClob you need to have a Clob object. it can be created as mentioned below

 
Praveena Surapaneni
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic