Sign in Subscribe
1 min read Java

Configuracion de transacciones distribuidas. so wha?

Vamos a ver como conformamos el archivo de DataSource para JBoss en el caso en el que necesitemos usar transacciones ditribuidas. Un caso normal para esta necesidad es cuando estamos usando dos fuentes de datos en una misma transaccion de JTA, ya que si no configuramos que la transaccion utilice XA no podriamos hacer un commit distribuido. Para esto debemos asegurarnos de que el driver  jdbc soporte XA. En el caso de PostgreSQL no tenemos ningun problema

Con el driver de PostgreSQL

postgre-ds.xml

<datasources>

<xa-datasource> <jndi-name>somethingDS</jndi-name> <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class> <xa-datasource-property name="ServerName">[hostname]</xa-datasource-property> <xa-datasource-property name="PortNumber">[port]</xa-datasource-property> <xa-datasource-property name="DatabaseName">[db]</xa-datasource-property> <xa-datasource-property name="User">[user]</xa-datasource-property> <xa-datasource-property name="Password">[password]</xa-datasource-property> <track-connection-by-tx/> </xa-datasource>

<xa-datasource> <jndi-name>somethingDS2</jndi-name> <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class> <xa-datasource-property name="ServerName">[hostname]</xa-datasource-property> <xa-datasource-property name="PortNumber">[port]</xa-datasource-property> <xa-datasource-property name="DatabaseName">[db]</xa-datasource-property> <xa-datasource-property name="User">[user]</xa-datasource-property> <xa-datasource-property name="Password">[password]</xa-datasource-property> <track-connection-by-tx/> </xa-datasource>

</datasources>

Published by:

Mauricio Salatino

You might also like...

Mar
01

Cloud-Native & OSS is thriving in Brazil

Last Saturday and Monday, I presented at two Brazilian events. The first edition of KCD Sao Paulo (sold out in less than an hour) hosted around 400 people, and a Sou Java meetup hosted by IFood with about 50 people.
4 min read
Dec
29

2023/2024

Wow! What a year it has been! After an incredible 2022, I thought it would be a difficult year to top up, but oh my! This year was intense, but in a perfect way. I’ve traveled the world and met amazing people. I want to thank everyone who approached me to say hello, get a book copy, or share a hug.
12 min read
Dec
14

Back to basics: APIs to rule them all (Dapr on Kubernetes) #2

In this blog post, we will package and deploy the application we coded in the previous blog post to Kubernetes. We will create a local Kubernetes Cluster with Kubernetes KinD, install and configure Dapr, to finally deploy our application.
4 min read
Dec
07

Back to basics: APIs to rule them all (Dapr Statestore APIs) #1

In this short blog post, I wanted to share some of the projects I've been working on lately. I hope that by sharing some of these integrations, experiments, and simple examples, you can apply some of the lessons I learned to your projects, so let's jump right into it.
5 min read
Jul
05

DevBcn 2023

I've been presenting at the JBCN / DevBCN conference, held in Barcelona, Spain, for eight years. Originally started as a Java Conference organized by the local Java User Group, I watched the conference grow from a few hundred people to 1000+.
3 min read