JPA Change default Flushmode from AUTO to COMMIT

jpa

Solution

Try this

<property name="org.hibernate.flushMode" value="COMMIT"/>

Testing this on a standalone program I can see the changed value of underlying Hibernate Session / EntityManager from `AUTO` to `COMMIT`

Here is my 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_2_0.xsd"
    version="2.0">
  <persistence-unit name="JPATest" transaction-type="RESOURCE_LOCAL">
  <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>  

  <class>com.test.TestEntity</class>  
  <shared-cache-mode>ENABLE_SELECTIVE</shared-cache-mode> 
  <properties> 
      <property name="hibernate.hbm2ddl.auto" value="update"/>
      <property name="hibernate.show_sql" value="true"/>
      <property name="hibernate.format_sql" value="true"/>
      <property name="hibernate.use_sql_comments" value="true"/>
      <property name="hibernate.cache.use_query_cache" value="true"/>
      <property name="hibernate.archive.autodetection" value="class, hbm"/>     
       <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
      <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
      <property name="hibernate.connection.username" value="xxx"/>
      <property name="hibernate.connection.password" value="xxx"/>
      <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/test?createDatabaseIfNotExist=true"/>      
       <property name="hibernate.cache.region.factory_class" value="org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory"/>
       <property name="hibernate.cache.provider_configuration" value="classpath:ehcache.xml"></property>
      <property name="hibernate.use.second.level.cache" value="true"/>
      <property name="hibernate.cache.region_prefix" value="neutrino.jpa.cache"/>
      <property name="hibernate.cache.use_query_cache" value="false"/>
      <property name="hibernate.generate_statistics" value="true"/>
      <property name="hibernate.jdbc.batch_size" value="10"/>
      <property name="hibernate.order_updates" value="true"/>
      <property name="hibernate.order_inserts" value="true"/>
    <property name="org.hibernate.flushMode" value="COMMIT"/>    
  </persistence-unit>
</persistence>

And here is how I test it

 EntityManagerFactory emf  = Persistence.createEntityManagerFactory("JPATest");
 EntityManager em = emf.createEntityManager();
 Session session = em.unwrap(Session.class);
 System.out.println("Underlying Hibernate session flushmode #######         "+session.getFlushMode());
 System.out.println("EntityManager flushmode                #######         "+em.getFlushMode());

This gives me

Underlying Hibernate session flushmode #######         COMMIT
EntityManager flushmode                #######         COMMIT

If I omit the property in presistence.xml, I get this

Underlying Hibernate session flushmode #######         AUTO
EntityManager flushmode                #######         AUTO

Problem

I've tried several ways to change the FlushMode to the complete application. Is this right or is there another way to do it? I don't want to do this pragmmatically. This is was what i find as property but it isn't work. ``` <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_2_0.xsd" version="2.0"> <persistence-unit name="myPU"> <properties> ... <property name="hibernate.connection.autocommit" value="false"/> <!-- Also tried this: --> <property name="org.hibernate.FlushMode" value="commit"/> ... </properties> </persistence-unit> </persistence> ``` Update: I've created the class as described in the link by zxcf, but i can't figure out how to add this construct in my persistence.xml. ``` <property name="jpaDialect"> <bean class="test.jpa.vendor.HibernateJpaDialect"> <property name="flushMode" value="MANUAL"/> </bean> </property> ```

Original source