`

报错The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more t

阅读更多
mysql的时区错误问题: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one

org.springframework.web.util.NestedServletException: 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: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
### The error may exist in com/wj/mapper/UserLoginMapper.xml
### The error may involve com.wj.mapper.UserLoginMapper.selectByName
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
    org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:731)


1. cmd打开,链接数据库
mysql -u root -p
Enter password:root

2. mysql> show variables like '%time_zone%';

3. mysql> set global time_zone='+8:00';

再次测试没有问题
分享到:
评论

相关推荐

    Jmeter连接Mysql数据库实现过程详解

    我们可能会出现一个报错:java.sql.SQLException: Cannot create PoolableConnectionFactory (The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone....

    积分制管理的作用和特点.doc

    »ý·ÖÖƹÜÀí×îÖ÷ÒªµÄ¹¦ÄÜÊÇÔö¼ÓÖƶÈÖ´ÐÐÁ¦¡£Ô±¹¤Î¥¹æ¡¢Î¥ÕµIJÎÓë²»³É¹¦²»ÔÙÖ±½Ó¹ÜÀí³É·Ö¡£Ö®Ç°²»Ö´ÐлòÎÞÖÜ...

    毕业设计(论文)_基于专用温度传感器的温度检测系统方案.doc

    ζȼì²âϵͳÔÚ¹¤ÒµÖв» 断±ä³ÉÇ°Ö÷ÒªµÄÒ»²¿·Ö£¬ÒòΪζȲÎÓëÁ˺ܶಿ·ÖµÄ¹¤³Ì²úÉú¡£ÔÚ±ê×¼µÄζȼì²âϵͳÖÐ...

    KTV安全规章制度.doc

    λ¡£2 / 10Ãð»ðÐж¯×飺×÷ΪǿÖÆÎð²¡×飬³õʼ»¯·À»ð²Ù×÷£¬Ö÷Òª×÷ÓÃÓÚÉèÖ÷À»ðÇøÓò£¬Ö÷ÎÊ×éÖ¯·À»ðÉ豸²¢Ö¸³É¹¤×...

    CDH5.X Centos安装手册

    1. ¼¯Èº·þÎñÆ÷ÅäÖ㬰üÀ¨°²×°²Ù×÷ϵͳ¡¢¹Ø±Õ·À»ðǽ¡¢Í¬²½·þÎñÆ÷ʱÖӵȣ» 2. °²×°Cloudera ¹ÜÀíÆ÷£» 3. °²×°CDH ¼¯Èº£» 4. ...

    儒家文化心得体会.doc

    ÖйúÎ÷·½ÎÄ»¯²»Ö¹²»¹ÜÖªÔò¡£Î÷·½ÎÄ»¯¿ÉÄܲ»ÈçÈå¼ÒÎÄ»¯Ò»Ñù¿ÉÒÔ×ö³öÖÜÎ÷ÎÄ×Ö¡£Î÷·½ÖÜÎ÷ÎÄ×Ö²»¹ÜÖªÔò¡£Î÷·½ÖÜ...

    ¸ßЧÊÖ»úºÅÂë.txt

    ¸ßЧÊÖ»úºÅÂë

    C课程设计 交通咨询

    金典实例,数据结构光盘资源。 /* ´Ë³ÌÐòΪȫ¹ú½»Í¨×ÉѯģÄ⣻ ¾ßÓн»Í¨ÏµÍ³... ¿ª·¢Ê±¼äÊÇ2003.10¡ª¡ª2003.12£» ´Ë³ÌÐòΪ×îÖÕ°æ±¾£» */

    霸气的议论文正稿.doc

    ³öÏÖÔÚ²»Í¬µÄ×Ó×ø±ê¡£Ò»²¿·Ö²úÆ·ÈçÎÒ¹úÖøÃûÆ·Åƺ£¶ûÔ¡°Ô£¬Ö±³ö³ÉΪÉîÎ÷¿É¿¿¡£Ö÷ÒòÔÚÓÚ“°Ô”±íʾ³öÆäÔÚͬ²¿Îï...

    ³£¼ûÍøÕ¾±¸·ÝÎļþ×Öµä.txt

    ³£¼ûÍøÕ¾±¸·ÝÎļþ×Öµä

    大学生自我鉴定3000字.doc

    Ϊ×Ô¼º×ö³ö²¿·Ö²Î¿¼²é¿ö£¬ÎÒ¿ªÊ¼²ÎÓë³É¹¦×îÖØÒªµÄ×ܳɹ¦¿Î³Ì¡£ÎÒ³õʼ³É¹¦×ö³öÁ˲¿·Ö²Î¿¼²é¿ö£¬²»¹ýÎÒÈ·ÈÏ×Ô...

    TFT LCD显示

    //ºáÆÁ»¹ÊÇÊúÆÁ¿ØÖÆ£º0£¬ÊúÆÁ£»1£¬ºáÆÁ¡£ u16 wramcmd; //¿ªÊ¼Ð´gramÖ¸Áî u16 setxcmd; //ÉèÖÃx×ø±êÖ¸Áî u16 setycmd; //ÉèÖÃy×ø±êÖ¸...

    LECCO SQL Expert for sql server

    LECCO SQL Expert for sql server,Ò»¿îºÜºÃÓõÄSQLÓï¾äÓÅ»¯¹¤¾ß ѹËõ°üÀﺬÓÐ×¢²á»úºÍºº»¯Îļþ Èí¼þÆƽâ×¢²á¼°ºº»¯ËµÃ÷ Æƽⷽ...

    SetupFactory(Dot net4.0脚本) .net4 脚本

    -- Èç¹û²»ÊǹÜÀíÔ±Éí·Ý£¬ÄÇôÉèÖÃʧ°Ü±ê¼Ç tbUserInfo = System.GetUserInfo(); if (tbUserInfo ~= nil) then if (not tbUserInfo.IsAdmin) then bRequirementFail = true...

    LCD12864+DS1302时钟+18B20温度计实验例程C51单片机KEIL工程源码文件.zip

    //ʱÖÓÍ£Ö¹±êÖ¾ init_lcd(); clrram_lcd(); Init_DS18B20( ) ; //DS18B20³õʼ»¯ Initial_DS1302(); //ʱÖÓоƬ³õʼ»¯ up_flag=0; down_flag=0; done=0; //½øÈëĬÈÏ...

    springboot整合mybatis中的问题及出现的一些问题小结

    2. The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone解决方案 在使用MyBatis时,可能会遇到服务器时区值无法识别的问题。解决方案是,在application...

    应用文主题要求内容.doc

    ΪÁË×îºó³ÉΪÎÄ×÷Ö®¡£ÎÒÃÇÒª×ö³öÎÄ×÷Ö®Ö÷¡£ÎªÁËÎÄ×÷Ö®¡£ÎÒÃDZØ×ö³öÖ÷Ö®¡£ÎªÁËÎÄ×÷Ö®¡£ÎÒÃDZØ×ö³öÖ÷Ö®¡£ÎªÁË...

    高中物理教学心得(八篇).doc

    ÎïÀí²Î×ÓÔÚ³ö²¥¹ý³ÌÖ中断²é×îºó¡°³É¹¦¡...¹ý³ÌÖУ¬ÎïÀí½Ìʦ³ÉΪÖ÷»ú£¬²Î×ÓÖ÷ÈçÎïÖÊ¡¢²ÎÊý¡¢³ö²¥³ÌÐò¡¢³ö²¥É豸¡£...

    安防系统通用图形符号.zipÊÄɼCADÍ¿dwg¸ÊÏÔ

    安防系统通用图形符号.zipÊÄɼCADÍ¿dwg¸ÊÏÔ安防系统通用图形符号.zipÊÄɼCADÍ¿dwg¸ÊÏÔ 1.ʺÑÉÖ׸Öɼ²¿ 2.ʺ¸ÈÖ׸Öɼ²¿ 3.ʺ¹ËÖ׸Öɼ²¿

    单片机与液晶做的贪吃蛇游戏(有源码)

    ¹â±êÓÒÒÆ,AC¼Ó1(00000110) #define DisplayOn 0x0c //ÕûÌåÏÔʾ¿ª,¹â±ê¹Ø,·´°×¹Ø #define DisplayOff 0x08 //ÕûÌåÏÔʾ¹Ø #define CursorOn 0x0e //¹â±êÏ...

Global site tag (gtag.js) - Google Analytics