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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com