7 Replies Latest reply on Feb 19, 2019 1:59 AM by zhfeng

rollback transaction does not work

vata2999 Feb 13, 2019 3:10 AM

I created a narayana-artemis-springboot project based on quickstart stock market sample but it does not rollback transaction in case of throwing exception and data will be saved to database.

here is the full samle project .

narayana-boot/PaymentApplication.java at master · omidp/narayana-boot · GitHub

am I missing sth ?

1. Re: rollback transaction does not work

tomjenkinson Feb 13, 2019 5:11 AM (in response to vata2999)

Maybe zhfeng can answer better but my guess is that the connection is not somehow not been configured for XA.

Our example does things like this: quickstart/DatabaseConfig.java at e60eeb850e93e7cc69c2cdaae3c35b52d0c96e48 · jbosstm/quickstart · GitHub

Maybe start with some trace logging on Arjuna so you can see what is happening there, plus a stack trace.
Actions
2. Re: rollback transaction does not work

vata2999 Feb 13, 2019 10:37 PM (in response to tomjenkinson)

I've tried different combination of quickstart examples but most of them are based on jdbc and the one which is based on jpa is not using spring boot.

I am already using XADatasource here

https://github.com/omidp/narayana-boot/blob/master/payment-service/src/main/java/org/springframework/boot/jta/narayana/DbcpXADataSourceWrapper.java

Just to clear few things

Is it okay to use tomcat as spring boot embedded server while my RESTAT runs on wildfly ?

For two different microservices with separated database should it be connected to same artemis server ?
because you can not run spring.artemis.mode=embedded for two different app it will lock the second app.

When we have ManagedDataSource what is the point of NarayanaDataSourceBean, what is the difference?
Actions
3. Re: rollback transaction does not work

vata2999 Feb 14, 2019 1:50 AM (in response to vata2999)

I also realized that in stock market application it is org.springframework.boot.jta.XADataSourceWrapper but it is not anymore there and in my app it is org.springframework.boot.jdbc.XADataSourceWrapper.
Actions
4. Re: rollback transaction does not work

vata2999 Feb 14, 2019 4:55 AM (in response to vata2999)

I added this two attributes in application.properties and it works now

spring.jpa.properties.hibernate.jta.allowTransactionAccess=true
spring.jpa.properties.hibernate.current_session_context_class=jta
Actions
5. Re: rollback transaction does not work

tomjenkinson Feb 14, 2019 5:27 AM (in response to vata2999)

Great - thanks for reporting back! Where did you find the info on how to do that, it might be useful for our community
Actions
6. Re: rollback transaction does not work

vata2999 Feb 14, 2019 7:54 AM (in response to tomjenkinson)

First I was blaming Narayana then I read my ass off through HIbernate and Spring code to find out. well, That's the beauty of opensource
Actions
7. Re: rollback transaction does not work

zhfeng Feb 19, 2019 1:59 AM (in response to vata2999)
We had moved the springboot and narayana integration codes to GitHub - snowdrop/narayana-spring-boot: Narayana Spring Boot autoconfiguration and starter , so I just suggest to use the new artifact
<groupId>me.snowdrop</groupId> <artifactId>narayana-spring-boot-starter</artifactId> <version>2.1.0</version>
Also you could configuration to enable the DBCP support.
narayana.dbcp.enabled=true

Hope this is helpful !
Actions

Go to original post