TransactionRolledbackException using CMR !!

[pol.leleux]

Hello all,

I have a table with a non-mandatory foreign key, i.e. it can contain either the id of a linked object or -1 if there is no linked object. I defined a CMR relationship (one-to-many), when I try to fetch the linked object (and there is no linked object but I don't know it yet), I get the following :

=========================================================
15:07:47,899 ERROR [LogInterceptor] TransactionRolledbackException, causedBy:
javax.ejb.NoSuchEntityException: Entity not found: primaryKey=[.-1.]
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoad
EntityCommand.java:165)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoad
EntityCommand.java:62)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreM
anager.java:495)
at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistence
Manager.java:410)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.load
Entity(CachedConnectionInterceptor.java:353)
at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntityS
ynchronizationInterceptor.java:310)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo
ke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstance
Interceptor.java:193)
at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockIntercep
tor.java:107)
at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreation
Interceptor.java:69)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte
rceptor.java:96)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep
==========================================================

I was expecting it would return either 'null' or generate an exception that I could catch but I was not expecting it would rollback the current transaction !! (which destroys all I've done in it till now)

Is there any kind of solution ?

Thanks in advance...

[humps]

'non mandatory Fk' means the relationship does not exist when there is no value in the Fk column. It is the first time I've heard someone using -1 to represent a null!!! I take it you're integrating with a existing DB that has been used like that? Otherwise I cannot imagine someone using -1 provided the Fk is null-able.

You can either map the Fk as CMP field and do a manual get method which would be very ugly, but might just work. Or use null to represent what really is a null.

[pol.leleux]

you are right, I'm integrating with an existing database where "null" relationships are represented with an id set to -1 (valid id values are >= 0).

I was just wondering why JBoss was rollbacking the current transaction when it couldn't find the related object ! It doesn't give you any chance to recover from that kind of problem...

Anyway, converting the database to set the field 'nullable' and set a 'null' value where -1 is found would solve the problem...

Thanks taking time answering...

[humps]

It does depend on your transaction boundaries and code implementation. If you're catching the NoSuchEntity exception and make it carry on in your code, sure, JBoss won't roll back. Or you'll have to decide where to put your set transaction in the descriptors depending on
a) where the transaction was started (session bean?)
b) should that method support transaction at all?
c) or simply try catch finderExp, instanceof NoSuchEntity and say you're ok to carry on without finding something in your code.

good luck