• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Clob Retrieval Effort Failure

 
bob reilly
Ranch Hand
Posts: 44
  • 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: 20610
63
Chrome Eclipse IDE Java Windows
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic