dcsimg
CMP beans throwing SQL exception TransactionRolledBackException
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Shyam_Hundi
Posted On:   Tuesday, October 28, 2003 03:34 AM

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   More>>

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)

   <<Less

Re: CMP beans throwing SQL exception TransactionRolledBackException

Posted By:   Manidip_Ghosh  
Posted On:   Tuesday, October 28, 2003 09:16 PM

hi Shyam,
I faced a similar problem while using websphere. For websphere it has a repository db(for us it has oracle ) . What we did was ...permitting select , update , insert grant on DBA_PENDING_TRANSACTIONS to the application user and the websphere user . Please check if your appserver is using any repository . Then maybe you have to do the same . (Only the sys db user can do this ) (However this problem comes only when we use JTA ) . Anothersuggestion ;) ..check if any application tables is missing from the DB ;).


regards,
Manidip

About | Sitemap | Contact