[jboss-user] [EJB 3.0] - Re: Transactions broken? Trivial Hibernate example with EJB3

[jaikiran]

Based on your post in the JCA forum, i guess the auto-commit is true for your MySQL datasource. Try adding relaxAutoCommit=true in the connection URL of your datasource and see if it works. Here's how you can pass this parameter through the connection URL:



  | <?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?relaxAutoCommit=true</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>

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4120395#4120395

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4120395