CMR with entity beans in different databases?

[noleto]

I having problem to delete and list records of a entity that have relation with a entity of another database. I'm using xdoclet to generating code. I specifield the correct database to both entity beans.

I'm using Jboss 3.2.5, Sql Server 2000 with microsoft driver, xdoclet ....

Relation (1:1)
CoordenadorBean (SabiDS) <-------------------> CursoBean (LyceumDS). The default datasource is SabiDS.


stack trace:

org.jboss.tm.JBossTransactionRolledbackException: Load relation failed; CausedByException is:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'COORDENADOR'.; CausedByException is:
Load relation failed; CausedByException is:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'COORDENADOR'.; nested exception is:
javax.ejb.EJBException: Load relation failed; CausedByException is:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'COORDENADOR'.; - nested throwable: (javax.ejb.EJBException: Load relation failed; CausedByException is:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'COORDENADOR'.)

[aloubyansky]

The tables should be in the same db.

[noleto]

Thank you for the answer!

The solution is to use BMP instead of CMP. Isn't it?

[aloubyansky]

Yes, or don't use CMR.