We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Vertica: Spring JTA multiple-resource transactions in Tomcat — Vertica Forum

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