If you use XA transactions, be sure to consider the various failure modes of your system. For example, you need to be aware that transactions will fail if one or the other database is unavailable. Also, you need to plan for how to get back to a consistent state if one or the other of the databases needs to be restored from backup.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jason Hunter Sent: Tuesday, July 11, 2017 5:28 AM To: MarkLogic Developer Discussion <[email protected]> Subject: Re: [MarkLogic Dev General] Multi statement transactions updating more than one database? You could accomplish this with XA transactions (driven by Java). -jh- > On Jul 11, 2017, at 20:20, Christine Schwartz <[email protected]> > wrote: > > Hi all, > > I think I know the answer to this one, but just need confirmation. Is it > possible to use multi statement transactions to update more than one database > during a single explicit commit (xdmp:commit)? > > I think the answer is "no", but I do not use multi statement transactions > that frequently. I need to update two databases for this workflow. > > > Thanks, > > Chris > > Christine Schwartz > Metadata Librarian and XML Database Administrator Princeton > Theological Seminary Library > _______________________________________________ > General mailing list > [email protected] > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general _______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general _______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
