Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009
    Posts
    16

    Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null

    Hi

    When i am trying to add the data to a table from the UI
    The following exception is thrown and iam using multiple result sets.


    com.ibm.db2.jcc.b.SqlException: [jcc][t4][10120][10898][3.50.152] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
    javax.faces.el.EvaluationException: com.ibm.db2.jcc.b.SqlException: [jcc][t4][10120][10898][3.50.152] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null.


    Does anyone know what the problem is?

    Thanks in advance
    Ramesh

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,481
    More informations will be neccessary.
    Please see answers of Stolze and me in this thread:
    http://www.dbforums.com/db2/1648938-...ry-tables.html

  3. #3
    Join Date
    Oct 2009
    Posts
    16
    hi ,

    what info i need to provoid.. please let me know

  4. #4
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,481
    From Storze wrote ....
    (commented by me)

    - From the error code I gather that you are running on DB2 z/OS Is this true?
    - Which version?
    - What's the query(this time, INSERT statement?) and what should it do?
    - What's the schema (tables, indexes, ...)?
    - What's the data volume?
    .....

    From you wrote .....
    iam using multiple result sets.
    How is it used with add the data?

Posting Permissions

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