Skip to main content

Vertica XA Datasource

  • March 22, 2014
  • 3 replies
  • 7 views
Saravanan
I configured XA Datasource in JBoss for Vertica and could not succeed with the connectivity? Please let me know if XA Datasource is supported? Thank you.

I could use Datasource and connect.

    3 replies

    RadhikaGenesan

    Hi Saravanan,

    I am working on setting up XA Datasource for Vertica. Can you please help share the information you have regarding it ?

    I set up XA for Oracle with help from some blogs online but couldn't not find anything similar for Vertica. :(

    hhromic
    • hhromic
    • New Participant
    • June 25, 2020

    Hi @Saravanan , @RadhikaGenesan ,
    Here at work we are also interested on XA Datasource support in Vertica.
    Did you have any progress on this topic that you could share? Or any information?
    Thanks!

    hhromic
    • hhromic
    • New Participant
    • June 25, 2020

    It seems that Vertica does not support two-phase commits [1] which is required for XA transactions implementation:

    Transactions > Implementation Details:

    • No redo/undo log or two-phase commits.

    Thus probably XA Datasources are not possible at the moment with Vertica.

    [1] https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/ConceptsGuide/Other/Transactions.htm?tocpath=Vertica Concepts|Transactions|_____0

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement