Why aren't my transactions getting commited?

Question

When I set defaultAutoCommit to false my transactions don't get saved to the database. Does anybody know why my data isn't getting saved to the database?

I am using @transactional on my methods it appears that the transactions are being committed because the status is 3

Transaction status https://docs.jboss.org/jbossas/javadoc/4.0.2/javax/transaction/Status.java.html

This is the transaction log

2014-12-10 14:39:07,132 TRACE [http-apr-8080-exec-2] CacheSynchronization - transaction before completion callback

2014-12-10 14:39:07,132 TRACE [http-apr-8080-exec-2] CacheSynchronization - transaction after completion callback, status: 3

<aop:aspectj-autoproxy/>
<context:annotation-config/>

<!-- ******************************************************************** -->
<!-- Scan for dao layer annotated beans -->
<!-- ******************************************************************** -->
<context:component-scan base-package="package.dao" scoped-proxy="interfaces"/>

<!-- ******************************************************************** -->
<!-- Mark bean transactions as annotation driven -->
<!-- ******************************************************************** -->
<tx:annotation-driven transaction-manager="transactionManager"/>

<!-- ******************************************************************** -->
<!-- PropertyConfigurer for the DAO -->
<!-- ******************************************************************** -->
<context:property-placeholder location="classpath:prop-dao.properties"/>        

<!-- ******************************************************************** -->
<!-- Setup the transaction manager -->
<!-- ******************************************************************** -->
    <!-- Using Atomikos Transaction Manager -->
    <bean class="com.atomikos.icatch.jta.UserTransactionManager" destroy-method="close" id="atomikosTransactionManager" init-method="init">
        <property name="forceShutdown" value="true"/>
        <property name="startupTransactionService" value="true"/>
        <property name="transactionTimeout" value="600000"/>
    </bean>

    <bean class="com.atomikos.icatch.jta.UserTransactionImp" id="atomikosUserTransaction"/>

    <!-- Configure the Spring framework to use JTA transactions from Atomikos -->
    <bean class="org.springframework.transaction.jta.JtaTransactionManager" id="transactionManager">
        <property name="transactionManager" ref="atomikosTransactionManager"/>
        <property name="userTransaction" ref="atomikosUserTransaction"/>
        <property name="transactionSynchronizationName" value="SYNCHRONIZATION_ON_ACTUAL_TRANSACTION"/>
    </bean>

<!-- ******************************************************************** -->
<!-- Setup a data source -->
<!-- ******************************************************************** -->




            <!-- Using Apache DBCP Data Sources -->
            <bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" name="propDS">
                <property name="driverClassName" value="${prop.connection.driver_class}"/>
                <property name="username" value="${prop.connection.username}"/>
                <property name="password" value="${prop.connection.password}"/>
                <property name="url" value="${prop.connection.url}"/>
                <property name="maxIdle" value="${prop.minPoolSize}"/>
                <property name="maxActive" value="${prop.maxPoolSize}"/>
                <property name="defaultAutoCommit" value="false"/>
            </bean>



<!-- ******************************************************************** -->
<!-- Setup each persistence unit -->
<!-- ******************************************************************** -->



            <!-- Configure a JPA vendor adapter -->
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" id="propJPAVendorAdapter">
                <property name="showSql" value="${prop.show_sql}"/>
                <property name="generateDdl" value="${prop.generateDdl}"/>
                <property name="databasePlatform" value="${prop.dialect}"/>
            </bean>
            <!-- EntityManager Factory that brings together the persistence unit, datasource, and JPA Vendor -->
            <bean class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" id="prop">
                <property name="dataSource" ref="propDS"/>
                <property name="persistenceUnitName" value="prop"/>
                <property name="jpaVendorAdapter" ref="propJPAVendorAdapter"/>
                    <property name="jpaPropertyMap">
                        <map>
                                    <entry key="hibernate.transaction.manager_lookup_class" value="com.atomikos.icatch.jta.hibernate3.TransactionManagerLookup"/>
                                    <entry key="hibernate.connection.release_mode" value="on_close"/>
                        </map>
                    </property>
            </bean>

EDIT: I tried committing manually at the end of my method but the data still wasn't saved

Answer 1

When I set defaultAutoCommit to false my transactions don't get saved to the database

This is the purpose of setting defaultAutoCommit to false. Set it to true and it would be auto-commited. Set it to false and you need to manually commit it, or it will be rollbacked.