Comments

• RadhikaGenesan

  January 2018

  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.

  0
• hhromic Vertica Customer

  June 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!

  0
• hhromic Vertica Customer

  June 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

  0