Is this DataSource transaction safe?

[smithmb]

Hi folks -- would this datasource obviously fail to do transactions?:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>MySqlDS</jndi-name>
 <connection-url>jdbc:mysql://127.0.0.1:3306/scheduler_db</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>censored</user-name>
 <password>censored</password>
 <metadata>
 <type-mapping>mySQL</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>

I can't get simple transactions involving multiple connections to it to fail -- the statements are autocommited, even with the autocommit off and the container (Jboss 4.0.5) saying it worked!

[vickyk]

"smithmb" wrote:

I can't get simple transactions involving multiple connections to it to fail -- the statements are autocommited, even with the autocommit off and the container (Jboss 4.0.5) saying it worked!

I am not able to understand your question properly , you need to state your query properly .
Explian the problem with the code reference Or error log details .

[jaikiran]

Looks like this question is being asked in context of the other thread at http://www.jboss.com/index.html?module=bb&op=viewtopic&t=127419