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

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.

Can I pass through driver url? If yes the should it be appended with '?' or ';'?

URL format for IBM Data Server Driver for JDBC and SQLJ type 4 connectivity - IBM DB2 9.7 for Linux, UNIX, and Windows

Thanks a lot... It worked after passing the param through driver url.