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
