EntityManager persist() method does not insert record to database

Question

I have problem with using EntityManager.persist(Object) method. Now when i get rid of other problems, by app work without Exception but object is not put in my database.

my entity class:

@Entity
@Table(name ="Chain")
public class Chain implements Serializable{

@Id
@Column(name = "id")
  private Long id;
@Column(name = "date")
  private Date date;
@Column(name = "name")
  private String name;
//setters and getters
}

my dao class:

@Transactional
@Repository("ChainDao")
public class ChainDaoImpl implements ChainDao{


    private EntityManager em;


    @PersistenceContext
    public void setEntityManager(EntityManager em) {
        this. em = em;
    }

    public int saveChain(Chain chain) {
        chain.setDate(new Date());
        chain.setId((long)44);
        Boolean a;
        em.persist(chain);

        return 222;
    }
}

my xml context:

<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" >
    <property name="persistenceXmlLocation" value="classpath*:META-INF/persistence.xml"></property></bean>


    <bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />

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

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

and pereistence.xml:

<persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0">
       <persistence-unit name="sample">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <!-- Scan for annotated classes and Hibernate mapping XML files -->
        <properties>
           <property name="hibernate.archive.autodetection" value="class, hbm"/>
           <property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/>
           <property name="hibernate.connection.url" value="jdbc:postgresql://localhost:5432/database"/>
           <property name="hibernate.connection.username" value="postgres"/>
           <property name="hibernate.connection.password" value="pwd"/>
           <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
           <property name="hibernate.show_sql" value="true"/>
        </properties>
        </persistence-unit>

    </persistence>

Do anyone have a idea what am i missing?

Don't assign a ID to your entity, and let hibernate assign it on save (by using one of ID generation mechanisms). — Amir Pashazadeh, Dec 07 '12 at 09:06
if i use `@GeneratedValue(strategy = GenerationType.AUTO)` i get `org.hibernate.exception.SQLGrammarException: could not get next sequence value` — Grzzzzzzzzzzzzz, Dec 07 '12 at 09:07
Please check your spring-transaction configuration, I had similar problem , and it was due to improper transaction config — Dhananjay, Dec 07 '12 at 09:19
i have the same problem with spring and eclipselink... did you get an appropriate solution.. i hav tried everything roryb suggested to no avail... — Sorter, Jul 26 '13 at 18:44
OMG, i spent some hours with this problem =P .. In my case I'm using Camel, Spring and Hibernate + JPA.. I forgot a little detail. Was missing the **@Transactional** annotation in My **@Service** method. Thanks for **the hint about flush**. I've just put the flush and the long awaited exception appears in the log. nice link about possible causes : http://www.scarba05.co.uk/blog/2010/02/hibernate-jpa-is-swallowing-my-data-no-save-no-error/ — Eduardo Fabricio, Jan 08 '14 at 22:24

score 10 · Accepted Answer · edited May 23 '17 at 12:34

10

Are you getting a specific exception? It would be helpful to know what it is if you are.

There are a number of similar problems to this already on Stackoverflow:

Spring transactional context doesn't persist data

Spring, Hibernate & JPA: Calling persist on entitymanager does not seem to commit to database

These suggest that you should try adding em.flush() after the em.persist(chain), and altering the @transactional annotations

You should also check that you have enabled transactional annotations through a line such as :

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

in your .xml configuration

edited May 23 '17 at 12:34

Community

1
1

answered Dec 07 '12 at 09:16

RoryB

1,047
7
28

1

The thing is that there is no Exception, code is executed, but there is no record put on database. – Grzzzzzzzzzzzzz Dec 07 '12 at 09:17
Hmm, definitely try em.flush() then. – RoryB Dec 07 '12 at 09:23
when i add `flush()` i got `javax.persistence.TransactionRequiredException: no transaction is in progress` should i post full trace? – Grzzzzzzzzzzzzz Dec 07 '12 at 09:26
Well, that is a clearer error: have you tried annotating the method with @transactional? – RoryB Dec 07 '12 at 09:29
my class have `@transactional` annotation however i did as you adviced and exception remains. – Grzzzzzzzzzzzzz Dec 07 '12 at 09:32
Have you enabled transactions annotations in your configuration file? ie have you added a line like: – RoryB Dec 07 '12 at 09:38
i have `` adding `` result in nothing. – Grzzzzzzzzzzzzz Dec 07 '12 at 09:46
i just saw that i get `AbstractSaveEventListener - delaying identity-insert due to no transaction in progress` – Grzzzzzzzzzzzzz Dec 07 '12 at 11:09
4

Why has this answer been accepted? It doesn't sound like it solved your problem. I'm having the same problem, transaction is there but EntityManager does not know about it. If I manually call em.joinTransaction() then it works, but why would I have to do that? – Michel Jung Mar 18 '17 at 12:40

score 7 · Answer 2 · answered Dec 07 '12 at 14:50

7

Try this:

em.getTransaction().begin();
em.persist(entity);
em.getTransaction().commit();

PS: You should set a generation method for your ID as well.

answered Dec 07 '12 at 14:50

Peter Adrian

279
1
5

4

`Not allowed to create transaction on shared EntityManager - use Spring transactions or EJB CMT instead` – Grzzzzzzzzzzzzz Dec 07 '12 at 14:53
1

A JTA EntityManager cannot use getTransaction() – Julien Dec 14 '16 at 08:37
javax.persistence.TransactionRequiredException: no transaction is in progress – valijon Oct 10 '19 at 07:05

Bernardo Vale · Answer 3 · 2012-12-07T09:25:20.453

1

Can you post what exception are you getting? I will assume that your error is that your persistence.xml you don't specified your "Chain" Object.

You can specify using this tag

<exclude-unlisted-classes>false</exclude-unlisted-classes>

Or just

 <class>your.package.Chain</class>

Put this above provider tag.

Also, never set a number for a column tagged as @Id

When you use method save() with a Id column with setted value, hibernate will try to UPDATE NOT INSERT your data.

Do this: Create getEntityManager Method

public EntityManager getEntityManager() {
    return entityManager;
}

Then

@Transactional
public void saveChain(Chain chain) {

    chain.setDate(new Date());
    getEntityManager().persist(chain);
}

edited Dec 07 '12 at 09:25

answered Dec 07 '12 at 09:10

Bernardo Vale

3,224
4
21
34

Still no exception and no record in database – Grzzzzzzzzzzzzz Dec 07 '12 at 09:16
1

OMG, i spent some hours with this problem =P .. In my case I'm using Camel, Spring and Hibernate + JPA.. I forgot a little detail. Was missing the **@Transactional** annotation in My **@Service** method. Thanks for **the hint about flush**. I've just put the flush and the long awaited exception appears in the log. nice link about possible causes : http://www.scarba05.co.uk/blog/2010/02/hibernate-jpa-is-swallowing-my-data-no-save-no-error/ – Eduardo Fabricio Jan 08 '14 at 22:21
thanks you have saved my time. It was due to em.flush(). – Sai prateek Sep 06 '14 at 08:10

score 0 · Answer 4 · answered Mar 06 '15 at 08:09

Adding these to your web.xml may solve this problem:

<!-- Open Entity Manager in View filter -->
<filter>
    <filter-name>openEntityManagerInViewFilter</filter-name>
    <filter-class>org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter</filter-class>
</filter>
<filter-mapping>
    <filter-name>openEntityManagerInViewFilter</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>

score 0 · Answer 5 · answered Jan 05 '18 at 20:41

0

solved my problem using

org.springframework.transaction.jta.JtaTransactionManager

hope this work!

answered Jan 05 '18 at 20:41

Wilson Campusano

616
9
21

score 0 · Answer 6 · answered Feb 19 '18 at 12:21

0

Use @EnableTransactionManagement in AppConfig Configuration file header

answered Feb 19 '18 at 12:21

Arka Bandyopadhyay

355
3
12

Rakesh Singh Balhara · Answer 7 · 2019-09-23T08:32:54.653

0

You can open the new Transaction and then commit your records.

@PersistenceUnit(unitName = "NameOfPersistenceUnit")
private EntityManagerFactory entityManagerFactory;

void someMethod(AccountCommodity accountCommodity){
     EntityManager entityManager = entityManagerFactory.createEntityManager();
     entityManager.getTransaction().begin();
     entityManager.persist(accountCommodity);
     entityManager.flush();
     entityManager.getTransaction().commit();
     entityManager.close();
}

edited Sep 23 '19 at 08:32

answered Jul 31 '19 at 09:41

Rakesh Singh Balhara

326
1
4
13

2

Don't forget to close EntityManager after creating it via EntityManagerFactory – kaiser Sep 23 '19 at 06:11

score -1 · Answer 8 · edited Dec 07 '12 at 09:14

-1

You will need to assign id generation strategy as below:

@Entity
@Table(name ="Chain")
public class Chain implements Serializable{

@Id
@Column(name = "id")
    @GeneratedValue(strategy=GenerationType.IDENTITY)
  private Long id;
@Column(name = "date")
  private Date date;
@Column(name = "name")
  private String name;
//setters and getters
}

and in save method

  public int saveChain(Chain chain) {
        chain.setDate(new Date());
      //chain.setId((long)44);  remove this line
        Boolean a;
        em.persist(chain);

        return 222;
    }

if you assign Id, then hibernate/jpa will try to update record, which is not available, instead of inserting new record and I think will not throw exception.

edited Dec 07 '12 at 09:14

Bernardo Vale

3,224
4
21
34

answered Dec 07 '12 at 09:09

Jigar Parekh

6,163
7
44
64

try to manually flush with `em.flush()`, how transaction is configured? – Jigar Parekh Dec 07 '12 at 09:27
u mean spring configuration? ` ` – Grzzzzzzzzzzzzz Dec 07 '12 at 09:33
I just saw that i get `AbstractSaveEventListener - delaying identity-insert due to no transaction in progress` – Grzzzzzzzzzzzzz Dec 07 '12 at 11:08
1

you should apply `@Transactional(readOnly = false, propagation = Propagation.REQUIRED)` over method `saveChain` to make sure transaction is not read only. by default with just `@Transactional` its readonly. – Jigar Parekh Dec 07 '12 at 12:01

score -1 · Answer 9 · edited Feb 01 '14 at 23:22

-1

I was able to fix the same problem by adding the Entity to persistence.xml:

<persistence-unit name="OwnerPersistenceUnit" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <class>com.test.domain.local.Entity</class>
    <exclude-unlisted-classes />
    </persistence-unit>
</persistence>

edited Feb 01 '14 at 23:22

kryger

12,906
8
44
65

answered Feb 01 '14 at 23:01

hlopezvg

555
5
11

EntityManager persist() method does not insert record to database

9 Answers9

Linked