0 Replies Latest reply on Jan 15, 2003 7:47 AM by nurb

    Mysql Xa Problem: Init DB on every query

    nurb Newbie

      Hi, i setup mysql as XADataSource but it did not work as i expect. i'm using jboss 3.0.4 whith mysql-connector-java-2.0.14-bin.jar and the configuration below. the problem is, that jboss initialize the db on each new query:

      413 Connect jboss@cobra.bla.de on
      413 Init DB jbossdb
      413 Query SHOW VARIABLES
      413 Query SET autocommit=0
      413 Query SELECT .....

      so, if i got more recordsets in my table then mysql connections are alowed (50) - i get the following error:

      13:43:52,829 WARN [TxCapsule] XAException: tx=XidImpl [FormatId=257, GlobalId=cobra//295, BranchQual=] errorCode=XAER_NOTA
      javax.transaction.xa.XAException

      here is my mysql-service.xml configuration:

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

      <!-- ===================================================================== -->
      <!-- -->
      <!-- JBoss Server Configuration -->
      <!-- -->
      <!-- ===================================================================== -->



      <!-- ==================================================================== -->
      <!-- New ConnectionManager setup for mysql using 2.0.11 driver -->
      <!-- Build jmx-api (build/build.sh all) and view for config documentation -->
      <!-- ==================================================================== -->


      <!-- -->


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



      <!-- -->

      MySqlDS



      <config-property name="XADataSourceProperties" type="java.lang.String">URL=jdbc:mysql://192.168.1.10:3306/jbossdb</config-property>
      <config-property name="XADataSourceClass" type="java.lang.String">com.mysql.jdbc.jdbc2.optional.MysqlXaDataSource</config-property>
      <!-- Non XA config properties
      <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://192.168.1.10:3306/jbossdb</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">bla</config-property>
      <config-property name="Password" type="java.lang.String">fasel</config-property>








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




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

      <!-- -->

      0
      50
      500
      1
      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






      do you have any ideas?
      thanks in forward!!

      nurb