Atomikos Forum

I'm having trouble getting Transactions Essentials to work in my Spring / Hibernate / JTA environment. 

Does anyone have any idea what the problem could be?

Here is my configuration file:
    <bean id="xaDataSource" class="com.atomikos.jdbc.AtomikosDataSourceBean">
  <property name="uniqueResourceName" value="xaDataSource"/>
  <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"/>
  <property name="xaProperties">
      <props>
          <prop key="url">${jdbc.url}</prop>
        <prop key="user">${jdbc.username}</prop>
          <prop key="password">${jdbc.password}</prop>
      </props>
  </property>
  <property name="poolSize" value="20" />
  <property name="borrowConnectionTimeout" value="10000" />
  <property name="testQuery" value="select 1" />
  <property name="maintenanceInterval" value="10000" />
</bean>

    
    
    <!-- Optional: add a log administrator -->
<bean id="localLogAdministrator"
 class="com.atomikos.icatch.admin.imp.LocalLogAdministrator"/>
    
    
    <bean id="userTransactionService"
  class="com.atomikos.icatch.config.UserTransactionServiceImp"
  init-method="init" destroy-method="shutdownForce">
    <constructor-arg>
        <!-- IMPORTANT: specify all Atomikos properties here -->
        <props>
            <prop key="com.atomikos.icatch.service">
              com.atomikos.icatch.standalone.UserTransactionServiceFactory
            </prop>
        </props>
    </constructor-arg>
    <property name="initialLogAdministrators">
        <list>
            <ref bean="localLogAdministrator"/>
        </list>
    </property>
</bean>
    <!--
    Construct Atomikos UserTransactionManager,
    needed to configure Spring
-->
<bean id="atomikosTransactionManager"
      class="com.atomikos.icatch.jta.UserTransactionManager"
      init-method="init" destroy-method="close"
      depends-on="userTransactionService">
     
  <!-- 
        when close is called,
        should we force transactions to terminate or not?
  -->
  <property name="forceShutdown" value="false" />
</bean>

<!--
    Also use Atomikos UserTransactionImp,
    needed to configure Spring 
-->
<bean id="atomikosUserTransaction"
      class="com.atomikos.icatch.jta.UserTransactionImp" 
      depends-on="userTransactionService">
  <property name="transactionTimeout" value="300" />
</bean>
    

    <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager" depends-on="userTransactionService">
        <property name="transactionManager" ref="atomikosTransactionManager" />
          <property name="userTransaction" ref="atomikosUserTransaction" />
          <property name="userTransactionName" value="java:comp/UserTransaction" />
        <!-- <property name="userTransaction" ref="jotm"/> -->
        <!-- <property name="allowCustomIsolationLevels" value="true"/> -->
    </bean>     
            
    <bean id="jpaVendorAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"
            p:database="${jpa.database}" p:showSql="${jpa.showSql}" />
    
    <!-- JPA EntityManagerFactory -->
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"
            p:dataSource-ref="xaDataSource" p:jpaVendorAdapter-ref="jpaVendorAdapter" p:jpaDialect-ref="jpaDialect" >
        
        <property name="jpaPropertyMap">
            <map>
                <!-- <entry key="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" /> -->
                <entry key="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect" />
                <entry key="hibernate.hbm2ddl.auto" value="${hibernate.hbm2ddl.auto}" />
                <entry key="hibernate.format_sql" value="false" />
                <entry key="hibernate.use_sql_comments" value="true" />
                <entry key="hibernate.default_batch_fetch_size" value="25" />
                <entry key="hibernate.order_updates" value="true" />
                <!-- Cache -->
                <!-- <entry key="hibernate.cache.provider_class" value="net.sf.ehcache.hibernate.SingletonEhCacheProvider" /> -->
                <!-- <entry key="net.sf.ehcache.configurationResourceName" value="ehcache.xml" /> -->
                <entry key="hibernate.cache.use_second_level_cache" value="false" />
                <entry key="hibernate.cache.use_query_cache" value="false" />
                <!-- Transaction Management -->
                <!-- <entry key="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JOTMTransactionManagerLookup" />-->
                <!-- <entry key="hibernate.transaction.factory_class" value="com.atomikos.icatch.jta.hibernate3.AtomikosJTATransactionFactory" /> -->
                <entry key="hibernate.transaction.manager_lookup_class" value="com.atomikos.icatch.jta.hibernate3.TransactionManagerLookup" />
                <!-- <entry key="hibernate.transaction.factory_class" value="org.hibernate.transaction.JTATransactionFactory" /> -->
                <entry key="hibernate.transaction.factory_class" value="com.atomikos.icatch.jta.hibernate3.AtomikosJTATransactionFactory" />
                <entry key="jta.UserTransaction" value="java:comp/UserTransaction" />
                <!-- <entry key="hibernate.transaction.auto_close_session" value="false" />
                <entry key="hibernate.transaction.flush_before_completion" value="false" />
                <entry key="hibernate.connection.release_mode" value="auto" />   
                <entry key="hibernate.current_session_context_class" value="org.hibernate.context.JTASessionContext" /> -->
            </map>
        </property>
        
        <property name="persistenceUnitName" value="LeapforcePU" />
                        
        <property name="loadTimeWeaver">
            <bean class="org.springframework.instrument.classloading.ReflectiveLoadTimeWeaver" />
          </property>
    </bean>
    
    <bean id="sessionFactory" factory-bean="entityManagerFactory" factory-method="getSessionFactory"/>
    
    <bean id="jpaDialect" class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
    
    <bean id="jndiContext" class="org.apache.xbean.spring.jndi.SpringInitialContextFactory"
      factory-method="makeInitialContext" scope="singleton" lazy-init="false">               
  <property name="entries">
    <map>
      <entry key="jdbc/dataSource" value-ref="xaDataSource"/>
    </map>
  </property>
