This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Reading CLOB object from Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Reading CLOB object from Oracle" Watch "Reading CLOB object from Oracle" New topic

Reading CLOB object from Oracle

Parameswaran Thangavel
Ranch Hand

Joined: Mar 01, 2005
Posts: 485
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 =;
//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 agree. Here's the link:
subject: Reading CLOB object from Oracle
It's not a secret anymore!