Beginner needs help with Spring + JPA + Transactions

[Julien Martin]

Hello,

I am new to spring and jpa and I cannot get the spring @Transactional annotation to work. My environment is as follows:
-Tomcat 6
-Spring wef flow + JSF
-JPA + Hibernate
-Spring RC1

Here is the content of my appcontext :

   <bean id="controleAdministrationSondages" class="com.jbmlf.ControleAdministrationSondages" scope="singleton">
        <property name="controleAdministrationSondagesDAO" ref="controleAdministrationSondagesDAO"/>
    </bean>
    
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="persistenceUnitName" value="jbmlfPU"/>
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
                <property name="showSql" value="true" />
                <property name="databasePlatform" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
            </bean>
        </property>
    </bean>
    
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory"/>
    </bean>
      
    <bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />
    
    <bean id="controleAdministrationSondagesDAO" class="com.jbmlf.ControleAdministrationSondagesDAO" scope="singleton">
        <property name="entityManagerFactory" ref="entityManagerFactory"/>
    </bean>
    
    <tx:annotation-driven transaction-manager="transactionManager"/>
    

and here is my dao:

@Transactional
public class ControleAdministrationSondagesDAO {
 
   private EntityManagerFactory entityManagerFactory;
     
    @PersistenceUnit
    public void setEntityManagerFactory(EntityManagerFactory entityManagerFactory) {
        System.out.println("I am set!!");
        System.out.println("I am (arg): "+ entityManagerFactory);
        this.entityManagerFactory = entityManagerFactory;
        System.out.println("I am (instance variable set to): "+ this.entityManagerFactory);
    }
    
    
    public void save(Sondage sondage) {
        if(getEntityManagerFactory() == null) System.out.println("emf is null");
         System.out.println("I am: "+ entityManagerFactory);
        EntityManager em = getEntityManagerFactory().createEntityManager();
        if(em == null) System.out.println("em is null");
        em.persist(sondage);
    }
 
    public EntityManagerFactory getEntityManagerFactory() {
        return entityManagerFactory;
    }
}
 

The method that calls the DAO:

@Transactional(propagation = Propagation.REQUIRES_NEW)
    public void creerSondage(Sondage sondage) {
        System.out.println("creerSondage");
 
        Sondage s = new Sondage(1);
        s.setDateCreation(new Date());
        s.setDateDebut(new Date());
        s.setDetailQuestion("How old R U?");
        s.setIdentifiantAdministrateur(new Administrateur(1));
        s.setIsQuestionMultiple(2);
        s.setNomSondage("Age Poll");
 
        List<Reponsepossible> rps = new ArrayList<Reponsepossible>();
        Reponsepossible rp1 = new Reponsepossible(1);
        rp1.setIdentifiantSondage(s);
        rp1.setDetailReponse("18-30");
        Reponsepossible rp2 = new Reponsepossible(2);
        rp2.setIdentifiantSondage(s);
        rp2.setDetailReponse("30-50");
        rps.add(rp1);
        rps.add(rp2);
 

        s.setReponsepossibleCollection(rps);
 

        controleAdministrationSondagesDAO.save(s);
        //em.persist(s);
 

        System.out.println("Fin creer sondage");
    }
 

And yet nothing is committed. I don't want to have programmatic commits in my app.

What am I getting wrong?

Julien.

PS. I searched the forum for an problem and environment similar to mine but to no avail.

[Susanta Chatterjee]

Try changing your save method to:

public void save(Sondage sondage) {
  if(getEntityManagerFactory() == null) System.out.println("emf is null");
  System.out.println("I am: "+ entityManagerFactory);
  EntityManager em = getEntityManagerFactory().createEntityManager();
  EntityTransaction tx = em.getTrasaction() ;  // <-- Add Transaction 
  tx.begin() ;                              // <-- Transaction begins here 
        if(em == null) System.out.println("em is null");
        em.persist(sondage);
  }
  tx.commit() ; // <-- Transaction commits here
}
   

[Julien Martin]

No no. The whole point of using Spring is to have the automatic transaction demarcation with the @Transactional annotation. I don't want to do manual commits.... Any other idea?
J.

[Edvins Reisons]

Julien,

if you believe that this question is about Spring (you may try to port the code to, say, EJB, to check this), there is an Application Frameworks forum on this site for discussions of Spring.
[ November 19, 2007: Message edited by: Edvins Reisons ]

[Julien Martin]

Hello again,
I found the solution. I added this in my class:

@PersistenceContext(unitName="jbmlfPU")
EntityManager em ;

Thanks again to all,

Julien.