</bean>

I'm getting the following error:

11:34:00,125  INFO atomikos:81 - createCompositeTransaction ( 300000 ): created new ROOT transaction with id 192.168.63.1.tm0000400014
11:34:00,213  WARN AbstractEntityManagerImpl:543 - Cannot join transaction: do not override hibernate.transaction.factory_class
11:34:00,244  INFO atomikos:81 - AtomikosDataSoureBean 'xaDataSource': getConnection ( null )...
11:34:00,244  INFO atomikos:81 - AtomikosDataSoureBean 'xaDataSource': init...
11:34:00,248  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling toString...
11:34:00,248  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling toString...
Hibernate: /* SELECT u FROM User u WHERE u.needsBlacklisting = TRUE */ select user0_.id as id40_, user0_.created_by_user_id as created50_40_, user0_.date_created as date2_40_, user0_.__UUID__ as column3_40_, user0_.obj_version as obj4_40_, user0_.date_updated as date5_40_, user0_.updated_by_user_id as updated51_40_, user0_.address1 as address6_40_, user0_.address2 as address7_40_, user0_.aqm_level as aqm8_40_, user0_.birth_date as birth9_40_, user0_.blacklisted as blackli10_40_, user0_.broadband as broadband40_, user0_.business_name as business12_40_, user0_.campaign_id as campaign52_40_, user0_.city as city40_, user0_.country as country40_, user0_.education_level as education15_40_, user0_.email as email40_, user0_.ewoq_id_verified as ewoq17_40_, user0_.ewoq_numeric_id as ewoq18_40_, user0_.first_name as first19_40_, user0_.fluent as fluent40_, user0_.internet_literate as internet21_40_, user0_.application_job_id as applica53_40_, user0_.last_name as last22_40_, user0_.is_locked as is23_40_, user0_.needs_blacklisting as needs24_40_, user0_.num_hours_committed as num25_40_, user0_.owner_id as owner54_40_, user0_.`password` as password26_40_, user0_.pwd_reset_req_date as pwd27_40_, user0_.password_reset_token as password28_40_, user0_.porn_willing as porn29_40_, user0_.prefix as prefix40_, user0_.primary_phone as primary31_40_, user0_.prior_see_experience as prior32_40_, user0_.referred_by as referred33_40_, user0_.registration_referrer_url as registr34_40_, user0_.is_reinstatable as is35_40_, user0_.resume_file_name as resume36_40_, user0_.roles as roles40_, user0_.scheduled_exam_date as scheduled38_40_, user0_.secondary_phone as secondary39_40_, user0_.state as state40_, user0_.status as status40_, user0_.suffix as suffix40_, user0_.tax_classification as tax43_40_, user0_.tax_id as tax44_40_, user0_.termination_date as termina45_40_, user0_.termination_reason as termina46_40_, user0_.time_zone as time47_40_, user0_.tph_level as tph48_40_, user0_.zip as zip40_ from users user0_ where user0_.needs_blacklisting=1
11:34:00,253  INFO atomikos:81 - addParticipant ( XAResourceTransaction: 3139322E3136382E36332E312E746D30303030343030303134:3139322E3136382E36332E312E746D31 ) for transaction 192.168.63.1.tm0000400014
11:34:00,254  INFO atomikos:81 - XAResource.start ( 3139322E3136382E36332E312E746D30303030343030303134:3139322E3136382E36332E312E746D31 , XAResource.TMNOFLAGS ) on resource xaDataSource represented by XAResource instance com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@182fb6a
11:34:00,257  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling prepareStatement...
11:34:00,281  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: isClosed()...
11:34:00,282  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling getWarnings...
11:34:00,282  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling clearWarnings...
11:34:00,283  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: close()...
11:34:00,284  WARN atomikos:78 - Error closing pending statement:
java.lang.IllegalArgumentException: null source
    at java.util.EventObject.<init>(Unknown Source)
    at javax.sql.StatementEvent.<init>(Unknown Source)
    at com.mysql.jdbc.jdbc2.optional.JDBC4PreparedStatementWrapper.close(JDBC4PreparedStatementWrapper.java:70)
    at com.atomikos.jdbc.AbstractConnectionProxy.forceCloseAllPendingStatements(AbstractConnectionProxy.java:78)
    at com.atomikos.jdbc.AtomikosConnectionProxy.close(AtomikosConnectionProxy.java:188)
    at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:119)
    at $Proxy35.close(Unknown Source)
    at org.hibernate.connection.DatasourceConnectionProvider.closeConnection(DatasourceConnectionProvider.java:97)
    at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:474)
    at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:429)
    at org.hibernate.jdbc.ConnectionManager.afterStatement(ConnectionManager.java:304)
    at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:572)
    at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:291)
    at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:307)
    at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234)
    at org.hibernate.loader.Loader.doQuery(Loader.java:749)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
    at org.hibernate.loader.Loader.doList(Loader.java:2232)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
    at org.hibernate.loader.Loader.list(Loader.java:2124)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
    at com.lf.service.aqm.AQMServiceImpl.processBlacklist(AQMServiceImpl.java:379)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy59.processBlacklist(Unknown Source)
    at com.lf.service.scheduler.AQMBlacklistProcessor.executeInternal(AQMBlacklistProcessor.java:32)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:531)

