users@glassfish.java.net

Re: AS 9 Transactions accross servers

From: sankara rao bhogi <Sankara.Rao_at_Sun.COM>
Date: Thu, 21 Sep 2006 10:59:41 +0530

petr>> Let me restate my question.

petr>> Does AS9 support distributed transactions?

petr>> Transactions which span over multiple instances of AS9 on separate
boxes.


 Answer to your specific question is yes. Please read interoperability chapter in the EJB specification for more details.



Return-path: <users-return-1030-Sanjeeb.Sahoo=sun.com_at_glassfish.dev.java.net>
Received: from fe-apac-06.sun.com ([192.18.19.177])
 by sedge2-mail1.singapore.sun.com
 (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006))
 with ESMTP id <0J5W00EO8WQEWS80_at_sedge2-mail1.singapore.sun.com> for
 ss141213_at_sedge2-mail1.Singapore.Sun.COM; Thu, 21 Sep 2006 06:20:38 +0800 (SGT)
Received: from conversion-daemon.mail-apac.sun.com by mail-apac.sun.com
 (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006))
 id <0J5W00A01WN88T00_at_mail-apac.sun.com> for
 ss141213_at_sedge2-mail1.Singapore.Sun.COM (ORCPT Sanjeeb.Sahoo_at_sun.com); Thu,
 21 Sep 2006 06:20:38 +0800 (SGT)
Received: from phys-sedge2-1.singapore.sun.com ([129.158.123.14])
 by mail-apac.sun.com
 (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006))
 with ESMTP id <0J5W00564WQEY012_at_mail-apac.sun.com> for
 ss141213_at_sedge2-mail1.Singapore.Sun.COM (ORCPT Sanjeeb.Sahoo_at_sun.com); Thu,
 21 Sep 2006 06:20:38 +0800 (SGT)
Received: from dm-india-01.singapore.sun.com ([129.158.71.103])
 by sedge2-mail1.singapore.sun.com
 (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006))
 with ESMTP id <0J5W00ECTWQEWM80_at_sedge2-mail1.singapore.sun.com> for
 ss141213_at_sedge2-mail1.Singapore.Sun.COM (ORCPT Sanjeeb.Sahoo_at_sun.com); Thu,
 21 Sep 2006 06:20:38 +0800 (SGT)
Received: from sunmail5.uk.sun.com (sunmail5.UK.Sun.COM [129.156.85.165])
        by dm-india-01.singapore.sun.com (8.13.4+Sun/8.13.3/ENSMAIL,v2.2)
 with ESMTP id k8KMKbJ5021700 for <sanjeeb.sahoo_at_india.sun.com>; Thu,
 21 Sep 2006 06:20:38 +0800 (SGT)
Received: from nwk-avmta-1.SFBay.Sun.COM
 (nwk-avmta-1.SFBay.Sun.COM [129.149.246.28])
        by sunmail5.uk.sun.com (8.13.7+Sun/8.13.3/ENSMAIL,v2.2)
 with ESMTP id k8KMKAVS017749 for
 <@sunmail2.sfbay.sun.com:Sanjeeb.Sahoo_at_sun.com>; Wed,
 20 Sep 2006 23:20:36 +0100 (BST)
Received: from pmxchannel-daemon.nwk-avmta-1.sfbay.Sun.COM by
 nwk-avmta-1.sfbay.Sun.COM
 (Sun Java System Messaging Server 6.2 (built Dec 2 2004))
 id <0J5W00B0HWQCM100_at_nwk-avmta-1.sfbay.Sun.COM> for Sanjeeb.Sahoo_at_sun.com
 (ORCPT Sanjeeb.Sahoo_at_sun.com); Wed, 20 Sep 2006 15:20:36 -0700 (PDT)
Received: from brmea-mail-1.sun.com ([192.18.98.31])
 by nwk-avmta-1.sfbay.Sun.COM
 (Sun Java System Messaging Server 6.2 (built Dec 2 2004))
 with ESMTP id <0J5W006I2WQBY640_at_nwk-avmta-1.sfbay.Sun.COM> for
 Sanjeeb.Sahoo_at_sun.com (ORCPT Sanjeeb.Sahoo_at_sun.com); Wed,
 20 Sep 2006 15:20:35 -0700 (PDT)
Received: from relay13.sun.com ([217.140.40.54])
        by brmea-mail-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k8KMKOIS013699 for
 <Sanjeeb.Sahoo_at_sun.com>; Wed, 20 Sep 2006 16:20:25 -0600 (MDT)
Received: from mms13es.sun.com ([160.41.223.54] [160.41.223.54])
 by relay13.sun.com with ESMTP for Sanjeeb.Sahoo_at_sun.com; Wed,
 20 Sep 2006 22:20:24 +0000 (Z)
