Skip to main content

Vertica: Spring JTA multiple-resource transactions in Tomcat

  • June 16, 2014
  • 1 reply
  • 2 views
Xin
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

    1 reply

    RadhikaGenesan

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement