Hi David, Thanks for the reply.
Sorry. I mentioned postgres-xa wrongly. It is Informix-xa-service.xml. Thanks, Saroj -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David Jencks Sent: Friday, September 20, 2002 5:51 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Specifying isolation level All jboss versions use the db default tx isolation level unless you set it explicitly in the config file. AFAIK Oracle xa is the only db that disagrees with our code that sets tx isolation. Where did you get postgres-xa?? postgres doesn't support xa and I don't see any such file in cvs. thanks david jencks On 2002.09.20 06:43:58 -0400 Saroj Kumar wrote: > What is the default TX Isolation Level in JBOSS 3.0.1? > > I noticed That Oracle-Xa and Postgres-xa service xmls in Jboss 3.0.2 > have this but commented. > > <!-- > Do not try to set transaction isolation level here or > you'll get > java.sql.SQLException: ORA-01453: SET TRANSACTION must be > first statement of transaction > Read committed is a default isolation level for Oracle, > so there > is not real need to set it here. I'll take a look into it > later ...maybe. > <config-property name="TransactionIsolation" > > type="java.lang.String">TRANSACTION_READ_COMMITTED</config-property> > --> > > > Other db-service.xmls are not having this entry. > > Is it the case that Jboss will take TX Isolation Level supported by the > DB? > > -Saroj > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of David > Jencks > Sent: Thursday, September 19, 2002 11:26 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] Specifying isolation level > > > 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-propert > y> > > >>> > > >>>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 > > > > ------------------------------------------------------- > 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 ------------------------------------------------------- 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
