File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Clob Retrieval Effort Failure

 
bob reilly
Ranch Hand
Posts: 44
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm attempting to retrieve a clob column from an Oracle database. In fact I'm looking to retrieve one clob column from one row in the database. Everything looks good except that with my code:


I'm getting an error condtion on statement: java.sql.Clob desc1 = rs.getclob(1);. // java.sql.Clob cannot be resolved. In fact the getclob method is undefined for type ResultSet. My question - is this a java version issue - or do I need to go in another programming direction. Any comments / URLs would be appreciated.

Thank you...

Thanks.
 
Rob Spoor
Sheriff
Pie
Posts: 20368
43
Chrome Eclipse IDE Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I see two mistakes there:
1) it's getClob, not getclob; Java is case sensitive
2) your loop body is only line 7, because you didn't use { and }.

That doesn't explain the java.sql.Clob not being found error, unless you're using a Java 1.0 or Java 1.1 compiler (Clob was added in Java 1.2).

I'll move this thread to our JDBC forum. And please UseCodeTags next time.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic