Hello guys,

I'm having some problem on deploying CMP Beans on Websphere.

After trying to execute 'findByPrimaryKey', it accuses a 'Table not found' (
ORA-00942) error. I've double checked the pool settings and mappings lots of
 times,
and they seem to be correct!! =/
For some reason I don't know, it seems to be connecting to the wrong
database...
Has anyone gone through this before?
I've migrated my system from Extend to Websphere. Does Websphere considers
what's in 'data-sources.xml'?

Any help would be SO much appreciated.
I'm trying to solve this for almost a week without any success at all.

Thanks!
Pedro

com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Err
or using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.c
ci.WSInteractionImpl@6c5ef346

at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.executeOneRowF
BPK(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExte
nsionImpl.fetchRecordFromDataStore(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExte
nsionImpl.hydrateRecordForLoad(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExte
nsionImpl.executeLoad(Unknown Source)

(...)

at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(New
ConnectionInitialReadCallback.java(Compiled Code))

at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueMan
ager.java(Compiled Code))

at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.j
ava(Compiled Code))

at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.j
ava(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.
java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

DSRA0010E: SQL State = 42000, Error Code = 942
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code
))

(...)

[3/3/06 18:33:45:645 BRT] 0000006d ExceptionUtil E CNTR0019E: EJB threw 
an unexpected (non-declared) exception during invocation of method "findByPr
imaryKey". Exception data: com.ibm.ws.exception.WsEJBException

[ Post a follow-up to this message ]

Hey Meduri,

Where can I find resources.xml?

What I'm trying to do now is to find out which query is my application
(through CMP Beans) executing. I've read on some foruns that Websphere
can change the name of the table, for example, TABLE can be TABLE1, so
this would be the reason for the 'table or view not found error'.

[ Post a follow-up to this message ]

resources.xml will be a file under WAS config. I wouldn't be manually editin
g the files. Adminconsole or was tools is the recommended way. Watch the dep
loy process again as db mapping is done. I don't understand why WAS will be 
renaming tables.

HTH.

[ Post a follow-up to this message ]