JTA多数据源

最新推荐文章于 2021-04-11 17:09:11 发布
最新推荐文章于 2021-04-11 17:09:11 发布
阅读量180 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_33669968/article/details/88890213
版权

示例模型概述

  • crontroller层发消息到队列
  • service层监听到队列消息后，将数据分别保存的DB和MQ
  • controller层作为调用者，提供了对service层里2种数据源的事务控制，这种能力由atomikos提供；

示例程序依赖

  • atomikos提供JTA事务管理能力
  • 数据源1为DB，故引入spring-boot-starter-data-jpa
  • 数据源2为MQ，故引入spring-boot-starter-activemq
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-activemq</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jta-atomikos</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <scope>runtime</scope>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
</dependency>

web层

  • web层方法加了@Transactional注解，该注解的能力由atomikos提供，可对service层的2个数据源提供事务保障；
  • 经测试，如果去掉了atomikos的依赖和@Transactional的注解，service层发生错误后，不会对之前对DB数据源已插入数据的回滚，即不再拥有JTA事务能力；
@Transactional
@PostMapping("/message/annotation")
public void createInAnnotationByListener(@RequestParam String name) {
    LOG.info("CustomerResource create in annotation create customer:{}", name);
    jmsTemplate.convertAndSend("customer:msg1:new", name);
}

service层

  • create方法中，在数据已经写入DB后，发生错误，DB数据源中已经写入的数据会被回滚
@JmsListener(destination = "customer:msg1:new")
public void create(String name) {
    LOG.info("CustomerService In Annotation by listener create customer:{}", name);
    Customer customer = new Customer();
    customer.setUsername("Annotation:" + name);
    customer.setPassword("111111");
    customer.setRole("role1");

    customerRepository.save(customer);

    System.out.println(10/0);

    jmsTemplate.convertAndSend("customer:msg:reply", customer.getUsername());
}

触发失败操作后的服务端日志