11:34:00,285  INFO atomikos:81 - XAResource.end ( 3139322E3136382E36332E312E746D30303030343030303134:3139322E3136382E36332E312E746D31 , XAResource.TMSUCCESS ) on resource xaDataSource represented by XAResource instance com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@182fb6a
11:34:00,290 ERROR AQMServiceImpl:399 - Error processing blacklist:
java.lang.IllegalArgumentException: null source
    at java.util.EventObject.<init>(Unknown Source)
    at javax.sql.StatementEvent.<init>(Unknown Source)
    at com.mysql.jdbc.jdbc2.optional.JDBC4PreparedStatementWrapper.close(JDBC4PreparedStatementWrapper.java:70)
    at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:563)
    at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:291)
    at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:307)
    at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234)
    at org.hibernate.loader.Loader.doQuery(Loader.java:749)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
    at org.hibernate.loader.Loader.doList(Loader.java:2232)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
    at org.hibernate.loader.Loader.list(Loader.java:2124)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
    at com.lf.service.aqm.AQMServiceImpl.processBlacklist(AQMServiceImpl.java:379)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy59.processBlacklist(Unknown Source)
    at com.lf.service.scheduler.AQMBlacklistProcessor.executeInternal(AQMBlacklistProcessor.java:32)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:531)
