Unanswered: The cursor specified in a FETCH or CLOSE statement is not open
We r using DB2 v 7.1 on Windows 2000 with EJB 2.0 on Weblogic ser ver V 7.0 SP1.
We r encountering this error when two users access the same module of the application at more or less same time. We r using using a combination of CMP and BMP beans. The exception we get is mentioned below:
EJB Exception: : COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0501N The cursor specified in a FETCH or CLOSE statement is not open. SQLSTATE=24501