Cannot determine target DataSource for lookup key [null]

最新推荐文章于 2023-09-01 15:32:10 发布
最新推荐文章于 2023-09-01 15:32:10 发布
阅读量2.7w 收藏
点赞数
分类专栏： bug
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lijiwang666/article/details/87804968
版权 
2019-02-20 16:30:50.303 |-ERROR [http-nio-8090-exec-2] org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/z-crm-e-schedule].[dispatcherServlet] [182] -| Servlet.service() for servlet [dispatcherServlet] in context with path [/z-crm-e-schedule] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection: Cannot determine target DataSource for lookup key [null]
### The error may exist in com/z/crm/dao/persistence/DataMapper.xml
### The error may involve com.z.crm.dao.persistence.DataMapper.select
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection: Cannot determine target DataSource for lookup key [null]] with root cause
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection: Cannot determine target DataSource for lookup key [null]
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:84)
	at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)
	at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	at com.sun.proxy.$Proxy134.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy135.select(Unknown Source)
	at com.z.crm.dao.common.DataDao.select(DataDao.java:374)
	at com.z.crm.dao.common.DataDao.selectAll(DataDao.java:315)
	at com.z.crm.dao.common.DataDao$$FastClassBySpringCGLIB$$82e2cfc1.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.z.crm.dao.common.DataDao$$EnhancerBySpringCGLIB$$c74ccfc4.selectAll(<generated>)
	at com.z.crm.schedule.application.impl.du.DuServiceImpl.getSchProjDuList(DuServiceImpl.java:2158)
	at com.z.crm.schedule.application.impl.du.DuServiceImpl$$FastClassBySpringCGLIB$$426ca040.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.z.crm.schedule.application.impl.du.DuServiceImpl$$EnhancerBySpringCGLIB$$a6c9b3b0.getSchProjDuList(<generated>)
	at com.z.crm.schedule.interfaces.siteschedule.SiteScheduleController.listProjCustomerSiteByMainplanId(SiteScheduleController.java:171)
	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.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:866)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:158)
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:126)
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:111)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1468)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
原因

由于切面是在service调用之前起作用，当调用完成之后会clear掉。

public class DataSourceAspect implements EnvironmentAware {
	@Before("execution(* com.z..application..*.*(..))")
    public void setDataSourceKey(JoinPoint point){
   		 DatabaseContextHolder.setDatabaseType(dbName);
    }
    @After("execution(* com.z..application..*.*(..))")
    public void after(JoinPoint point){
    	DatabaseContextHolder.clear();
    }
}

解决方法：把 testService.do() 移到外面去

@Service
public class ServiceImpl implements Service {
	private TestService testService;
	private DataRepository dataRepository;
	public void test(){
		testService.do();//重点在这里，调用完service之后，DataSource会被清空；
		dataRepository.selectAll();//所以这里使用的使用DataSource为null
	}
}
jackson1024
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 3
    评论
