error creating entity bean(CMP) based on oracle view

[Pankaj Jha]

test.ui.TestException: Constructor Operation Successfull... RemoteException In getAllRowsRemoteException occurred in server thread; nested exception is: com.ibm.ejs.persistence.EJSPersistenceException: findByAll failed:; nested exception is: java.sql.SQLException: ORA-01003: no statement parsed

[Rajeshwar Rao Chivukula]

Add

CLOSE_CACHED_OPEN_CURSORS=true
to the init.ora file. Open cursors are not reused unless this variable is set.