From user-return-15743-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org Sat Sep 17 16:44:40 2011 Return-Path: X-Original-To: apmail-geronimo-user-archive@www.apache.org Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9F11C8E97 for ; Sat, 17 Sep 2011 16:44:40 +0000 (UTC) Received: (qmail 17658 invoked by uid 500); 17 Sep 2011 16:44:40 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 17580 invoked by uid 500); 17 Sep 2011 16:44:39 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 17571 invoked by uid 99); 17 Sep 2011 16:44:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 Sep 2011 16:44:39 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [98.136.44.55] (HELO smtp110.prem.mail.sp1.yahoo.com) (98.136.44.55) by apache.org (qpsmtpd/0.29) with SMTP; Sat, 17 Sep 2011 16:44:31 +0000 Received: (qmail 23364 invoked from network); 17 Sep 2011 16:44:09 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:Mime-Version:Content-Type:Subject:Date:In-Reply-To:To:References:Message-Id:X-Mailer; b=SYuZ3jVswfzZ3L08JJMcmEnBIgv/bvn2GQ2ilUqYbSX9vOovk1IgnSiBKO5wB+Y1VrlQM560TN9Jso9MioASHflWqgpdScfOV4Ydzp5WjhA95s7HZnGT2oP8Mp9zCOzPt/4uT8McVvs5Flo2rKPy7sSl96hY0mpNZvYmw2recIQ= ; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1316277849; bh=+t/x0IrkY9EGjVtx0flkg25CXjz4pXdjU+3zr+vag5A=; h=X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:Mime-Version:Content-Type:Subject:Date:In-Reply-To:To:References:Message-Id:X-Mailer; b=Z+mq/P8lf7/9dKrPzfakZ/ypcQX2NKoZLUPTzy9UXAaCzywFB4JgN7P2rLTMLX00xPWv42Uh5IzhnZgWiNP5rbpCN6OSPtduujpm+PcK/GjrSXFPtT+BtRrEkg6PbPNXjkNHQSPS5O+uNCKBS7usqmJOVpD4Xeplm6hrq6kntWM= X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: CcBYaJUVM1kDr.lBJYa9_PYEOxbWAUpysqpKYLdG4g9jwGp d8OofEIdO1SsZahGB2REgV7.zaF0Rvh54DC2JGwr3VymH1EL_jmJFdVTr6Ax _dGLqaG2O6fQc8ZB_KY0xCL11iOzOmjdH3_DD1pi7eWUDhhTMSkG7OOb5BO0 T8SQmBhCL5c86sXRfdBSecAi1M2DGnSiaIun7MYKmgpNHCaeW_EqCeRPVHTj 8f4bIX_MLZvP46DNg6FGM1R4ZX7jv5X6spMvEDJ4xRvAkR51ci90f5pmBH2D vvyTTYU.9PGOEO9tMTSYMW30TT0yQp5Pikp3kU1zgYwJpJsNx9IBgtjWgpvw kAb4leDjgYMQ0fI9rsMPqeAWvMkPJ9990ROFAQjrkRoXfYUg7QNm..VsWdma x9w6Rg2EYHvEYBk2d7waOssCjkXJoJvln.4Q- X-Yahoo-SMTP: .9oIUzyswBANsYgUm_5uPui0skTnzGJXJQ-- Received: from [10.0.1.4] (david_jencks@76.76.148.215 with plain) by smtp110.prem.mail.sp1.yahoo.com with SMTP; 17 Sep 2011 09:44:09 -0700 PDT From: David Jencks Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: multipart/alternative; boundary=Apple-Mail-5-815715257 Subject: Re: Adding XA start flags for transactions Date: Sat, 17 Sep 2011 09:44:07 -0700 In-Reply-To: To: user@geronimo.apache.org References: <33C96469-8C72-44A7-BDA2-5740546E15F9@yahoo.com> Message-Id: X-Mailer: Apple Mail (2.1084) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-5-815715257 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi, Can you point me to the db2 documentation you are looking at? Does your = "manual" xa code use more than one branch XID for the same global XID = for the same db2 resource? The geronimo tm should be using the same = branch xid for all access to the same db2 resource within a single = global xid, so there shouldn't be any question of lock conflicts. Are you using more than one datasource connected to the same db2 server? = Can you show your datasource plan? thanks david jencks On Sep 16, 2011, at 11:38 AM, Shika Maru00 wrote: > Hi David,=20 >=20 > I have primarily made use of non standard flags in the case of DB2 - = which provides a TMLCS flag to enable sharing of locks (to prevent lock = timeouts). In other words, one must manually enable tight coupling. = The wording on the IBM site is a little odd, but that's been my = experience when testing with manual XA code. >=20 >=20 > On Fri, Sep 16, 2011 at 1:47 PM, David Jencks = wrote: > Hi, >=20 > WAS CE and Geronimo don't support distributed transactions (where more = than one transaction manager is used in a single xa transaction, all but = one as "branches" of the primary transaction). (Note that WAS CE and = Geronimo do support XA transactions with an arbitrary number of XA = resources enrolled. However, all the XAResources have to be actual = resource managers such as a database, jms broker, etc, they can't be = other remote tx manager instances. This is only because we haven't = written any tx-aware transports for e.g. remote ejb calls). >=20 > The only use I'm aware of for loosely coupled transactions is for = distributed transactions where more than one tm and process are making = changes in the same tx using different branches. Within a single = process and tm, all the work on one resource manager should be done = within the same tx branch, making the loose coupling irrelevant. >=20 > Anyway, right now we don't support this (non-xa-standard AFAIK) flag. = I'd be interested to see more information on why you think it would be = helpful. >=20 > thanks > david jencks >=20 > On Sep 16, 2011, at 10:22 AM, Shika Maru00 wrote: >=20 > > Is it possible to add flags to the geronima transaction manager when = it starts up a resource? (using enlistResource internally). > > > > I need to add a flag to enable loose coupling on ORACLE and DB2 = (oratransloose and tmlcs). But this must be done when someone calls the = XAResource start() , which includes the flag parameter. As I don't have = direct control of XAResource (as the client I only use the = UserTransaction object) I'm not sure how to do this. > > > > Some TMs, like webspheres, do this internally and provide some other = method for the user to specify it. I am using Websphere Application = Server Comunity Edition, which makes use of geronimo. What can I do? >=20 >=20 --Apple-Mail-5-815715257 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii

