报Could not get JDBC Connection的错误

Dear 丶 2022-03-01 04:36 669阅读 0赞

之前用的都是mysql数据库，这次的项目需要用到Oracle数据库 ，在搭好环境后进行数据库连接测试时报Could not get JDBC Connection;的错误，详细错误如下：

  1. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: oracle.jdbc.OracleDriver] with root cause
  2. java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
  3.     at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1702)
  4.     at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1547)
  5.     at java.lang.Class.forName0(Native Method)
  6.     at java.lang.Class.forName(Class.java:264)
  7.     at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:598)
  8.     at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:817)
  9.     at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1229)
  10.     at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1225)
  11.     at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:90)
  12.     at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
  13.     at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
  14.     at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)
  15.     at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68)
  16.     at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:338)
  17.     at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84)
  18.     at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  19.     at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)
  20.     at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  21.     at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  22.     at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
  23.     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
  24.     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
  25.     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
  26.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  27.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  28.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  29.     at java.lang.reflect.Method.invoke(Method.java:498)
  30.     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
  31.     at com.sun.proxy.$Proxy37.selectOne(Unknown Source)
  32.     at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
  33.     at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:83)
  34.     at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
  35.     at com.sun.proxy.$Proxy38.selectByPrimaryKey(Unknown Source)
  36.     at cn.difu.wxznwd.service.serviceImpl.WxznZcxxServiceImol.getzcxx(WxznZcxxServiceImol.java:28)
  37.     at cn.difu.wxznwd.controller.WxznZcXXController.reg(WxznZcXXController.java:28)
  38.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  39.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  40.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  41.     at java.lang.reflect.Method.invoke(Method.java:498)
  42.     at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  43.     at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  44.     at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  45.     at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  46.     at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  47.     at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  48.     at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  49.     at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  50.     at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  51.     at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  52.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
  53.     at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  54.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  55.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  56.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  57.     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
  58.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  59.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  60.     at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  61.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  62.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  63.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  64.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  65.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  66.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  67.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  68.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
  69.     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
  70.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  71.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
  72.     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
  73.     at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
  74.     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
  75.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  76.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  77.     at java.lang.Thread.run(Thread.java:748)

这次范了一个很低级的错误就是连接的时Oracle数据库，pom文件用引用的确实Mysql的驱动，已造成Could not get JDBC Connection的错误，然后在之前的项目中找到ojdbc6-0.0.1-SNAPSHOT.jar的包，并通过Eclipsece添加到Maven本地仓库然后在pom.xml中引用，重启就好了！

发表评论

表情：
评论列表 （有 0 条评论，669人围观）

还没有评论，来说两句吧...

相关阅读