11:34:00,294  INFO atomikos:81 - commit() done (by application) of transaction 192.168.63.1.tm0000400014
11:34:00,314  INFO atomikos:81 - XAResource.prepare ( 3139322E3136382E36332E312E746D30303030343030303134:3139322E3136382E36332E312E746D31 ) returning OK on resource xaDataSource represented by XAResource instance com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@182fb6a
11:34:00,330  INFO atomikos:81 - XAResource.commit ( 3139322E3136382E36332E312E746D30303030343030303134:3139322E3136382E36332E312E746D31 , false ) on resource xaDataSource represented by XAResource instance com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@182fb6a
11:34:00,337  INFO atomikos:81 - afterCompletion ( STATUS_COMMITTED ) called  on Synchronization: org.hibernate.ejb.EntityManagerImpl$1@142aa03
11:34:00,338  INFO atomikos:81 - afterCompletion ( STATUS_COMMITTED ) called  on Synchronization: org.hibernate.transaction.CacheSynchronization
11:34:01,167  INFO atomikos:81 - createCompositeTransaction ( 300000 ): created new ROOT transaction with id 192.168.63.1.tm0000500014
11:34:01,173  INFO InboundFilter:93 - INBOUND FILTER STARTED -> Request URI: /qrp/core/vendor_list, Request ID: 9eb68cd4-2cf0-4550-bfa1-fed4433ee46d, Referrer: http://localhost:8080/qrp/core/vendor/view/239061?rc=%2Fqrp%2Fcore%2Fvendor_list%3Fcriteria.page%3D1%26criteria.direction%3Ddesc%26criteria.column%3Duser.dateCreated
11:34:01,197  WARN AbstractEntityManagerImpl:543 - Cannot join transaction: do not override hibernate.transaction.factory_class
11:34:01,200  INFO atomikos:81 - AtomikosDataSoureBean 'xaDataSource': getConnection ( null )...
11:34:01,201  INFO atomikos:81 - AtomikosDataSoureBean 'xaDataSource': init...
11:34:01,265  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling toString...
11:34:01,266  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling toString...
Hibernate: /* named HQL query SysConfig.findByTheme */ select sysconfig0_.id as id50_, sysconfig0_.created_by_user_id as created7_50_, sysconfig0_.date_created as date2_50_, sysconfig0_.__UUID__ as column3_50_, sysconfig0_.obj_version as obj4_50_, sysconfig0_.date_updated as date5_50_, sysconfig0_.updated_by_user_id as updated8_50_, sysconfig0_.theme as theme50_ from sys_config sysconfig0_ where sysconfig0_.theme=? limit ?
11:34:01,267  INFO atomikos:81 - addParticipant ( XAResourceTransaction: 3139322E3136382E36332E312E746D30303030353030303134:3139322E3136382E36332E312E746D32 ) for transaction 192.168.63.1.tm0000500014
11:34:01,267  INFO atomikos:81 - XAResource.start ( 3139322E3136382E36332E312E746D30303030353030303134:3139322E3136382E36332E312E746D32 , XAResource.TMNOFLAGS ) on resource xaDataSource represented by XAResource instance com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@182fb6a
11:34:01,268  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling prepareStatement...
11:34:01,291  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: isClosed()...
11:34:01,292  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling getWarnings...
11:34:01,292  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: calling clearWarnings...
11:34:01,293  INFO atomikos:81 - atomikos connection proxy for com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@1c68b20: close()...
11:34:01,294  WARN atomikos:78 - Error closing pending statement:
java.lang.IllegalArgumentException: null source
    at java.util.EventObject.<init>(Unknown Source)
    at javax.sql.StatementEvent.<init>(Unknown Source)
    at com.mysql.jdbc.jdbc2.optional.JDBC4PreparedStatementWrapper.close(JDBC4PreparedStatementWrapper.java:70)
    at com.atomikos.jdbc.AbstractConnectionProxy.forceCloseAllPendingStatements(AbstractConnectionProxy.java:78)
    at com.atomikos.jdbc.AtomikosConnectionProxy.close(AtomikosConnectionProxy.java:188)
    at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:119)
    at $Proxy35.close(Unknown Source)
    at org.hibernate.connection.DatasourceConnectionProvider.closeConnection(DatasourceConnectionProvider.java:97)
    at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:474)
    at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:429)
    at org.hibernate.jdbc.ConnectionManager.afterStatement(ConnectionManager.java:304)
    at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:572)
    at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:291)
    at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:307)
    at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234)
    at org.hibernate.loader.Loader.doQuery(Loader.java:749)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
    at org.hibernate.loader.Loader.doList(Loader.java:2232)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
    at org.hibernate.loader.Loader.list(Loader.java:2124)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:88)
    at com.lf.service.config.SysConfigServiceImpl.getSysConfigByTheme(SysConfigServiceImpl.java:103)
    at com.lf.service.config.SysConfigServiceImpl$$FastClassByCGLIB$$594690b2.invoke(<generated>)
    at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:628)
    at com.lf.service.config.SysConfigServiceImpl$$EnhancerByCGLIB$$4864aa78.getSysConfigByTheme(<generated>)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springmodules.cache.interceptor.caching.AbstractCachingInterceptor.cachedValueFromSource(AbstractCachingInterceptor.java:123)
    at org.springmodules.cache.interceptor.caching.AbstractCachingInterceptor.invoke(AbstractCachingInterceptor.java:89)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy53.getSysConfigByTheme(Unknown Source)
    at com.lf.service.context.AppContextServiceImpl.getValidAppContextByUUIDAndType(AppContextServiceImpl.java:78)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy56.getValidAppContextByUUIDAndType(Unknown Source)
    at com.lf.web.filter.InboundFilter.doFilter(InboundFilter.java:150)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Unknown Source)

