Hi,
One of my table has a clob field.

I call this table to display the clob field in my jsp. I use the load method to load the class and it works fine for the first time.

try {
Transaction tx = hibSession.beginTransaction();

// Run query and populate a list

AddendumQuoteTcT aTcT = (AddendumQuoteTcT) hibSession.load(AddendumQuoteTcT.class, Integer.valueOf(id));

value = getValue(aTcT.getVerbiage());

tx.commit();
} catch (HibernateException he) {
// need more here.
he.printStackTrace();
}

I'm able to retrieve the clob here and using
BufferedReader br = new BufferedReader(clob.getCharacterStream());.

Now i try to call the same code above in my subsequent page, i get the following error.

ClobHelper:101 - [IBM][CLI Driver][DB2/6000] SQL0423N Locator variable "1" does not currently represent any value. SQLSTATE=0F001

Is that because the object is already loaded in the cache?

If yes how do i remove loaded object from cache. I tried using session.evit(), that didnt help.

Any suggestions?

Thanks in advance

That looks like it's because of the standard JDBC driver issue that lobs are available only in the transaction that retrieved them from the DB. You need to read the lob in the initial transaction, and keep it around in some other member variable for use in other transactions. As the SQL error suggests, it's not an hibernate issue, just a shortcoming of the way that lobs are provided by the DB and driver.