[jboss-user] [EJB 3.0] - Foreign keys with 0 and not NULL

We have a legacy application which is prepared to use NULL values for most datatypes (exception: date and timestamp). So a foreign key field of type integer is filled with a zero instead of null in the database. Using Entity Beans now with relations we get this: Caused by: javax.persistence.PersistenceException: javax.persistence.EntityNotFoundException: Unable to find biz.mbisoftware.fn.ejb.entity.MbiMsgss with id 0 | at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:527) | at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:114) | at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:247) | at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:86) | at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177) | at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1382) | ... 8 more | Caused by: javax.persistence.EntityNotFoundException: Unable to find biz.mbisoftware.fn.ejb.entity.MbiMsgss with id 0 | at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:107) | at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:79) | at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:72) | at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111) | at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:64) | at org.hibernate.impl.SessionImpl.firePersistOnFlush(SessionImpl.java:644) | at org.hibernate.impl.SessionImpl.persistOnFlush(SessionImpl.java:636) | at org.hibernate.engine.CascadingAction$9.cascade(CascadingAction.java:323) | at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268) | at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216) | at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169) | at org.hibernate.engine.Cascade.cascade(Cascade.java:130) | at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:131) | at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:122) | at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65) | at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26) | at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) | at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) | at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:515) | ... 13 more | Any hints how to deal with this? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4084273#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...