Not allowed to create transaction on shared EntityManager - use Spring transactions or EJB CMT

Question

This post is in continuation of JPA How to get the value from database after persist

When I execute the following I am getting following exception, how can I resolve this?

Not allowed to create transaction on shared EntityManager - use Spring 
transactions or EJB CMT

DAOImpl code

public void create(Project project) {
        entityManager.persist(project);
        entityManager.getTransaction().commit();
        project = entityManager.find(Project.class, project.getProjectId());
        entityManager.refresh(project);
        System.out.println("Id    -- " + project.getProjectId());
            System.out.println("no -- " + project.getProjectNo());
    }

applicationContext.xml

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd">

    <bean id="DataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="username" value="scott" />
        <property name="password" value="tiger" />
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
        <property name="url" value="jdbc:oracle:thin:@myserver:1521:ORCL" />
    </bean>

    <bean id="entityManagerFactory"
        class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="DataSource" />
        <property name="packagesToScan" value="test.entity" />
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
                <property name="showSql" value="true" />
                <property name="generateDdl" value="false" />
                <property name="databasePlatform" value="org.hibernate.dialect.Oracle10gDialect" />
            </bean>
        </property>
    </bean>

    <context:component-scan base-package="test.net" />

    <tx:annotation-driven transaction-manager="transactionManager"/> 

     <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory" />
    </bean>         

     <context:annotation-config/>

</beans>

score 64 · Accepted Answer · edited Aug 13 '13 at 06:31

64

I guess the problem here is that although you have defined the bean for the transaction manager, you haven't annotated the create() method with @Transactional which enables spring transactions.

Also remove the entityManager.getTransaction().commit(); statement as now all the transaction management will be handled by spring, if you leave the statement as it is then you will get the same error again.

edited Aug 13 '13 at 06:31

Adel Khayata

2,717
10
28
46

answered Aug 13 '13 at 06:12

Siddhartha Negi

656
6
5

5

when you autowire the entitymanager with @PersistenceContext i still get the same error even when i annotate the method with Transactional and remove the commit statement – Maurice Aug 09 '18 at 18:46
1

Like maurice said, this doesnt resolve my issue. I get :javax.persistence.TransactionRequiredException: Executing an update/delete query" error – KMC Nov 23 '19 at 18:37

score 33 · Answer 2 · answered Nov 09 '18 at 05:19

33

Injecting EntityManagerFactory instead of EntityManager and javax.transaction.Transactional annotation on method solved my issue as shown below.

//Autowire EntityManagerFactory
@PersistenceUnit(unitName = "readwrite.config")
private EntityManagerFactory entityManagerFactory;


//Use below code on create/update
EntityManager entityManager = entityManagerFactory.createEntityManager();

entityManager.getTransaction().begin();
if (!ObjectUtils.isEmpty(entity) && !entityManager.contains(entity)) {
   entityManager.persist(entity);
   entityManager.flush();
}
entityManager.getTransaction().commit();

answered Nov 09 '18 at 05:19

Anil Konduru

878
10
18

This resolved my problem but my only question is if we can create entityManager from entityManagerFactory as a class member property and use it in different methods that I have forexample in my dao class? – Shilan Feb 25 '19 at 13:12
8

org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'readwrite.config' available – gene b. Feb 20 '20 at 16:24
1

This solved my problem. But how why @Transactaional annotation not working instead of begin()?? – soumitra chatterjee Oct 10 '20 at 20:14
@geneb. you put 'default' instead 'readwrite.config' – pazfernando Jun 05 '22 at 04:31
3

It will work without mentioning `(unitName = "readwrite.config")` as well otherwise it will give error – Vishal Zanzrukia Sep 10 '22 at 13:09

score 9 · Answer 3 · edited Jul 15 '22 at 10:11

9

You need to remove the statement entityManager.getTransaction().begin() and annotate the method using @Transactional? which enables transaction handling by Spring.

edited Jul 15 '22 at 10:11

Oliver

3,815
8
35
63

answered Feb 16 '20 at 09:27

Syam Kumar

91
1
1

score 3 · Answer 4 · answered May 08 '23 at 21:41

In my case inside Sping-boot this solution worked

@Transactional(propagation = Propagation.NEVER)
public void myMethod() {

    SessionImplementor sessionImp = (SessionImplementor) em.getDelegate();
    var transaction = sessionImp.getTransaction();
    for (MyClass cls : lst) {
        try {
            transaction.begin();
            //do my stuffs with em
            transaction.commit();
        } catch (Exception e) {
            transaction.rollback();
        }
    }
}

Not allowed to create transaction on shared EntityManager - use Spring transactions or EJB CMT

4 Answers4

Linked