Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@geronimo.apache.org
Received-SPF: pass (herse.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Updates to OEJB 2.2 and TranQL 1.4
Date: Wed, 22 Nov 2006 16:45:51 +0300
Message-ID: <3D8E84095C6A524A985B787423094E40792F9D@mssmsx411>
Thread-Topic: Updates to OEJB 2.2 and TranQL 1.4
Thread-Index: AccMyhdTkHm3kIdCSReYf2YfvdO+LABcjaMA
From: "Udovichenko, Nellya" <nellya.udovichenko@intel.com>
To: <dev@geronimo.apache.org>

> It does not explicitly allow one to set isolation=20
> level on each call though.

And what about the transaction isolation level setting for particular
EJB (in descriptor plan)?=20

Thanks,=20
Nellya.

-----Original Message-----
From: Matt Hogstrom [mailto:matt@hogstrom.org]=20
Sent: Monday, November 20, 2006 8:26 PM
To: dev@geronimo.apache.org
Subject: Re: Updates to OEJB 2.2 and TranQL 1.4

Yes

Basically it allows one to specify select-for-update to delegate =20
locking to the db.  It does not explicitly allow one to set isolation =20
level on each call though.

I'm modifying the Rar for db2  to allow the specification of a =20
default isolation level so one is not tied to RS for DB2.

On Nov 20, 2006, at 11:02 AM, Udovichenko, Nellya wrote:

> Oh, by the way, doesn't this change address the transaction isolation
> level
> problem in TranQL/OpenEJB (GERONIMO-2128)?
>
> Thanks,
> Nellya Udovichenko.
>
> -----Original Message-----
> From: Matt Hogstrom [mailto:matt@hogstrom.org]
> Sent: Tuesday, November 14, 2006 2:55 AM
> To: dev@geronimo.apache.org; openejb-dev@incubator.apache.org
> Subject: Updates to OEJB 2.2 and TranQL 1.4
>
> I have updated TranQL 1.4 and Open EJB 2.2 to support specification
> of a Select-For-Update clause in the openejb-jar.xsd when deploying
> CMP EJBs.  I have published new SNAPSHOTs of both projects so in a
> perfect world there should be no pain :)
>
> I'll be stress testing DayTrader tonight to confirm that we can run
> an EJB workload under stress.  If no changes are made then the
> current SQL syntax is generated and you'll notice no difference.  If
> you want you can add a <select-for-update>true</select-for-update>
> element to the Entity element in your openejb-jar.
>
> I'll post some results when I finish testing.
>
> Cheers.
>
>
> Matt Hogstrom
> matt@hogstrom.org
>

Matt Hogstrom
matt@hogstrom.org

When the clouds are full they pour the rain out on the earth;
and whether a tree falls to the north, or it falls to the south,
wherever the tree falls, there is lies.