Atomikos Forum

WARN atomikos:78 - Error closing pending statement: null source

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)
Caine Send private email
Thursday, August 20, 2009
 
 
Hi,

This looks like a bug in the MySQL driver.

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

Guy
Guy Pardon Send private email
Friday, August 28, 2009
 
 
Thanks for the reply.  I am using mysql connector 5.1.6.

The class is:  com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
Caine Send private email
Friday, September 04, 2009
 
 
FYI, it was indeed the Driver.  I upgraded to MySQL Connector 5.1.8 and the problem went away.  Thanks!
Caine Send private email
Friday, September 04, 2009
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics