From: Dain S. <da...@da...> - 2002-09-19 18:31:44
|
Yes. Pete Beck wrote: > On that basis, wouldn't it be possible to configure two datasources, and > just use different datasources for different beans? > > > On Thu, 2002-09-19 at 18:26, 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 >>>>>> |