11:34:01,295  INFO atomikos:81 - XAResource.end ( 3139322E3136382E36332E312E746D30303030353030303134:3139322E3136382E36332E312E746D32 , XAResource.TMSUCCESS ) on resource xaDataSource represented by XAResource instance com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@182fb6a
11:34:01,298  INFO atomikos:81 - setRollbackOnly() called for transaction 192.168.63.1.tm0000500014
11:34:01,304  INFO EhCacheFacade:324 - Cache provider does not support cancelation of updates
11:34:01,304  INFO atomikos:81 - setRollbackOnly() called for transaction 192.168.63.1.tm0000500014
11:34:01,307  INFO atomikos:81 - XAResource.rollback ( 3139322E3136382E36332E312E746D30303030353030303134:3139322E3136382E36332E312E746D32 ) on resource xaDataSource represented by XAResource instance com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@182fb6a
11:34:01,309  INFO atomikos:81 - afterCompletion ( STATUS_ROLLEDBACK ) called  on Synchronization: org.hibernate.transaction.CacheSynchronization
11:34:01,309  INFO atomikos:81 - afterCompletion ( STATUS_ROLLEDBACK ) called  on Synchronization: org.hibernate.ejb.EntityManagerImpl$1@e04e24
11:34:01,310  INFO atomikos:81 - rollback() done of transaction 192.168.63.1.tm0000500014
Aug 20, 2009 11:34:01 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet StripesDispatcher threw exception
org.springframework.dao.InvalidDataAccessApiUsageException: null source; nested exception is java.lang.IllegalArgumentException: null source
    at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:271)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:97)
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:352)
    at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:62)
    at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:212)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:146)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springmodules.cache.interceptor.caching.AbstractCachingInterceptor.cachedValueFromSource(AbstractCachingInterceptor.java:123)
    at org.springmodules.cache.interceptor.caching.AbstractCachingInterceptor.invoke(AbstractCachingInterceptor.java:89)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy53.getSysConfigByTheme(Unknown Source)
    at com.lf.service.context.AppContextServiceImpl.getValidAppContextByUUIDAndType(AppContextServiceImpl.java:78)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)

Hi,

This looks like a bug in the MySQL driver.

What MySQL versions (DB and driver) are you using?

Guy

Thanks for the reply.  I am using mysql connector 5.1.6.

The class is:  com.mysql.jdbc.jdbc2.optional.MysqlXADataSource

FYI, it was indeed the Driver.  I upgraded to MySQL Connector 5.1.8 and the problem went away.  Thanks!