Hi,

I'm not able to find solution for below problem. Can anybody suggest me any solution.

I'm using DB2 9.1 database with Hibernate3

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


I'm using this code to convert CLOB object to string object

StringBuffer strOut = new StringBuffer();
String aux;
BufferedReader br = new BufferedReader(clob.getCharacterStream());

while ((aux = br.readLine()) != null)
strOut.append(aux);

Thanks

Turn off auto-commit. Besides WITH HOLD cursors being used by default, this is one of the stupid default configuration settings in JDBC.