2 Replies Latest reply on Jan 16, 2008 6:24 AM by jaikiran pai

    Is this DataSource transaction safe?

    Martin Newbie

      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!