Received: from relay12.sun.com (relay12.sun.com [217.140.40.34])
 by mms13es.sun.com with ESMTP for Sanjeeb.Sahoo_at_sun.com; Wed,
 20 Sep 2006 22:20:24 +0000 (Z)
Received: from dev.java.net ([64.125.133.206] [64.125.133.206])
 by relay12.sun.com for Sanjeeb.Sahoo_at_sun.com; Wed,
 20 Sep 2006 22:20:23 +0000 (Z)
Received: (qmail 27135 invoked by uid 5000); Wed, 20 Sep 2006 22:20:21 +0000
Received: (qmail 27086 invoked from network); Wed, 20 Sep 2006 22:20:20 +0000
Date: Wed, 20 Sep 2006 18:20:18 -0400
From: "Peter A. Murray" <Peter.Murray_at_Sun.COM>
Subject: Re: AS 9 Transactions accross servers
In-reply-to: <4511BAAB.1090907_at_Sun.COM>
Sender: Peter.Murray_at_Sun.COM
To: users_at_glassfish.dev.java.net
Reply-to: users_at_glassfish.dev.java.net
Message-id: <1158790818.5454.24.camel_at_localhost>
Organization: Sun Microystems
X-Envelope-from: Sanjeeb.Sahoo_at_Sun.COM
X-Envelope-to: @sedge2-mail1.singapore.sun.com:Sankara.Rao_at_Sun.COM
MIME-version: 1.0
X-Mailer: Evolution 2.8.0
Content-type: text/plain
Content-transfer-encoding: 7BIT
Precedence: bulk
Delivered-to: mailing list users_at_glassfish.dev.java.net
X-PMX-Version: 5.2.0.264296
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: AQAAABFaEUWLcwIJAgwHBhtV
X-IronPort-AV: i="4.09,193,1157353200"; d="scan'208";
 a="34838063:sNHT17931648"
X-IRONPORT: SCANNED
References: <1158785833.5454.9.camel_at_localhost> <4511B010.7050507_at_Sun.COM>
 <1158788906.5454.13.camel_at_localhost> <4511BAAB.1090907_at_Sun.COM>
Mailing-List: contact users-help_at_glassfish.dev.java.net; run by ezmlm
List-Post: <mailto:users_at_glassfish.dev.java.net>
List-Unsubscribe: <mailto:users-unsubscribe_at_glassfish.dev.java.net>
List-Help: <mailto:users-help_at_glassfish.dev.java.net>
X-No-Archive: yes
Original-recipient: rfc822;Sanjeeb.Sahoo_at_sun.com

Let me restate my question.

Does AS9 support distributed transactions?

Transactions which span over multiple instances of AS9 on separate
boxes.


Thanks...

Peter

On Wed, 2006-09-20 at 15:03 -0700, Marina Vatkina wrote:
> No, I'm much more pragmatic ;). I'm saying that if there are
> 2 transactions that are happening in parallel, with a single
> database in the background, you need to a) mark any method
> that updates a database as a transactional, and b) if those
> methods can result in updating the same rows, it's safer
> to use version consistency to avoid overriding values from
> one transaction with those from another transaction.
>
> HTH,
> -marina
>
> Peter A. Murray wrote On 09/20/06 14:48,:
> > So you are saying the "transaction" will deal with horizontal scaling of
> > the Appserver?
> >
> > Black box magic which come with using JEE.
> >
> > Peter
> >
> > On Wed, 2006-09-20 at 14:18 -0700, Marina Vatkina wrote:
> >
> >>Peter,
> >>
> >>You must use transaction settings to make sure that any updates
> >>are committed to the database. You'll most probably need to use
> >>version consistency to make sure that any conflicts are detected
> >>at commit of each transaction. If there are no possibility of
> >>parallel updates to the same row, you don't need to do anything
> >>special about it.
> >>
> >>regards,
> >>-marina
> >>
> >>Peter A. Murray wrote On 09/20/06 13:57,:
> >>
> >>>If I have multiple instances of AS9 running on multiple boxes to scale
> >>>horizontally, how dose it impose transaction integrity between the
> >>>boxes.
> >>>
> >>>i.e. I have Entity bean representing a row in a table on the db
> >>>I then have user start an update on that Entity on server A and another
> >>>user start an update on the same Entity on server B.
> >>>
> >>>How do I resolve this or will setting up a transaction around the update
> >>>of the Entity take care of this?
> >>>
> >>>Thanks
> >>>
> >>>Peter
> >>
> >>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> >>For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> >>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
-- 
Sun Grid
Engineer
ACCESS: 212 558-9038
FAX   : 815 333 1264
PAGER : AIM: retepmurray
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net