Finder Exception

[TURKMAN Bernard (Soft LB)]

Hi,

I ‘am testing Web Sphere App Server 5.0 trial and I’am using Application Assembly Tool but I have a big problem.

I created a web application (jsp + ejb)  

I created a DataSource and I tested in a jsp page (using lookup and getConnection ()) and it is working normally.

In my session bean, there is function, which calls an entity finder and it returns the following exception.

70283ccd DataAccessReq E PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@30063cc5
[12/17/02 17:48:33:449 GMT+02:00] 70283ccd DataAccessReq E PMGR0000E: Call stack:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@30063cc5
    at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:127)
    at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
    at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
at softsolutions.wfm.operation.entity.ConcreteWfmOperation_d5798005.ejbFindAll_Local(Unknown Source)
    at softsolutions.wfm.operation.entity.EJSCMPWfmOperationHomeBean_d5798005.findAll_Local(Unknown Source)
    at softsolutions.wfm.operation.entity.EJSLocalCMPWfmOperationHome_d5798005.findAll(Unknown Source)
    at softsolutions.wfm.operation.facade.WfmOperationFacadeBean.returnAllOperation(WfmOperationFacadeBean.java:79)
    at softsolutions.wfm.operation.facade.EJSRemoteStatelessWfmOperationFacade_924533cd.returnAllOperation(EJSRemoteStatelessWfmOperationFacade_924533cd.java:74)
    at softsolutions.wfm.operation.facade._WfmOperationFacade_Stub.returnAllOperation(_WfmOperationFacade_Stub.java:335)
    at org.apache.jsp._Welcome._jspService(_Welcome.java:101)

---- Begin backtrace for nested exception
java.sql.SQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
    at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
    at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
    at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
    at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
    at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:3507)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:456)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
    at softsolutions.wfm.operation.entity.websphere_deploy.ORACLE_V8_1.WfmOperationBeanFunctionSet_d5798005.FindAll_LocalForUpdate(Unknown Source)
    at softsolutions.wfm.operation.entity.websphere_deploy.ORACLE_V8_1.WfmOperationBeanFunctionSet_d5798005.execute(Unknown Source)

[12/17/02 17:48:33:590 GMT+02:00] 70283ccd ExceptionUtil E CNTR0019E: Non-application exception occurred while processing method "findAll". Exception data: javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@30063cc5
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@30063cc5
    at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:127)
    at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
    at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
    at softsolutions.wfm.operation.entity.ConcreteWfmOperation_d5798005.ejbFindAll_Local(Unknown Source)
    at softsolutions.wfm.operation.entity.EJSCMPWfmOperationHomeBean_d5798005.findAll_Local(Unknown Source)
    at softsolutions.wfm.operation.entity.EJSLocalCMPWfmOperationHome_d5798005.findAll(Unknown Source)
    at softsolutions.wfm.operation.facade.WfmOperationFacadeBean.returnAllOperation(WfmOperationFacadeBean.java:79)
    at softsolutions.wfm.operation.facade.EJSRemoteStatelessWfmOperationFacade_924533cd.returnAllOperation(EJSRemoteStatelessWfmOperationFacade_924533cd.java:74)
    at softsolutions.wfm.operation.facade._WfmOperationFacade_Stub.returnAllOperation(_WfmOperationFacade_Stub.java:335)

Where findAll is finder name, WfmOperationHome is entity home interface, WfmOperationFacade is the session remote interface and returnAllOperation (belongs to the session home interface) is the function that I called from the JSP file.