Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2012
    Posts
    3

    Post Unanswered: How to set allowNextOnExhaustedResultSet

    I am running an JSF application on Tomcat 7 and jdk 6 and using DB2 9.7 as database. I am getting following error:

    com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120] [10898][4.11.77] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null

    I came to know if I set 'allowNextOnExhaustedResultSet' property to 1, the prolem gets resolved. Could you tell me how and where I can set this property?

    Chinmoy

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    You can set properties either at the connection-level, or at statement-level.
    e.g. when you do the DriverManager.getConnection you can pass a Properties object.
    See samples provided by IBM in directory sqllib samples java on your DB2-server.

  3. #3
    Join Date
    Aug 2012
    Posts
    3
    Can I pass through driver url? If yes the should it be appended with '?' or ';'?

  4. #4
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18

  5. #5
    Join Date
    Aug 2012
    Posts
    3
    Thanks a lot... It worked after passing the param through driver url.

Posting Permissions

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