Vertica: Spring JTA multiple-resource transactions in Tomcat


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:
Do you know if Vertica JDBC driver supports XA transaction? Is there any good practise for this?


  • 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,

Leave a Comment

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