Menu
▾
▴
RE: [JBoss-user] Specifying isolation level
|
From: Saroj K. <kum...@wi...> - 2002-09-20 12:41:38
|
Hi David, Thanks for the reply. Sorry. I mentioned postgres-xa wrongly. It is Informix-xa-service.xml.=20 Thanks, Saroj -----Original Message----- From: jbo...@li... [mailto:jbo...@li...] On Behalf Of David Jencks Sent: Friday, September 20, 2002 5:51 PM To: jbo...@li... 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. =20 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? >=20 > I noticed That Oracle-Xa and Postgres-xa service xmls in Jboss 3.0.2 > have this but commented. >=20 > <!-- > 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=3D"TransactionIsolation" > =20 > type=3D"java.lang.String">TRANSACTION_READ_COMMITTED</config-property> > --> >=20 >=20 > Other db-service.xmls are not having this entry. >=20 > Is it the case that Jboss will take TX Isolation Level supported by the > DB? >=20 > -Saroj >=20 >=20 > -----Original Message----- > From: jbo...@li... > [mailto:jbo...@li...] On Behalf Of David > Jencks > Sent: Thursday, September 19, 2002 11:26 PM > To: jbo...@li... > Subject: Re: [JBoss-user] Specifying isolation level >=20 >=20 > 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: >=20 > bean A, all methods tx required, specifying say READ_UNCOMMITTED >=20 > bean B, all methods tx required, specifying say SERIALIZABLE >=20 > method surprise on A calls doWork on B, isolation is READ_UNCOMMITTED >=20 > If you call doWork on B directly, you get isolation SERIALIZABLE >=20 > 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. >=20 > david jencks >=20 > 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=20 > > attribute of the connections and not the transaction, so unless we > used=20 > > a separate connection for each bean we would not be able to have=20 > > different levels in the same transaction. If we did use different=20 > > connections for each bean, the connections would be isolated from each >=20 > > other so queries that depend on data changed in the transaction (by a=20 > > different bean) would fail. > >=20 > > -dain > >=20 > > 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. > > >=20 > > > david jencks > > >=20 > > > On 2002.09.19 12:12:54 -0400 Emerson Cargnin - SICREDI Servi=E7os > wrote: > > >=20 > > >>why there isn't a property at jboss.xml to define the transaction=20 > > >>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=3D"java.lang.String" > > > >>>name=3D"TransactionIsolation>TRANSACTION_READ_COMMITTED</config-proper= t > 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=20 > > >>>>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 > > >>>>JBo...@li... > > >>>>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 > > >>>JBo...@li... > > >>>https://lists.sourceforge.net/lists/listinfo/jboss-user > > >>> > > >> > > >> > > >>--=20 > > >>xxxxxxxxxxxxxxxxxxxxxxxxxxxx > > >>| Emerson Cargnin | > > >>| Analista de Sistemas Sr. | > > >>| Tel : (051) 3358-4860 | > > >>| SICREDI Servi=E7os | > > >>| Porto Alegre - Brasil | > > >>|xxxxxxxxxxxxxxxxxxxxxxxxxx| > > >> > > >> > > >> > > >>------------------------------------------------------- > > >>This sf.net email is sponsored by:ThinkGeek > > >>Welcome to geek heaven. > > >>http://thinkgeek.com/sf > > >>_______________________________________________ > > >>JBoss-user mailing list > > >>JBo...@li... > > >>https://lists.sourceforge.net/lists/listinfo/jboss-user > > >> > > >> > > >=20 > > >=20 > > >=20 > > > ------------------------------------------------------- > > > This sf.net email is sponsored by:ThinkGeek > > > Welcome to geek heaven. > > > http://thinkgeek.com/sf > > > _______________________________________________ > > > JBoss-user mailing list > > > JBo...@li... > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > >=20 > >=20 > > --=20 > > xxxxxxxxxxxxxxxxxxxxxxxx > > Dain Sundstrom > > Chief Architect JBossCMP > > JBoss Group, LLC > > xxxxxxxxxxxxxxxxxxxxxxxx > >=20 > >=20 > >=20 > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > _______________________________________________ > > JBoss-user mailing list > > JBo...@li... > > https://lists.sourceforge.net/lists/listinfo/jboss-user > >=20 > >=20 >=20 >=20 > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > JBo...@li... > https://lists.sourceforge.net/lists/listinfo/jboss-user >=20 >=20 >=20 > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > JBo...@li... > https://lists.sourceforge.net/lists/listinfo/jboss-user >=20 >=20 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list JBo...@li... https://lists.sourceforge.net/lists/listinfo/jboss-user |