解决HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.CannotGe

约定不等于承诺〃 2022-02-19 00:59 422阅读 0赞

### 使用springMVC时，报出这个错误： ###

# HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.) #

### 具体错误信息如下： ###

com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value '?й???????' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    	at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)
    	at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
    	at com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:118)
    	at com.mysql.cj.mysqla.MysqlaSession.configureTimezone(MysqlaSession.java:293)
    	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:2399)
    	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1739)
    	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596)
    	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:633)
    	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)
    	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219)
    	at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39)
    	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)
    	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304)
    	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290)
    	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)
    	at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)
    	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
    	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
    	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:625)
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:690)
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:732)
    	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:806)
    	at dao.UserDAO.getLogin(UserDAO.java:37)
    	at service.impl.UserServiceImpl.getLogin(UserServiceImpl.java:24)
    	at controller.IndexController.login(IndexController.java:45)
    	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.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:181)
    	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
    	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
    	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
    	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
    	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    	at filter.Filters.doFilter(Filters.java:25)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
    	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
    	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
    	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2555)
    	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2544)
    	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)

## 解决方案： ##

在连接池配置文件处添加修改时区的代码：

serverTimezone=UTC

修改完即可。

解决HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.CannotGe

发表评论取消回复

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

相关阅读

相关 500 Request processing failed； nested exception is java.lang.NullPointerException

相关 HTTP Status 500 - Request processing failed; nested exception is java.lang.NullPointerException

相关解决HTTP Status 500 - Request processing failed; nested exception is org.apache.ibatis.binding.Binding

相关 Request processing failed; nested exception is javax.validation.ConstraintViolationException报错

相关 HTTP Status 500 - Request processing failed 问题与解决

相关 HTTP Status 500 - Request processing failed; nested exception is org.apache.ibatis.binding.BindingEx

相关解决Request processing failed; nested exception is java.lang.NullPointerException

相关 HTTP Status 500 - Request processing failed; nested exception is org.apache.ibatis.binding.BindingEx

相关解决HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.CannotGe

相关浏览器报错如下: HTTP Status 500 - Request processing failed; nested exception is com.alibaba.dubbo.rpc.RpcE