2018-06-29 15:26:54.309 DEBUG 2704 --- [//localhost#1-1] o.a.activemq.transaction.XATransaction   : XA Transaction new/begin : XID:[1096044365,globalId=3137322e32362e3132382e3230392e746d30303032313030303234,branchId=3137322e32362e3132382e3230392e746d3233]
2018-06-29 15:26:54.309  INFO 2704 --- [enerContainer-1] c.a.jms.AtomikosJmsXaSessionProxy        : atomikos xa session proxy for resource jmsConnectionFactory: calling toString on JMS driver session...
2018-06-29 15:26:54.309 DEBUG 2704 --- [enerContainer-1] o.s.j.l.DefaultMessageListenerContainer  : Received message of type [class org.apache.activemq.command.ActiveMQTextMessage] from consumer [atomikos MessageConsumer proxy for ActiveMQMessageConsumer { value=ID:LiXinlei-RSC-58618-1530257195477-4:1:40:1, started=true }] of transactional session [ActiveMQSession {id=ID:LiXinlei-RSC-58618-1530257195477-4:1:40,started=true} java.lang.Object@141bb38c]
2018-06-29 15:26:54.309 DEBUG 2704 --- [enerContainer-1] .s.j.l.a.MessagingMessageListenerAdapter : Processing [org.springframework.jms.listener.adapter.AbstractAdaptableMessageListener$MessagingMessageConverterAdapter$LazyResolutionMessage@2c775788]
2018-06-29 15:26:54.309  INFO 2704 --- [enerContainer-1] c.e.s.s.CustomerServiceTxInAnnotation    : CustomerService In Annotation by listener create customer:c1
2018-06-29 15:26:54.309 DEBUG 2704 --- [enerContainer-1] o.s.t.jta.JtaTransactionManager          : Participating in existing transaction
2018-06-29 15:26:54.309 DEBUG 2704 --- [enerContainer-1] o.s.orm.jpa.EntityManagerFactoryUtils    : Opening JPA EntityManager
2018-06-29 15:26:54.310  INFO 2704 --- [enerContainer-1] c.a.icatch.imp.CompositeTransactionImp   : registerSynchronization ( com.atomikos.icatch.jta.Sync2Sync@27a23612 ) for transaction 172.26.128.209.tm0002100024
2018-06-29 15:26:54.310 DEBUG 2704 --- [enerContainer-1] o.s.orm.jpa.EntityManagerFactoryUtils    : Registering transaction synchronization for JPA EntityManager
2018-06-29 15:26:54.311 DEBUG 2704 --- [enerContainer-1] org.hibernate.SQL                        : insert into customer (id, password, role, user_name) values (null, ?, ?, ?)
2018-06-29 15:26:54.311  INFO 2704 --- [enerContainer-1] c.atomikos.jdbc.AbstractDataSourceBean   : AtomikosDataSoureBean 'dataSource': getConnection ( null )...
2018-06-29 15:26:54.311  INFO 2704 --- [enerContainer-1] c.atomikos.jdbc.AbstractDataSourceBean   : AtomikosDataSoureBean 'dataSource': init...
2018-06-29 15:26:54.312  INFO 2704 --- [enerContainer-1] c.a.icatch.imp.CompositeTransactionImp   : addParticipant ( XAResourceTransaction: 3137322E32362E3132382E3230392E746D30303032313030303234:3137322E32362E3132382E3230392E746D3234 ) for transaction 172.26.128.209.tm0002100024
2018-06-29 15:26:54.312  INFO 2704 --- [enerContainer-1] c.a.datasource.xa.XAResourceTransaction  : XAResource.start ( 3137322E32362E3132382E3230392E746D30303032313030303234:3137322E32362E3132382E3230392E746D3234 , XAResource.TMNOFLAGS ) on resource dataSource represented by XAResource instance xads0: conn0: url=jdbc:h2:mem:testdb user=SA
2018-06-29 15:26:54.312  INFO 2704 --- [enerContainer-1] c.a.icatch.imp.CompositeTransactionImp   : registerSynchronization ( com.atomikos.jdbc.AtomikosConnectionProxy$JdbcRequeueSynchronization@488d750e ) for transaction 172.26.128.209.tm0002100024
2018-06-29 15:26:54.312  INFO 2704 --- [enerContainer-1] c.atomikos.jdbc.AtomikosConnectionProxy  : atomikos connection proxy for conn1: url=jdbc:h2:mem:testdb user=SA: calling prepareStatement(insert into customer (id, password, role, user_name) values (null, ?, ?, ?),1)...
2018-06-29 15:26:54.313  WARN 2704 --- [enerContainer-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 23505, SQLState: 23505
2018-06-29 15:26:54.313 ERROR 2704 --- [enerContainer-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : Unique index or primary key violation: "UK_QFRM64Q1G4DO60INI1WV5CRNO_INDEX_5 ON PUBLIC.CUSTOMER(USER_NAME) VALUES ('Annotation:c1', 1)"; SQL statement:
insert into customer (id, password, role, user_name) values (null, ?, ?, ?) [23505-196]
2018-06-29 15:26:54.313  INFO 2704 --- [enerContainer-1] c.atomikos.jdbc.AtomikosConnectionProxy  : atomikos connection proxy for conn1: url=jdbc:h2:mem:testdb user=SA: isClosed()...
2018-06-29 15:26:54.313  INFO 2704 --- [enerContainer-1] c.atomikos.jdbc.AtomikosConnectionProxy  : atomikos connection proxy for conn1: url=jdbc:h2:mem:testdb user=SA: calling getWarnings...
2018-06-29 15:26:54.313  INFO 2704 --- [enerContainer-1] c.atomikos.jdbc.AtomikosConnectionProxy  : atomikos connection proxy for conn1: url=jdbc:h2:mem:testdb user=SA: calling clearWarnings...
2018-06-29 15:26:54.313  INFO 2704 --- [enerContainer-1] c.atomikos.jdbc.AtomikosConnectionProxy  : atomikos connection proxy for conn1: url=jdbc:h2:mem:testdb user=SA: close()...
2018-06-29 15:26:54.313  INFO 2704 --- [enerContainer-1] c.a.datasource.xa.XAResourceTransaction  : XAResource.end ( 3137322E32362E3132382E3230392E746D30303032313030303234:3137322E32362E3132382E3230392E746D3234 , XAResource.TMSUCCESS ) on resource dataSource represented by XAResource instance xads0: conn0: url=jdbc:h2:mem:testdb user=SA
2018-06-29 15:26:54.313 DEBUG 2704 --- [enerContainer-1] o.h.jpa.spi.AbstractEntityManagerImpl    : Mark transaction for rollback
2018-06-29 15:26:54.314  INFO 2704 --- [enerContainer-1] c.a.icatch.imp.CompositeTransactionImp   : setRollbackOnly() called for transaction 172.26.128.209.tm0002100024
2018-06-29 15:26:54.314 DEBUG 2704 --- [enerContainer-1] o.s.t.jta.JtaTransactionManager          : Participating transaction failed - marking existing transaction as rollback-only
2018-06-29 15:26:54.314 DEBUG 2704 --- [enerContainer-1] o.s.t.jta.JtaTransactionManager          : Setting JTA transaction rollback-only
2018-06-29 15:26:54.314  INFO 2704 --- [enerContainer-1] c.a.icatch.imp.CompositeTransactionImp   : setRollbackOnly() called for transaction 172.26.128.209.tm0002100024
2018-06-29 15:26:54.314  INFO 2704 --- [enerContainer-1] c.a.jms.AtomikosJmsXaSessionProxy        : atomikos xa session proxy for resource jmsConnectionFactory: calling getTransacted on JMS driver session...
2018-06-29 15:26:54.314 DEBUG 2704 --- [enerContainer-1] o.s.j.l.DefaultMessageListenerContainer  : Rolling back transaction because of listener exception thrown: org.springframework.jms.listener.adapter.ListenerExecutionFailedException: Listener method 'public void com.example.springtransjta.service.CustomerServiceTxInAnnotation.create(java.lang.String)' threw exception; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint ["UK_QFRM64Q1G4DO60INI1WV5CRNO_INDEX_5 ON PUBLIC.CUSTOMER(USER_NAME) VALUES ('Annotation:c1', 1)"; SQL statement:
insert into customer (id, password, role, user_name) values (null, ?, ?, ?) [23505-196]]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
2018-06-29 15:26:54.315  WARN 2704 --- [enerContainer-1] o.s.j.l.DefaultMessageListenerContainer  : Execution of JMS message listener failed, and no ErrorHandler has been set.

org.springframework.jms.listener.adapter.ListenerExecutionFailedException: Listener method 'public void com.example.springtransjta.service.CustomerServiceTxInAnnotation.create(java.lang.String)' threw exception; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint ["UK_QFRM64Q1G4DO60INI1WV5CRNO_INDEX_5 ON PUBLIC.CUSTOMER(USER_NAME) VALUES ('Annotation:c1', 1)"; SQL statement:
insert into customer (id, password, role, user_name) values (null, ?, ?, ?) [23505-196]]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
    at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.invokeHandler(MessagingMessageListenerAdapter.java:112)
    at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.onMessage(MessagingMessageListenerAdapter.java:69)
    at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:719)
    at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:679)
    at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:649)
    at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:317)
    at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:235)
    at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1166)
    at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1158)
    at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:1055)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint ["UK_QFRM64Q1G4DO60INI1WV5CRNO_INDEX_5 ON PUBLIC.CUSTOMER(USER_NAME) VALUES ('Annotation:c1', 1)"; SQL statement:
insert into customer (id, password, role, user_name) values (null, ?, ?, ?) [23505-196]]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:278)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244)
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488)
    at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
    at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
    at com.sun.proxy.$Proxy82.save(Unknown Source)
    at com.example.springtransjta.service.CustomerServiceTxInAnnotation.create(CustomerServiceTxInAnnotation.java:47)
    at com.example.springtransjta.service.CustomerServiceTxInAnnotation$$FastClassBySpringCGLIB$$252ffeb5.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:669)
    at com.example.springtransjta.service.CustomerServiceTxInAnnotation$$EnhancerBySpringCGLIB$$99ad779a.create(<generated>)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:180)
    at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:112)
    at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.invokeHandler(MessagingMessageListenerAdapter.java:104)
    ... 10 common frames omitted
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
    at org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:57)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:42)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2855)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3426)
    at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
    at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:619)
    at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:273)
    at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:254)
    at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:299)
    at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:317)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:272)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:178)
    at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:109)
    at org.hibernate.jpa.event.internal.core.JpaPersistEventListener.saveWithGeneratedId(JpaPersistEventListener.java:67)
    at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:189)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:132)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:58)
    at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:775)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:748)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:753)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1146)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:347)
    at com.sun.proxy.$Proxy80.persist(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:298)
    at com.sun.proxy.$Proxy80.persist(Unknown Source)
    at org.springframework.data.jpa.repository.support.SimpleJpaRepository.save(SimpleJpaRepository.java:508)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:504)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:489)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:56)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
    ... 31 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "UK_QFRM64Q1G4DO60INI1WV5CRNO_INDEX_5 ON PUBLIC.CUSTOMER(USER_NAME) VALUES ('Annotation:c1', 1)"; SQL statement:
