Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Reading CLOB object from Oracle  RSS feed

 
Parameswaran Thangavel
Ranch Hand
Posts: 485
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All,
I am reading the String from my Oracle database which is stored as CLOB object.

below is the code snippet.

//columnNumber for the CLOB column in the database
oracle.sql.CLOB clob = (oracle.sql.CLOB)rs.getClob(columnNumber);

//Works fine for below line
//java.sql.CLOB clob = (java.sql.CLOB)rs.getClob(columnNumber);
inputStream = clob.asciiStreamValue();
int available = inputStream.available();

//available is zero for Oracle.sql.CLOB, but contains the value for java.sql.CLOB
byte[] buf = new byte[available];
int bytesRead = inputStream.read(buf);
inputStream.close();
//Printing the string object
System.out.println(new String(buf));


The above code works fine for SQL databse, but when i use the Oracle CLOB object its not returning any value. The variable available is zero for Oracle
but has the correct value for SQL database.

Any insight would help.

Thanks
Param
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!