Hi,
I am working on the SUN Reference Implementation container to get the feel of EJB. We are using the Oracle as the database. We are working on the CMP beans and the application was working fine. But recently we are encountering a problem when we are setting the CMP members using the set methods. Following is the error we are getting. Can anybody tell us what could be the problem?

There was an exception in creating a new entry:javax.ejb.TransactionRolledbackLo
calException: Exception thrown from bean; nested exception is: javax.ejb.EJBExce
ption: nested exception is: java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00942:
table or view does not exist
javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; neste
d exception is: javax.ejb.EJBException: nested exception is: java.sql.SQLExcepti
on: [Oracle][ODBC][Ora]ORA-00942: table or view does not exist
javax.ejb.EJBException: nested exception is: java.sql.SQLException: [Oracle][ODB
C][Ora]ORA-00942: table or view does not exist
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00942: table or view does not exis
t
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3104)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedState
ment.java:214)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPrepared
Statement.java:89)
at com.sun.ejb.persistence.PersistenceManagerImpl.primaryKeyExists(Persi
stenceManagerImpl.java:289)
at com.sun.ejb.persistence.PartitionImpl.afterEjbCreate(PartitionImpl.ja
va:640)
at CallerBean_PM.ejbCreate(CallerBean_PM.java:96)
at CallerBean_PM_LocalHomeImpl.create(CallerBean_PM_LocalHomeImpl.java:2
9)
at SbbDerived.onAnalyseEvent(SbbDerived.java:131)
at SbbDerived_PM_EJBLocalObjectImpl.onAnalyseEvent(SbbDerived_PM_EJBLoca
lObjectImpl.java:90)
at EventRouter.routeEvent(EventRouter.java:57)
at Slee.fireEvent(Slee.java:77)
at Slee_PM_EJBObjectImpl.fireEvent(Slee_PM_EJBObjectImpl.java:87)
at _Slee_PM_EJBObjectImpl_Tie._invoke(Unknown Source)
at com.sun.corba.ee.internal.POA.GenericPOAServerSC.dispatchToServant(Ge
nericPOAServerSC.java:520)
at com.sun.corba.ee.internal.POA.GenericPOAServerSC.internalDispatch(Gen
ericPOAServerSC.java:210)
at com.sun.corba.ee.internal.POA.GenericPOAServerSC.dispatch(GenericPOAS
erverSC.java:112)
at com.sun.corba.ee.internal.iiop.ORB.process(ORB.java:255)
at com.sun.corba.ee.internal.iiop.RequestProcessor.process(RequestProces
sor.java:84)
at com.sun.corba.ee.internal.orbutil.ThreadPool$PooledThread.run(ThreadP
ool.java:99)