2 Replies Latest reply on May 13, 2005 10:12 AM by Dimitris Andreadis

    JBoss 3.2.4 Mysql autocommit Problem

    Martin Reiland Newbie

      Hi,

      i have a problem to set my mysql datasource connections to autocommit=false.

      Following situation:

      i moved my Application from JBoss 3.2.6 to JBoss 3.2.4
      At Jboss 3.2.6 i configured my datasource in mysq-ds.xml. I had no problems.
      Jboss 3.2.4 wasn't able to deploy this file, so i configured a mysql-service.xml the following way:


      <?xml version="1.0" encoding="UTF-8"?>


      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->

      mysqlds


      <config-property name="ConnectionURL" type="java.lang.String"> jdbc:mysql://localhost:3306/db</config-property>
      <config-property name="DriverClass" type="java.lang.String">com.mysql.jdbc.Driver</config-property>
      <!--set these only if you want only default logins, not through JAAS -->
      <config-property name="UserName" type="java.lang.String"/>
      <config-property name="Password" type="java.lang.String"/>


      <!--Below here are advanced properties -->
      <!--hack-->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


      <depends optional-attribute-name="ManagedConnectionPool">
      <!--embedded mbean-->

      0
      50
      5000
      15
      ByContainer


      <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
      <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
      java:/TransactionManager
      <!--make the rar deploy! hack till better deployment-->
      jboss.jca:service=RARDeployer


      <?xml version="1.0" encoding="UTF-8"?>

      When I use the connection in my applictation I get an Exception when executing a commit because autocommit is true.

      i have no idea how to change this property in the mysql-service.xml

      Any Ideas?

      Thanks in advance
      Martl

        • 1. Re: JBoss 3.2.4 Mysql autocommit Problem
          Martin Reiland Newbie

          name="jboss.jca:service=LocalTxCM,name=mysqlds"> <depends optional-attribute-name="ManagedConnectionFactoryName">


          mysqlds


          <config-property name="ConnectionURL" type="java.lang.String"> jdbc:mysql://localhost:3306/db</config-property>
          <config-property name="DriverClass" type="java.lang.String">com.mysql.jdbc.Driver</config-property>

          <config-property name="UserName" type="java.lang.String"/>
          <config-property name="Password" type="java.lang.String"/>


          <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


          <depends optional-attribute-name="ManagedConnectionPool">

          0
          50
          5000
          15
          ByContainer


          <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
          <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
          java:/TransactionManager
          jboss.jca:service=RARDeployer


          • 2. Re: JBoss 3.2.4 Mysql autocommit Problem
            Dimitris Andreadis Master

            It seems you are in the wrong forum.