[Info-ingres] What does XA_END mean in the SC930 log?

[Gordon Thorpe]

Roy,

As far as I can recall, XA_END is something that happens prior to preparing and committing the distributed connection.  The sequence is basically:
                XA_START
                XA_END
                XA_PREPARE
                XA_COMMIT

XA_END is issued when the XA Transaction Manager calls javax.transaction.xa.XAResource.end() - not that it will help you much.  Our JdbcXAConn class implements the XAConnection and XAResource interfaces and is controlled by a JDBC connection pool manager and XA Transaction Manager.  What actions drive those resources is a bit of a mystery to me.

Gordy


From: Karl and Betty Schendel [mailto:schendel at kbcomputer.com]
Sent: Thursday, December 21, 2017 9:21 AM
To: Gordon Thorpe <Gordon.Thorpe at actian.com>
Subject: Fwd: [Info-ingres] What does XA_END mean in the SC930 log?

Hi Gordy,
don't know if you still see info-ingres questions...
I can sort of answer the first one, but XA in general is a black box to me.

Karl


> Begin forwarded message:
>
> From: Roy Hann <specially at processed.almost.meat<mailto:specially at processed.almost.meat>>
> Subject: [Info-ingres] What does XA_END mean in the SC930 log?
> Date: December 21, 2017 at 11:54:33 AM EST
> To: info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
>
> When I see an XA_END in the trace log, what will have happened to cause
> that? Is there a JDBC XAconnection method to explicitly signal the end
> of the transaction or is it (somehow) implicit?
>
> If there was a transaction open but there was no preceding XA_COMM is
> the transaction implicitly committed or rolled back? (I guess it is
> committed.)
>
> Is whatever it is that causes an XA_END to be logged a legitimate
> alternative to explicitly executing the commit method on the session
> object (within a 2PC coordinator)?
>
> Roy
>
>
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org<mailto:Info-ingres at lists.planetingres.org>
> http://lists.planetingres.org/mailman/listinfo/info-ingres<http://lists.planetingres.org/mailman/listinfo/info-ingres>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20171221/7dd11cc1/attachment.html>