Vertica: Spring JTA multiple-resource transactions in Tomcat
Hi,
I am looking into implementing distributed multiple resource transactions in Spring. I have two datasources: mysql and vertica. I want update the record in two servers at the same time and if there is any exception, the transaction should be rolled back. I saw the example for mysql: http://www.javacodegeeks.com/2013/07/spring-jta-multiple-resource-transactions-in-tomcat-with-atomik...
Do you know if Vertica JDBC driver supports XA transaction? Is there any good practise for this?
Thanks,
X
I am looking into implementing distributed multiple resource transactions in Spring. I have two datasources: mysql and vertica. I want update the record in two servers at the same time and if there is any exception, the transaction should be rolled back. I saw the example for mysql: http://www.javacodegeeks.com/2013/07/spring-jta-multiple-resource-transactions-in-tomcat-with-atomik...
Do you know if Vertica JDBC driver supports XA transaction? Is there any good practise for this?
Thanks,
X
0
Comments
Hi Xin,
I am trying to implement distributed transactions in my application with Oracle and Vertica DBs. I was able to set up XA for Oracle successfully.
I am looking for some help for Vertica. Were you able to set up XA transactions with Vertica successfully. If yes, could you help ?
Thanks and Regards,
Radhika