The default isolation level is whatever Oracle sets as the default
isolation level.  I don't know what it is.

You need to make the ManagedConnectionFactoryProperties more like this:

        <attribute name="ManagedConnectionFactoryProperties">
          <properties>
            <config-property name="TransactionIsolation"
type="java.lang.String">TRANSACTION_READ_COMMITTED</config-property>
            <config-property name="ConnectionURL"
type="java.lang.String">jdbc:oracle:thin:@youroraclehost:1521:yoursid</config-property>
            <config-property name="DriverClass"
type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
            <!--set these only if you want only default logins, not through
JAAS -->
            <config-property name="UserName"
type="java.lang.String"></config-property>
            <config-property name="Password"
type="java.lang.String"></config-property>
          </properties>

        </attribute>


With luck I haven't made a typo;-)
david jencks

On 2002.06.20 12:45:58 -0400 Alice Ad wrote:
> 
>  Thanks a lot, David.
> I'm still not sure what to do: Do I write in my "mydb-service.xml" a line
> like this?
> <attribute name="TransactionIsolationLevel"> TRANSACTION_READ_COMMITTED
> </attribute>
> Is there a DTD for oracle-service.xml? How do I know what tags to write?
> Secondly, what is the default isolation level, i.e., if you don't specify
> any isolation level in the configuration file?
> Thanks very much.
>  
>  
>   David Jencks <[EMAIL PROTECTED]> wrote: First, please
> upgrade to at least 3.0 final release. You will get very
> little support for previous 3.0 versions.
> 
> The default tx isolation is determined by the jdbc driver you are using. 
> You can specify it for datasources using the local wrapper with a
> config-property TransactionIsolation and string values like
> TRANSACTION_READ_COMMITTED in your mydb-service.xml file
> 
> david jencks
> 
> 
> 
> On 2002.06.19 21:23:29 -0400 Alice Ad wrote:
> > 
> > Hello,
> > What's the default Transaction Isolation Level for jboss 3 beta? Where
> > can I change this (in configuration files)?
> > Thanks a lot.
> > 
> > 
> > 
> > 
> > ---------------------------------
> > Do You Yahoo!?
> > Sign-up for Video Highlights of 2002 FIFA World Cup
> > 
>  Hello,
> > 
> What's the default Transaction Isolation Level for jboss 3 beta? Where
> > can I change this (in configuration files)?
> > 
> Thanks a lot.
> > 
>  
> 
> 
> 
> ---------------------------------
> Do You Yahoo!?
> 
> > Sign-up
> > for Video Highlights of 2002 FIFA World Cup
> 
> 
> -------------------------------------------------------
> Bringing you mounds of caffeinated joy
> >>> http://thinkgeek.com/sf <<<
> 
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 
> ---------------------------------
> Do You Yahoo!?
> Sign-up for Video Highlights of 2002 FIFA World Cup
> <P>&nbsp;Thanks a lot, David.
> <P>I'm still not sure what to do: Do I write in my "mydb-service.xml" a
> line like this?
> <P>&lt;attribute name="TransactionIsolationLevel"&gt;
> TRANSACTION_READ_COMMITTED &lt;/attribute&gt;
> <P>Is there a DTD for oracle-service.xml? How do I know what tags to
> write?
> <P>Secondly, what is the default isolation level, i.e., if you don't
> specify any isolation level in the configuration file?
> <P>Thanks very much.
> <P>&nbsp;
> <P>&nbsp;
> <P>&nbsp; <B><I>David Jencks &lt;[EMAIL PROTECTED]&gt;</I></B>
> wrote: 
> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
> #1010ff 2px solid">First, please upgrade to at least 3.0 final release.
> You will get very<BR>little support for previous 3.0 versions.<BR><BR>The
> default tx isolation is determined by the jdbc driver you are using.
> <BR>You can specify it for datasources using the local wrapper with
> a<BR>config-property TransactionIsolation and string values
> like<BR>TRANSACTION_READ_COMMITTED in your mydb-service.xml
> file<BR><BR>david jencks<BR><BR><BR><BR>On 2002.06.19 21:23:29 -0400
> Alice Ad wrote:<BR>&gt; <BR>&gt; Hello,<BR>&gt; What's the default
> Transaction Isolation Level for jboss 3 beta? Where<BR>&gt; can I change
> this (in configuration files)?<BR>&gt; Thanks a lot.<BR>&gt; <BR>&gt;
> <BR>&gt; <BR>&gt; <BR>&gt; ---------------------------------<BR>&gt; Do
> You Yahoo!?<BR>&gt; Sign-up for Video Highlights of 2002 FIFA World
> Cup<BR>&gt; 
> <P>&nbsp;Hello,<BR>&gt; 
> <P>What's the default Transaction Isolation Level for jboss 3 beta?
> Where<BR>&gt; can I change this (in configuration files)?<BR>&gt; 
> <P>Thanks a lot.<BR>&gt; 
> <P>&nbsp;</P>
> <P><BR>
> <HR SIZE=1>
> <B>Do You Yahoo!?</B><BR><BR>&gt; <A
> 
>href="http://rd.yahoo.com/welcome/*http://fifaworldcup.yahoo.com/fc/en/spl";>Sign-up<BR>&gt;
> for Video Highlights</A> of 2002 FIFA World
> Cup<BR><BR><BR>-------------------------------------------------------<BR>Bringing
> you mounds of caffeinated joy<BR>&gt;&gt;&gt; http://thinkgeek.com/sf
> &lt;&lt;&lt;<BR><BR>_______________________________________________<BR>JBoss-user
> mailing 
>list<BR>[EMAIL PROTECTED]<BR>https://lists.sourceforge.net/lists/listinfo/jboss-user</BLOCKQUOTE><p><br><hr
> size=1><b>Do You Yahoo!?</b><br>
> <a 
>href="http://rd.yahoo.com/welcome/*http://fifaworldcup.yahoo.com/fc/en/spl";>Sign-up
> for Video Highlights</a> of 2002 FIFA World Cup


-------------------------------------------------------
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to