var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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] [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?
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 ';'?
Thanks a lot..
. It worked after passing the param through driver url.