4 Replies Latest reply on Apr 16, 2007 10:27 AM by craig2007

    Jboss Messaging - Warning Message on Transaction isolation d

      Hi Everybody

      I am using JBoss4.0.4.GA and JBoss Messaging (jboss-messaging-1.0.1.GA) and MySql (mysql-5.0.22-win32) .I did all the modification that needs to be there for proper working JBoss Messaging Server with Jboss AS.

      When i start my application server with the option
      run -c messaging

      I get the following warning ...Just warning only

      JBoss Messaging Warning: DataSource connection transaction isolation should be READ_COMMITTED, but it is currently REPEATABLE_READ.
      Using an isolation level less strict than READ_COMMITTED may lead to data consistency problems.
      Using an isolation level more strict than READ_COMMITTED may lead to deadlock.


      Can anybody tell me in which config file, i should do the modification to make the transaction isolation to be "READ_COMMITED"

      I would appreciate if you could able to provide me a way to change this configuration.

        • 1. Re: Jboss Messaging - Warning Message on Transaction isolati
          timfox

          This is normally set on your datasource configuration.

          You should ask in the JCA user forum for more details.

          • 2. Re: Jboss Messaging - Warning Message on Transaction isolati

            Thanks for the reply.

            I just followed the steps given in JBoss Messaging document and also changed the database to be MySQL as given in the JBoss Message document.

            Your reply note says that only at database side these isolation level need to be changed and not at JBoss messaging deployment side(JBOSS_HOME/server/messaging). I used to change the configuration of which database to be used only at JBoss Messaging side(like whether i should use MySQL or Oracle etc).

            I thought we could change the isolation level with some configuration file at the JBoss Messaging deployment side(JBOSS_HOME/server/messaging) rather at database side.

            Kindly advice me

            • 3. Re: Jboss Messaging - Warning Message on Transaction isolati
              timfox

               

              "Craig2007" wrote:

              Your reply note says that only at database side these isolation level need to be changed and not at JBoss messaging deployment side(JBOSS_HOME/server/messaging).



              No, I didn't say that.

              If you look in your mysql-persistence-service.xml (or clustered-mysql-persistence-service.xml) file, you will see it references a particular datasource

              <depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
              


              This is the datasource JBoss Messaging will use. By default it's value is DefaultDS. You can change it to use any DataSource you want.

              In JBoss AS, datasources are typically deployed in the server/<server-name//deploy directory with names like mysql-ds.xml. This is the data source configuration file.

              This link will show you how to configure the datasource including how to set the transaction isolation.

              http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources








              • 4. Re: Jboss Messaging - Warning Message on Transaction isolati

                Thanks Very much for the valuable information.
                I could able to change my datasource isolation level to required one for MySQL