专栏目录
mysql 数据源是否正常_mysql报出找不到目标数据源为啥？ 同一个方法在其他地方调用正常...
weixin_36042436的博客
01-27 335
INFO 10:18:00,126 com.zhuzher.common.util.Util localQuartzScheduler_Worker-2 - SQL STARTTIME:1480472280126 ENDTIME:1480472280126 USETIME:0Exception in thread "Thread-13" com.zhuzher.common.util.DaoRun...
Multiparty quantum key agreement with single particles
02-06
Two conditions must be satisfied in a secure quantum key agreement (QKA) protocol: (1) outside eavesdroppers cannot gain the generated key without introducing any error; (2) the generated key cannot ...
springboot连接mysql报错Failed to obtain JDBC Connection;
qq_38852499的博客
03-18 2万+
预备知识： //在配置mysql连接数据库时我们要导入以下包： <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId&...
Failed to obtain JDBC Connection
Lazy_G的博客
04-19 744
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ‘艺林’@‘localhost’ (using password: YES) 将引入文件去掉,直接写值 就好了 不知道
数据库连接报错CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
最新发布
qq_34254090的博客
09-01 2085
数据库连接报错CannotGetJdbcConnectionException: Failed to obtain JDBC Connection 报错信息 [Name=com.primeton.esb.online.restaurant.ms.online.mediaService.mediaService.biz][activity name=JDBC调用][activity id=invokePojo9] throw an exception:java.lang.Exception,exception
Implicit criteria used to determine promotion for normal and retarded students
06-29
Implicit criteria used to determine promotion for normal and retarded students IMPLICIT CRITERIA USED TO DETERMINE PROMOTION FOR NORMAL AND RETARDED STUDENTS TIMOTHY M. FLY” Southern Illinois ...
3_determine288_fpga_DVI_
10-01
标题 "3_determine288_fpga_DVI_" 指示了这是一个关于FPGA（Field-Programmable Gate Array）实现DVI（Digital Visual Interface）技术的项目。DVI是一种数字视频接口标准，用于传输高质量的视频信号，通常在计算机...
FilesFromLektioner_determine5qs_electronics_
09-30
/20200511/1e36fb74782e4b5e7590ae2851aa753e.zip
Target Tracking with Kalman Filtering, KNN and LSTMs.pdf
12-12
network for single target tracking. We show that LSTMs outperform Kalman ltering for single target prediction by 2x. We also present a unique model for training two dependent LSTMs to output a ...
CannotGetJdbcConnectionException：Failed to obtain JDBC Connection
未来的路
07-16 1843
异常如下： Exception in thread "pool-3-thread-2" org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.springframew...
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
Meloor的博客
06-06 2356
报错：连接数据库失败 This application has no explicit mapping for /error, so you are seeing this as a fallback. Sat Jun 06 15:50:05 CST 2020 There was an unexpected error (type=Internal Server Error, status=500). nested exception is org.apache.ibatis.exceptions.Per
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection； nested
weixin_55229531的博客
06-07 1万+
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30015ms.
【解决报错】failed to obtain JDBC Connection
酷酷的馫博客
04-25 2万+
Loading class ‘com.mysql.jdbc.Driver’. This is deprecated. The new driver class is’com.mysql.cj.jdbc.Driver’（版本和驱动不一致错误）如果你的pom文件数据库依赖没写版本号，那样会默认给你引入最新的MySql版本，如果你本地安装的MySql版本不是最新的就会版本不一致，然后报错。打开任务管理器 -> 详细信息 -> mysqld.exe -> 属性 -> 查看版本号。
java链接数据库JDBC出现 Failed to obtain JDBC Connection ‘???ú±ê×??±??‘
qq_43356169的博客
10-11 1400
java链接数据库JDBC经常出现以下问题： Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via th
【解决报错】Failed to obtain JDBC Connection
热门推荐
weixin_43883815的博客
10-16 6万+
使用springboot与mybatis时，总是遇到数据库无法连接的错误，将解决方法记录如下。 报错： Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; spring.MyBatisExceptionTranslator.translateExceptionIfPossible ibatis.exceptions.ExceptionFactory.wrap
经验总结：突然没法连接数据库 Failed to obtain JDBC Connection
chengqingshihuishui的博客
07-06 2万+
1、问题背景 这个问题真的非常坑，因为一直都连接的好好的，也多次完成了增删改查，突然就连接不上了。报错Failed to obtain JDBC Connection 2、解决办法 前提是你的数据库账号，密码，端口号，mysql服务，都正常。 在jdbc的url中加入时区serverTimezone的设置后再次连接成功。 jdbc.url=jdbc:mysql://localhost:3306/imoocdemo?useUnicode=true&characterEnco..
报错：\n\nCaused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection: Cannot determine target DataSource for lookup key [null]\n\n 
05-27
这个错误通常是因为Spring在获取数据库连接时无法确定数据源。可以检查以下几个方面来解决该问题： 1. 确认你的数据库配置正确，包括数据库的URL、用户名和密码。 2. 检查你的Spring配置文件中是否正确配置了数据源，如下所示： ``` <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/test"/> <property name="username" value="root"/> <property name="password" value="password"/> </bean> ``` 3. 检查你的代码中是否正确使用了数据源，如下所示： ``` @Autowired private DataSource dataSource; ``` 如果上述步骤都没有解决问题，你可以尝试重启应用程序或者重新部署应用程序，看看是否可以解决问题。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值