Are you using more = than one datasource connected to the same db2 server?  Can you show = your datasource plan?

thanks
david = jencks

On Sep 16, 2011, at 11:38 AM, Shika = Maru00 wrote:

Hi David,

I have primarily made use of non = standard flags in the case of DB2 - which provides a TMLCS flag to = enable sharing of locks (to prevent lock timeouts).  In other = words, one must manually enable tight coupling.  The wording on the = IBM site is a little odd, but that's been my experience when testing = with manual XA code.


On Fri, Sep 16, 2011 at 1:47 PM, = David Jencks <david_jencks@yahoo.com> wrote:
Hi,

WAS CE and Geronimo don't support distributed transactions (where more = than one transaction manager is used in a single xa transaction, all but = one as "branches" of the primary transaction). (Note that WAS CE and = Geronimo do support XA transactions with an arbitrary number of XA = resources enrolled.  However, all the XAResources have to be actual = resource managers such as a database, jms broker, etc, they can't be = other remote tx manager instances.  This is only because we haven't = written any tx-aware transports for e.g. remote ejb calls).

The only use I'm aware of for loosely coupled transactions is for = distributed transactions where more than one tm and process are making = changes in the same tx using different branches.  Within a single = process and tm, all the work on one resource manager should be done = within the same tx branch, making the loose coupling irrelevant.

Anyway, right now we don't support this (non-xa-standard AFAIK) flag. =  I'd be interested to see more information on why you think it = would be helpful.

thanks
david jencks

On Sep 16, 2011, at 10:22 AM, Shika Maru00 wrote:

> Is it possible to add flags to the geronima transaction manager = when it starts up a resource? (using enlistResource internally).
>
> I need to add a flag to enable loose coupling on ORACLE and DB2 = (oratransloose and tmlcs).  But this must be done when someone = calls the XAResource start() , which includes the flag parameter. As I = don't have direct control of XAResource (as the client I only use the = UserTransaction object) I'm not sure how to do this.
>
> Some TMs, like webspheres, do this internally and provide some = other method for the user to specify it. I am using Websphere = Application Server Comunity Edition, which makes use of geronimo. =  What can I do?



= --Apple-Mail-5-815715257--