[jboss-user] [JBoss Seam] - Commiting after each statement (mysql)

[pettersonfp]

Hi,

I noticed that my app is commiting after each statement.

Eg:


  | tx.begin();
  | //some persistent modification
  | tx.rollback();
  | tx.commit();
  | 

The rollback does nothing.


  | <Context 
  | 	debug="5"
  |   reloadable="true" crossContext="false">
  |   <Resource
  |     name="jdbc/myDB" 
  |     auth="Container"
  |     type="javax.sql.DataSource" 
  |     driverClassName="com.mysql.jdbc.Driver"
  | 		defaulAutoCommit="false"
  |     factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" 
  |     url="jdbc:mysql://localhos:3306/mydb?autoReconnect=true&autoCommit=false"
  |     validationQuery="select current_date" 
  |     removeAbandoned="true" 
  |     removeAbandonedTimeout="30"
  |     useNaming="true" 
  |     logAbandoned="true"    
  |     maxActive="5" 
  |     maxIdle="5"
  |     maxWait="15000" 
  |     username="xxxxxx"
  |     password="xxxxx"/>
  | </Context>
  | 

persistence.xml

  | <?xml version="1.0" encoding="UTF-8"?>
  | <persistence xmlns="http://java.sun.com/xml/ns/persistence" 
  |              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  |              xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" 
  |              version="1.0">
  |    <persistence-unit name="myDatabase" transaction-type="RESOURCE_LOCAL">
  |       <provider>org.hibernate.ejb.HibernatePersistence</provider>
  |       <jta-data-source>java:comp/env/jdbc/myDB</jta-data-source>
  |       <properties>
  |           
  |          <property name="hibernate.hbm2ddl.auto" value="update"/>  
  |          <property name="hibernate.show_sql" value="true"/>
  |          <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
  |          <property name="hibernate.connection.autocommit" value="false"/>
  | <!--          <property name="hibernate.datasource" value="java:comp/env/jdbc/myDB"/> -->
  |          <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider"/>
  |         <property name="transaction.flush_before_completion" value="true"/>
  |         <property name="transaction.factory_class" value="org.hibernate.transaction.JDBCTransactionFactory"/>
  |          <!-- RESOURCE_LOCAL
  |          <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
  |          -->
  |          <!-- alternative
  |          <property name="jboss.entity.manager.factory.jndi.name" 
  |               value="java:/coollectBookingEntityManagerFactory"/>
  |          -->
  |       </properties>
  |    </persistence-unit>
  | </persistence>
  | 

Any ideas?

Thanks,

Petterson

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

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