insert into customer (id, password, role, user_name) values (null, ?, ?, ?) [23505-196]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:179)
    at org.h2.message.DbException.get(DbException.java:155)
    at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:103)
    at org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:231)
    at org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:190)
    at org.h2.mvstore.db.MVTable.addRow(MVTable.java:705)
    at org.h2.command.dml.Insert.insertRows(Insert.java:156)
    at org.h2.command.dml.Insert.update(Insert.java:114)
    at org.h2.command.CommandContainer.update(CommandContainer.java:101)
    at org.h2.command.Command.executeUpdate(Command.java:260)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:164)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:150)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
    ... 80 common frames omitted

2018-06-29 15:26:54.317  INFO 2704 --- [enerContainer-1] c.a.jms.AtomikosJmsMessageConsumerProxy  : atomikos MessageConsumer proxy for ActiveMQMessageConsumer { value=ID:LiXinlei-RSC-58618-1530257195477-4:1:40:1, started=true }: close...
2018-06-29 15:26:54.317 DEBUG 2704 --- [enerContainer-1] o.s.t.jta.JtaTransactionManager          : Transactional code has requested rollback
2018-06-29 15:26:54.317 DEBUG 2704 --- [enerContainer-1] o.s.orm.jpa.EntityManagerFactoryUtils    : Closing JPA EntityManager
2018-06-29 15:26:54.318  INFO 2704 --- [enerContainer-1] c.a.datasource.xa.XAResourceTransaction  : XAResource.end ( 3137322E32362E3132382E3230392E746D30303032313030303234:3137322E32362E3132382E3230392E746D3233 , XAResource.TMSUCCESS ) on resource jmsConnectionFactory represented by XAResource instance TransactionContext{transactionId=XID:[1096044365,globalId=3137322e32362e3132382e3230392e746d30303032313030303234,branchId=3137322e32362e3132382e3230392e746d3233],connection=ActiveMQConnection {id=ID:LiXinlei-RSC-58618-1530257195477-4:1,clientId=ID:LiXinlei-RSC-58618-1530257195477-3:2,started=true}}
2018-06-29 15:26:54.318 DEBUG 2704 --- [enerContainer-1] org.apache.activemq.TransactionContext   : End: 172.26.128.209.tm0002100024172.26.128.209.tm23, flags: TMSUCCESS
2018-06-29 15:26:54.318 DEBUG 2704 --- [calhost] Task-1] org.apache.activemq.broker.region.Queue  : queue://customer:msg1:new, subscriptions=1, memory=0%, size=1, pending=0 toPageIn: 0, force:false, Inflight: 1, pagedInMessages.size 1, pagedInPendingDispatch.size 0, enqueueCount: 2, dequeueCount: 1, memUsage:1028, maxPageSize:200
2018-06-29 15:26:54.318 DEBUG 2704 --- [enerContainer-1] org.apache.activemq.TransactionContext   : TransactionContext{transactionId=XID:[1096044365,globalId=3137322e32362e3132382e3230392e746d30303032313030303234,branchId=3137322e32362e3132382e3230392e746d3233],connection=ActiveMQConnection {id=ID:LiXinlei-RSC-58618-1530257195477-4:1,clientId=ID:LiXinlei-RSC-58618-1530257195477-3:2,started=true}} ended XA transaction XID:[1096044365,globalId=3137322e32362e3132382e3230392e746d30303032313030303234,branchId=3137322e32362e3132382e3230392e746d3233]
2018-06-29 15:26:54.318  INFO 2704 --- [enerContainer-1] c.a.jms.AtomikosJmsXaSessionProxy        : atomikos xa session proxy for resource jmsConnectionFactory: closing session atomikos xa session proxy for resource jmsConnectionFactory - is terminated ? false
2018-06-29 15:26:54.318 DEBUG 2704 --- [calhost] Task-1] org.apache.activemq.broker.region.Queue  : queue://customer:msg1:new, subscriptions=1, memory=0%, size=1, pending=0 toPageIn: 0, force:false, Inflight: 1, pagedInMessages.size 1, pagedInPendingDispatch.size 0, enqueueCount: 2, dequeueCount: 1, memUsage:1028, maxPageSize:200
2018-06-29 15:26:54.318  INFO 2704 --- [enerContainer-1] c.a.jms.AtomikosJmsConnectionProxy       : atomikos connection proxy for resource jmsConnectionFactory: close()...
2018-06-29 15:26:54.318 DEBUG 2704 --- [enerContainer-1] o.s.t.jta.JtaTransactionManager          : Initiating transaction rollback
2018-06-29 15:26:54.318  INFO 2704 --- [enerContainer-1] c.a.datasource.xa.XAResourceTransaction  : XAResource.rollback ( 3137322E32362E3132382E3230392E746D30303032313030303234:3137322E32362E3132382E3230392E746D3233 ) on resource jmsConnectionFactory represented by XAResource instance TransactionContext{transactionId=null,connection=ActiveMQConnection {id=ID:LiXinlei-RSC-58618-1530257195477-4:1,clientId=ID:LiXinlei-RSC-58618-1530257195477-3:2,started=true}}
2018-06-29 15:26:54.319 DEBUG 2704 --- [enerContainer-1] org.apache.activemq.TransactionContext   : Rollback: 172.26.128.209.tm0002100024172.26.128.209.tm23
2018-06-29 15:26:54.319 DEBUG 2704 --- [//localhost#1-1] o.a.activemq.transaction.XATransaction   : XA Transaction rollback: XID:[1096044365,globalId=3137322e32362e3132382e3230392e746d30303032313030303234,branchId=3137322e32362e3132382e3230392e746d3233]
2018-06-29 15:26:54.319 DEBUG 2704 --- [calhost] Task-1] org.apache.activemq.broker.region.Queue  : queue://customer:msg1:new, subscriptions=1, memory=0%, size=1, pending=0 toPageIn: 0, force:false, Inflight: 1, pagedInMessages.size 1, pagedInPendingDispatch.size 0, enqueueCount: 2, dequeueCount: 1, memUsage:1028, maxPageSize:200
2018-06-29 15:26:54.319 DEBUG 2704 --- [enerContainer-1] o.a.activemq.ActiveMQMessageConsumer     : on close, rollback duplicate: ID:LiXinlei-RSC-58618-1530257195477-4:1:32:1:1
2018-06-29 15:26:54.319 DEBUG 2704 --- [calhost] Task-1] org.apache.activemq.broker.region.Queue  : queue://customer:msg1:new, subscriptions=1, memory=0%, size=1, pending=0 toPageIn: 0, force:false, Inflight: 1, pagedInMessages.size 1, pagedInPendingDispatch.size 0, enqueueCount: 2, dequeueCount: 1, memUsage:1028, maxPageSize:200
2018-06-29 15:26:54.319 DEBUG 2704 --- [enerContainer-1] o.a.activemq.ActiveMQMessageConsumer     : remove: ID:LiXinlei-RSC-58618-1530257195477-4:1:40:1, lastDeliveredSequenceId: 42
2018-06-29 15:26:54.319 DEBUG 2704 --- [calhost] Task-1] org.apache.activemq.broker.region.Queue  : queue://customer:msg1:new, subscriptions=1, memory=0%, size=1, pending=0 toPageIn: 0, force:false, Inflight: 1, pagedInMessages.size 1, pagedInPendingDispatch.size 0, enqueueCount: 2, dequeueCount: 1, memUsage:1028, maxPageSize:200
2018-06-29 15:26:54.319  INFO 2704 --- [enerContainer-1] c.a.datasource.xa.XAResourceTransaction  : XAResource.rollback ( 3137322E32362E3132382E3230392E746D30303032313030303234:3137322E32362E3132382E3230392E746D3234 ) on resource dataSource represented by XAResource instance xads0: conn0: url=jdbc:h2:mem:testdb user=SA
2018-06-29 15:26:54.319 DEBUG 2704 --- [//localhost#1-1] o.a.a.broker.jmx.ManagementContext       : Unregistering MBean org.apache.activemq:type=Broker,brokerName=localhost,destinationType=Queue,destinationName=customer_msg1_new,endpoint=Consumer,clientId=ID_LiXinlei-RSC-58618-1530257195477-3_2,consumerId=ID_LiXinlei-RSC-58618-1530257195477-4_1_40_1
2018-06-29 15:26:54.319 DEBUG 2704 --- [//localhost#1-1] o.a.a.broker.region.AbstractRegion       : localhost removing consumer: ID:LiXinlei-RSC-58618-1530257195477-4:1:40:1 for destination: queue://customer:msg1:new
2018-06-29 15:26:54.320 DEBUG 2704 --- [//localhost#1-1] org.apache.activemq.broker.region.Queue  : queue://customer:msg1:new remove sub: QueueSubscription: consumer=ID:LiXinlei-RSC-58618-1530257195477-4:1:40:1, destinations=1, dispatched=1, delivered=0, pending=0, prefetch=1000, prefetchExtension=0, lastDeliveredSeqId: 42, dequeues: 1, dispatched: 3, inflight: 1, groups: 0
2018-06-29 15:26:54.320  INFO 2704 --- [enerContainer-1] com.atomikos.icatch.jta.Sync2Sync        : afterCompletion ( STATUS_ROLLEDBACK ) called  on Synchronization: org.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization@61fe793d
2018-06-29 15:26:54.320  INFO 2704 --- [enerContainer-1] c.a.jms.AtomikosJmsConnectionProxy       : atomikos connection proxy for resource jmsConnectionFactory: creating XA-capable session...
2018-06-29 15:26:54.320 DEBUG 2704 --- [//localhost#1-1] org.apache.activemq.broker.region.Queue  : found lastDeliveredSeqID: 42, message reference: ID:LiXinlei-RSC-58618-1530257195477-4:1:32:1:1
2018-06-29 15:26:54.320  INFO 2704 --- [enerContainer-1] c.a.icatch.imp.CompositeTransactionImp   : rollback() done of transaction 172.26.128.209.tm0002100024
乌鲁木齐001号程序员
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
springmvc+mybatis+jta 多数据源配置
10-24
通过multipleDataSource 解决多数据切换，并通过jta解决事务同步问题。先配置db.properties文件，再分别在数据库建测试表（user.sql），通过index2.jsp测试。
SpringBoot整合activeMQ遇到的坑，以及整合案例
那年青春，我们正好
09-17 8923
异常源码如下： @JmsListener(destination="mytopic") //注：此处方法不可有返回值 public String receviceTopicMsg(TextMessage tm) { String str = ""; try { str = tm.getText(); System.out.println("topic"+ tm.getTex...
springboot集成ActiveMQ
小馒头味的博客
03-23 1013
一、出现以下异常时，需要注意，receive获取消息时不可有返回值，否则循环报此异常 Execution of JMS message listener failed, and no ErrorHandler has been set. 二、如果使用pool,记得设置为false否则报错 #是否用Pooledconnectionfactory代替普通的ConnectionFactory spri...
active mq 报错 Execution of JMS message listener failed, and no ErrorHandler has been set.
qq_34187522的博客
07-30 9760
实在没想通为啥报这个错误 接收消息后业务代码都执行正常 但就是莫名其妙报了一个这样的错误 然后我把 @Transactional 注释掉了 执行正常 也不报错了 没搞懂咋回事 mq的日志
spring jms 事务_Spring JMS：处理事务中的消息
最佳 Java 编程
06-13 437
spring jms 事务 1.引言 这篇文章将向您展示使用JMS异步接收消息期间使用者执行过程中的错误如何导致消息丢失。 然后，我将解释如何使用本地事务解决此问题。 您还将看到这种解决方案在某些情况下可能导致消息重复（例如，当它将消息保存到数据库中，然后侦听器执行失败时）。 发生这种情况的原因是因为JMS事务独立于其他事务资源（如DB）。 如果您的处理不是幂等的，或者您的应用程序不支持重...
Spring JMS：处理事务中的消息
最佳 Java 编程
05-20 482
1.引言 这篇文章将向您展示在使用JMS异步接收消息期间，使用者执行过程中的错误如何导致消息丢失。 然后，我将解释如何使用本地事务解决此问题。 您还将看到这种解决方案在某些情况下可能导致消息重复（例如，当它将消息保存到数据库中，然后侦听器执行失败时）。 发生这种情况的原因是因为JMS事务独立于其他事务资源（如DB）。 如果您的处理不是幂等的，或者您的应用程序不支持重复消息检测，那么您将不...
Springboot 动态多数据源 jta分布式事务
06-13
该文件是给什么都不会的小白，下载下来进行简单的配置就可以运行，可以到https://blog.csdn.net/qq_43314669/article/details/106733829 进行在线观看
springboot整合jta实现多数据源事务管理
12-10
博客上有很多类似的，很多都有点小错误。还是自己搭建测试的好用。resource中有sql，自己创建两个数据库导入sql，即可运行test测试
多数据源事务之解决方案jta+atomikos
04-09
多数据源事务可采用jta+atomikos方式来解决事务问题。
SSM多数据源同包
05-09
SSM多数据源同包
spring+mybatis+jta实现多数据源的分布式事物（代码可以直接运行）
06-15
使用jta来管理多数据源的事物，代码整洁，一看就懂
多数据源事务jta测试
03-17
NULL 博文链接：https://malixxx.iteye.com/blog/560727
activemq监听消息的时候报错org.springframework.jms.support.converter.MessageConversionException
weixin_40888910的博客
04-09 6802
activemq配置文件如下： @Configuration public class JmsConfig { @Bean public ConnectionFactory connectionFactory(){ ConnectionFactory cf = new ActiveMQConnectionFactory("tcp://localhost:616...
SpringBoot2 整合JTA组件，多数据源事务管理
【积累】，是一个长期持续的过程。
07-12 2231
JTA即Java-Transaction-API，JTA允许应用程序执行分布式事务处理，即在两个或多个网络计算机资源上访问并且更新数据。JDBC驱动程序对JTA的支持极大地增强了数据访问能力。XA协议是数据库层面的一套分布式事务管理的规范,JTA是XA协议在Java中的实现,多个数据库或是消息厂商实现JTA接口,开发人员只需要调用SpringJTA接口即可实现JTA事务管理功能。JTA事务比JDBC事务更强大。一个JTA事务可以有多个参与者，而一个JDBC事务则被限定在一个单一的数据库连接。...
springboot 分布式事务的解决方案(JTA+Atomic+多数据源)（^_^^_^）
热门推荐
jaryle的专栏
03-18 2万+
首先，到底啥是分布式事务呢，比如我们在执行一个业务逻辑的时候有两步分别操作A数据源和B数据源，当我们在A数据源执行数据更改后，在B数据源执行时出现运行时异常，那么我们必须要让B数据源的操作回滚，并回滚对A数据源的操作；这种情况在支付业务时常常出现；比如买票业务在最后支付失败，那之前的操作必须全部回滚，如果之前的操作分布在多个数据源中，那么这就是典型的分布式事务回滚； 了解了什么是分布式事务，那分...
使用JTA解决多数据源事务问题
旷野历程
04-11 2086
分享知识 传递快乐 在一些复杂的应用开发中，一个应用可能会涉及到连接多个数据源，所谓多数据源可以简单理解为至少连接两个及以上的数据库。在动手之前最好先了解对JTA有个了解，可参考：浅谈 JTA 事务 项目环境 springboot 2.3.1 mybatis plus jta 项目依赖 pom.xml中关键依赖 <dependency> <groupId>org.springframework.boot</groupId> &...
spring boot-分布式定时任务中，异步执行时JMS无法重新投递消息
牛奋lch
03-20 1万+
这篇博客是紧接着上篇博客来说的http://blog.csdn.net/liuchuanhong1/article/details/64126346 在上篇博客中，我们基本上实现了分布式的定时任务架构的搭建，但是，当我们异步消费消息中间件中的消息的时候，如果执行的过程中抛了异常，那么，我们无法做到消息重试，示例如下： @Component // 必须加此注解，该类才会被作为Message
一次OOM分析的过程
East271536394
04-22 2964
1. 现象 Java heap space  通过系统日志查询如下:   2013-04-11 16:53:54,569 [ActiveMQ Transport: tcp:///202.111.10.183:8006] WARN org.apache.activemq.transport.failover.FailoverTransport - Transport (/202.111.10
springboot 整合druid+mybatis+jta分布式事务+多数据源aop注解动态切换
最新发布
08-30
在这里，我们将讨论如何使用 Spring Boot 整合 Druid、MyBatis、JTA 分布式事务以及多数据源，同时使用 AOP 注解实现动态切换。 首先，我们可以在 Spring Boot 中集成 Druid 数据源。Druid 是一个高性能的 JDBC ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值