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