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

ramesh.ibm · #1 (**permalink**) 10-14-09, 06:19

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

tonkuma · #2 (**permalink**) 10-14-09, 06:54

More informations will be neccessary.
Please see answers of Stolze and me in this thread:
Temporary tables

ramesh.ibm · #3 (**permalink**) 10-14-09, 07:26

hi ,

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

tonkuma · #4 (**permalink**) 10-14-09, 09:04

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 .....

Quote:

iam using multiple result sets.

How is it used with add the data?

Internet Services

Web Development

Digital Marketing

Consumer Tech