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

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file