Nested transaction in Spring app with JPA (postgres)

Question

Is it possible to have PROPAGATION_NESTED in @Transactional() with JPA using postgres? I am getting:

org.springframework.transaction.NestedTransactionNotSupportedException:
JpaDialect does not support savepoints - check your JPA provider's capabilities

I tried:

@Bean
public PlatformTransactionManager transactionManager() {
    JpaTransactionManager transactionManager = new JpaTransactionManager();
    transactionManager.setEntityManagerFactory(entityManagerFactory()
                .getObject());
    transactionManager.setNestedTransactionAllowed(true);
    return transactionManager;
}

But with no success.

Which JPA implementation are you using?

Halil
– Halil

2017-08-21 08:30:21 +00:00
Commented Aug 21, 2017 at 8:30 — Halil
– Halil, Commented Aug 21, 2017 at 8:30

Halil · Accepted Answer · 2017-08-21 08:51:48Z

17

I am assuming that you are using Hibernate. NESTED transactions is not possible with Hibernate.

In the following code excerpt, spring sets savePointManager. But there is no class implementing SavepointManager in Hibernate.

answered Aug 21, 2017 at 8:51

Halil

2,3574 gold badges30 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Semyon Danilov Over a year ago

Yes, I do use Hibernate. Ah, that's too bad. Suppose I will move from Hibernate to something else

Dejia Meng · Accepted Answer · 2021-03-25 02:48:24Z

-2

savepointAllowed is true, it means Transaction manager allow nested transactions. But JpaDialect does not support savepoints.

edited Mar 25, 2021 at 2:48

answered Mar 23, 2021 at 6:41

Dejia Meng

11 bronze badge

Collectives™ on Stack Overflow

Nested transaction in Spring app with JPA (postgres)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related