Hi,

since you can't change the transaction isolation after you start the
transaction, the isolation is determined by the outermost isolation
specifier.

david jencks

On 2001.06.26 16:47:16 -0400 danch (Dan Christopherson) wrote:
> David Jencks wrote:
> Read on - the problem with this occured to a few of us already. Although 
> none of us mentioned putting it in the container-transaction - that's 
> interesting. But what if a method at iso 'read-uncommitted' calls a 
> method in an iso 'serializable' transaction?
> 
> thanks,
> danch
> 
> > Hi,
> > 
> > Forgive me if I am talking nonsense, but doesn't it only make sense to
> have
> > transaction isolation per transaction????  I very much doubt you will
> find
> > a db that can support several transaction isolation levels within one
> > transaction.  I can't quite figure out what it would mean, either.  So
> I
> > say, put it with the transaction requirements for methods - Requires,
> > Requires New, etc.  Then you can set the isolation each time you start
> a
> > new transaction, based on this specification.
> > 
> > david jencks
> > 
> > On 2001.06.26 14:48:00 -0400 Dain Sundstrom wrote:
> > 
> >>>|I added transaction isolation to the new cmp plugin. You can set it
> by
> >>>|adding the  <transaction-isolation> element after the datasource
> >>>
> >>element.
> >>
> >>>|Valid levels are:
> >>>|    transaction-none
> >>>|    transaction-read-committed
> >>>|    transaction-read-uncommitted
> >>>|    transaction-repeatable-read
> >>>|    transaction-serializable
> >>>|
> >>>|Give me 10 minutes and I'll add it to JAWS...
> >>>
> >>>ok but these will be leveraged by new caches in JBoss 3.0
> >>>
> >>>
> >>>
> >>>so I would imagine that each application can set its own datasource
> >>>isolation level, (different kinds of bean).  So it IS user
> configurable
> >>>right???
> >>>
> >>>Also how does it play with the datasources, if the datasource is
> shared
> >>>across applications and different tables support different locking
> >>>
> >>policies
> >>
> >>>(say one table is RO the other RW) can the driver support sequential
> >>>"setIsolationLevel" that only applies to the record and or table
> >>>
> >>touched?
> >>
> >>>marcf
> >>>
> >>>
> >>Right now this the jaws and jbosscmp code only support datasource per
> >>application.  When we implement datasource per bean, we can have
> >>isolation
> >>level per bean.  This leads to the intresting situation with EJB-QL
> >>queries
> >>that thouch multiput beans. May be we need to specify an isolation
> lever
> >>for
> >>each query.  Havn't thought about it much.  Right now you can only set
> it
> >>for the entire ejb-jar.
> >>
> >>Just tell me when you get the cache stuff figgured out and I can update
> >>jaws
> >>and jbosscmp to support what ever you want.
> >>
> >>-dain
> >>
> 
> 
> 
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-development
> 


_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to