You could have a bunch of properties per connection factory and per ejb-method that could be set just before a connection was enlisted in a transaction for the first time. Transaction isolation could be one of these. Weblogic does something like this. I think it would be ridiculously confusing because:
bean A, all methods tx required, specifying say READ_UNCOMMITTED bean B, all methods tx required, specifying say SERIALIZABLE method surprise on A calls doWork on B, isolation is READ_UNCOMMITTED If you call doWork on B directly, you get isolation SERIALIZABLE I think it would be hell to implement and maintain and provide questionable benefits at best. Having another db pool with another isolation level and using it when you want the other isolation level seems simpler, straightforward, and less apt to result in unpleasant surprises. david jencks On 2002.09.19 13:26:59 -0400 Dain Sundstrom wrote: > Is this even possible? I don't think it is. Isolation level is an > attribute of the connections and not the transaction, so unless we used > a separate connection for each bean we would not be able to have > different levels in the same transaction. If we did use different > connections for each bean, the connections would be isolated from each > other so queries that depend on data changed in the transaction (by a > different bean) would fail. > > -dain > > David Jencks wrote: > > Rereading the post you responded to I still think I explained the > situation > > fairly well. This feature has not been requested often (I think twice > so > > far). It's possible, but would require a fair amount of code, would > > probably be extremely confusing to use, and doesn't seem to be a high > > priority. > > > > david jencks > > > > On 2002.09.19 12:12:54 -0400 Emerson Cargnin - SICREDI Servi�os wrote: > > > >>why there isn't a property at jboss.xml to define the transaction > >>isolation at ejb level, isn't it possible? > >> > >>David Jencks wrote: > >> > >>>You can only specify it per-datasource, not per-bean. Most dbs seem > to > >>>commit or throw an error if you try to change the isolation level > >> > >>inside a > >> > >>>transaction. I guess it would be possible to include a tx isolation > >> > >>spec > >> > >>>with the method transaction specs, but I think it would be pretty > >>>confusing, since only the method call that actually started the tx > >> > >>would > >> > >>>have an effect. > >>> > >>> > >>>To set it, include something like > >>> > >>><config-property type="java.lang.String" > >>>name="TransactionIsolation>TRANSACTION_READ_COMMITTED</config-property> > >>> > >>>in your db-service.xml file. > >>> > >>>david jencks > >>> > >>>On 2002.09.19 11:20:34 -0400 Jim Crossley wrote: > >>> > >>> > >>>>I hope this isn't too dumb of a question, but how do I specify a > >>>>READ_COMMITTED isolation level for one of my CMP beans? > >>>> > >>>>The QuickStart guide mentions the different isolation levels, but it > >>>>doesn't > >>>>tell me how to specify them. > >>>> > >>>>Thanks, > >>>>Jim > >>>> > >>>> > >>>>------------------------------------------------------- > >>>>This sf.net email is sponsored by:ThinkGeek > >>>>Welcome to geek heaven. > >>>>http://thinkgeek.com/sf > >>>>_______________________________________________ > >>>>JBoss-user mailing list > >>>>[EMAIL PROTECTED] > >>>>https://lists.sourceforge.net/lists/listinfo/jboss-user > >>>> > >>>> > >>> > >>> > >>> > >>>------------------------------------------------------- > >>>This sf.net email is sponsored by:ThinkGeek > >>>Welcome to geek heaven. > >>>http://thinkgeek.com/sf > >>>_______________________________________________ > >>>JBoss-user mailing list > >>>[EMAIL PROTECTED] > >>>https://lists.sourceforge.net/lists/listinfo/jboss-user > >>> > >> > >> > >>-- > >>xxxxxxxxxxxxxxxxxxxxxxxxxxxx > >>| Emerson Cargnin | > >>| Analista de Sistemas Sr. | > >>| Tel : (051) 3358-4860 | > >>| SICREDI Servi�os | > >>| Porto Alegre - Brasil | > >>|xxxxxxxxxxxxxxxxxxxxxxxxxx| > >> > >> > >> > >>------------------------------------------------------- > >>This sf.net email is sponsored by:ThinkGeek > >>Welcome to geek heaven. > >>http://thinkgeek.com/sf > >>_______________________________________________ > >>JBoss-user mailing list > >>[EMAIL PROTECTED] > >>https://lists.sourceforge.net/lists/listinfo/jboss-user > >> > >> > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > _______________________________________________ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > -- > xxxxxxxxxxxxxxxxxxxxxxxx > Dain Sundstrom > Chief Architect JBossCMP > JBoss Group, LLC > xxxxxxxxxxxxxxxxxxxxxxxx > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
