@DS多数据源下使用@Transactional报错

最新推荐文章于 2024-08-21 13:52:33 发布

SuperProgrammer_

最新推荐文章于 2024-08-21 13:52:33 发布

阅读量819

点赞数

文章标签： sqlserver microsoft 数据库

本文链接：https://blog.csdn.net/SuperProgrammer_/article/details/123315200

版权

在处理多数据源的环境下，使用@Transactional注解可能会遇到问题。通过阅读两篇来自CSDN的文章，对这类问题有了清晰的理解。文章详细介绍了在SQL Server数据库环境中，如何解决此类异常并确保事务的正确管理。

摘要由CSDN通过智能技术生成

看了两位的文章恍然大悟,记录一下
参考文档一: https://blog.csdn.net/qq_37411444/article/details/112873747
参考文档二:
https://blog.csdn.net/weixin_43846916/article/details/110824726

org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'db1.ce_shi' 无效。
### The error may exist in com/transfer/data_transfer/content/transfer/mapper/CeShiMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT * FROM db1.ce_shi WHERE 1 = 1 AND usfl = '1'
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'db1.tc_shenya' 无效。
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'db1.tc_shenya' 无效。

	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
	at com.sun.proxy.$Proxy79.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:173)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy93.selectAll(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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:51)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
	at com.sun.proxy.$Proxy94.selectAll(Unknown Source)
	at com.transfer.data_transfer.content.transfer.service.impl.CeShiServiceImpl.findAll(CeShiServiceImpl.java:42)
	at com.transfer.data_transfer.content.transfer.service.impl.CeShiServiceImpl$$FastClassBySpringCGLIB$$16905355