2 Replies Latest reply on Jan 20, 2004 5:43 AM by Daniel Murygin

    Question on J8055 : Setting transaction isolation for JBoss

    trusha Newbie

       

      "trusha" wrote:
      Hi!
      I have no idea, how can I set a transaction isolation for my Entity Beans with CMP2.0 using JBoss 3.0 and MySQL-DB. Probably, it should be done in Deployment Descriptor, but I didn't find any information, how to do this in ejb-jar.xml. Would u be so kind to tell me, how did u set it for your application?

      Thanx in advance,
      Trusha


        • 1. Re: Question on J8055 : Setting transaction isolation for JB
          Juha Lindfors Master

           

          "juha@jboss.org" wrote:
          I'm not sure if it is possible for 3.0, in 3.2 you can configure the isolation level in your datasource configuration file (see generic-ds.xml for an example).

          -- Juha


          • 2. Re: Question on J8055 : Setting transaction isolation for JB
            Daniel Murygin Newbie

             

            "n2" wrote:
            you can set the transaction isolation level in the datasource configuration file name-ds.xml in the deploy directory for jboss 3.x.x.
            this is an example for ms sqlserver:

            <datasources>
            <local-tx-datasource>
            <jndi-name>matrix</jndi-name>
            <connection-url>jdbc:microsoft:sqlserver://<ip>:1433;databaseName=<db-name>;SelectMethod=cursor</connection-url>
            <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
            <user-name>xxx</user-name>
            < password>xxx< /password>
            <transaction-isolation>TRANSACTION_READ_UNCOMMITTED</transaction-isolation>
            </local-tx-datasource>
            </datasources>
            


            possible values are: TRANSACTION_SERIALIZABLE, TRANSACTION_REPEATABLE_READ, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED