Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    1

    Unanswered: CLOB error in DB2

    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

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Turn off auto-commit. Besides WITH HOLD cursors being used by default, this is one of the stupid default configuration settings in JDBC.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •