PersistentObjectException: detached entity passed to persist:

[anjan bachchu]

Hi All,

using spring 3.03 and hibernate 3.3.2.GA with postgresql 8.4.x along with Hibernate Commons Annotations 3.1.0.GA.

I have a functional test which tests the persistence layer which is giving me
org.hibernate.PersistentObjectException: detached entity passed to persist: com.vattikutiirf.nucleus.domain.generated.CboImpl.

I have @Transactional for this class, PersistenceLayerImpl and all the DAOImpl classes; I have set show_sql to true and loglevel to trace.
I see that my various DAO classes are getting different Session Objects even though I have passed the same SessionFactory to all of them.

How do I fix this ?
How do I force the same Transaction/Session to be used so that CboImpl does NOT get detached by the time I set it to Family for persistence ?

Thanks for any clues,

BR,
~A

01:08:38,254 ERROR FamilyDAOImpl:37 - persist failed
org.hibernate.PersistentObjectException: detached entity passed to persist: com.vattikutiirf.nucleus.domain.generated.CboImpl
	at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:102)
	at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:637)
	at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:629)
	at org.hibernate.engine.CascadingAction$8.cascade(CascadingAction.java:318)
	at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:292)
	at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:240)
	at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:193)
	at org.hibernate.engine.Cascade.cascade(Cascade.java:154)
	at org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:454)
	at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:288)
	at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:144)
	at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:154)
	at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:110)
	at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:61)
	at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:646)
	at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:620)
	at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:624)
	at com.vattikutiirf.nucleus.domain.generated.FamilyDAOImpl.persist(FamilyDAOImpl.java:33)

@Transactional
public class PersistenceTest {
    public static void main(String ... args) {
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        PersistenceLayer persistenceLayer = (PersistenceLayerImpl) context.getBean("persistenceLayer");

        Address /*Entity*/ address = new AddressImpl();
	address.setState("Karnataka");
        HashSet<AddressImpl> familyAddresses = new HashSet<AddressImpl>(2);
        familyAddresses.add((AddressImpl) address);

        CboPromoter /*Entity*/ promoter = persistenceLayer.findCboPromoterByName("IDF");
        final int VILLAGE_ID = 1782;
        List<CboImpl> cbos = persistenceLayer.findAllCbosByVillageAndPromoter(VILLAGE_ID, promoter.getCboPromoterId());
        CboImpl /*Entity*/ cbo1 = null; // choose one of the Cbos
        if (cbos.size() > 0) {
            cbo1 = (CboImpl) cbos.get(0); // use the 1st cbo from the list of cbos for the village for the given promoter.
        }

        FamilyImpl family = new FamilyImpl();
	.
	.
        family.setFamilyAddresseses(familyAddresses);
        family.setCbo(cbo1);
        persistenceLayer.addFamily(family);
	   
    }
}

@Transactional
public class PersistenceLayerImpl implements PersistenceLayer {
    AddressDAO addressDAO;
    FamilyDAO familyDAO;
    CboDAO cboDAO;
    CboPromoterDAO cboPromoterDAO;
    .
    .
}

@Transactional
public class FamilyDAOImpl implements FamilyDAO {
    private SessionFactory sessionFactory = null;
.
.

}

@Transactional
public class CboDAOImpl implements CboDAO {
    private SessionFactory sessionFactory = null;
.
.
}

@Transactional
public class CboPromoterDAOImpl implements CboPromoterDAO {
    private SessionFactory sessionFactory = null;
.
.

}

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
		http://www.springframework.org/schema/aop
		http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
		http://www.springframework.org/schema/tx
		http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">

   <import resource="beans.xml" />

   <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
      <property name="driverClassName" value="org.postgresql.Driver" />
      <property name="url" value="jdbc:postgresql://localhost/nucleus3" />
      <property name="username" value="postgres" />
      <property name="password" value="1111111111111111" />
      <property name="initialSize" value="5" />
      <property name="maxActive" value="20" />
   </bean>


   <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
      <property name="dataSource" ref="dataSource" />
      <property name="hibernateProperties">
         <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.format_sql">true</prop>
            <prop key="hibernate.use_sql_comments">true</prop>
         </props>
      </property>
      <property name="packagesToScan" value="com.vattikutiirf.nucleus.domain.generated" />
      <!--  <property name="configLocation" value="hibernate.cfg.xml"></property> -->
   </bean>

   <!--  enable the configuration of transactional behavior based on  annotations  -->
   <tx:annotation-driven transaction-manager="transactionManager" />

   <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
      <property name="sessionFactory" ref="sessionFactory" />
   </bean>

   <bean id="addressDAO" class="com.vattikutiirf.nucleus.domain.generated.AddressDAOImpl">
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
   </bean>

   <bean id="jdbcTemplate" class="org.springframework.jdbc.core.simple.SimpleJdbcTemplate">
      <constructor-arg ref="dataSource" />
   </bean>

    <bean id="locationDAO" class="com.vattikutiirf.nucleus.service.LocationDAOImpl">
        <property name="jdbcTemplate" ref="jdbcTemplate" />
    </bean>
    
    <bean id="familyDAO" class="com.vattikutiirf.nucleus.domain.generated.FamilyDAOImpl">
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
    </bean>

    <bean id="cboDAO" class="com.vattikutiirf.nucleus.domain.generated.CboDAOImpl">
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
    </bean>

    <bean id="cboPromoterDAO" class="com.vattikutiirf.nucleus.domain.generated.CboPromoterDAOImpl">
      <property name="sessionFactory">
         <ref bean="sessionFactory" />
      </property>
    </bean>

   <bean id="persistenceLayer" class="com.vattikutiirf.nucleus.bl.PersistenceLayerImpl">
      <property name="familyDAO">
         <ref bean="familyDAO" />
      </property>
      <property name="addressDAO">
         <ref bean="addressDAO" />
      </property>
      <property name="cboDAO">
         <ref bean="cboDAO" />
      </property>
      <property name="cboPromoterDAO">
         <ref bean="cboPromoterDAO" />
      </property>
   </bean>

    <bean id="locationService" class="com.vattikutiirf.nucleus.service.LocationService">
        <property name="locationDAO">
            <ref bean="locationDAO" />
        </property>
        <property name="familyDAO">
           <ref bean="familyDAO" />
        </property>
    </bean>

</beans>