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