在程序运行时出现这个错误,为了避免以后再次遇到,在此记录一下。
Caused by: com.mysql.cj.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) ~[na:1.8.0_161] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_161] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_161] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_161] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:83) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2201) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2225) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1391) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895) ~[mysql-connector-java-8.0.11.jar:8.0.11] ... 77 common frames omitted
主要是因为升级了mysql连接驱动,如下
compile('mysql:mysql-connector-java:8.0.11')
从错误上看应该是时区的错误,所以我们只需要设置完毕系统的时区即可。
解决办法:在连接url中加入参数 serverTimezone=GMT%2B8,GMT%2B8代表东八区
jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=GMT%2B8
还有另外一种解决方法:设置整个数据库的时区
show variables like '%time_zone%' set global time_zone='+8:00';
相关推荐
l LinBiCMOSTM¹¤ÒÕ¼¼Êõ l Á½¸öÇý¶¯Æ÷¼°Á½¸ö½ÓÊÕÆ÷ l ¡À30VÊäÈëµçƽ l µÍµçÔ´µçÁ÷£ºµäÐÍÖµÊÇ8mA l ·ûºÏÉõÖÁÓÅÓÚANSI±ê×¼EIA/TIA-232-E...
安防系统通用图形符号.zipÊÄɼCADÍ¿dwg¸ÊÏÔ安防系统通用图形符号.zipÊÄɼCADÍ¿dwg¸ÊÏÔ 1.ʺÑÉÖ׸Öɼ²¿ 2.ʺ¸ÈÖ׸Öɼ²¿ 3.ʺ¹ËÖ׸Öɼ²¿
1. ¼¯Èº·þÎñÆ÷ÅäÖ㬰üÀ¨°²×°²Ù×÷ϵͳ¡¢¹Ø±Õ·À»ðǽ¡¢Í¬²½·þÎñÆ÷ʱÖӵȣ» 2. °²×°Cloudera ¹ÜÀíÆ÷£» 3. °²×°CDH ¼¯Èº£» 4. ...
-- Èç¹û²»ÊǹÜÀíÔ±Éí·Ý£¬ÄÇôÉèÖÃʧ°Ü±ê¼Ç tbUserInfo = System.GetUserInfo(); if (tbUserInfo ~= nil) then if (not tbUserInfo.IsAdmin) then bRequirementFail = true...
金典实例,数据结构光盘资源。 /* ´Ë³ÌÐòΪȫ¹ú½»Í¨×ÉѯģÄ⣻ ¾ßÓн»Í¨ÏµÍ³... ¿ª·¢Ê±¼äÊÇ2003.10¡ª¡ª2003.12£» ´Ë³ÌÐòΪ×îÖÕ°æ±¾£» */
LECCO SQL Expert for sql server,Ò»¿îºÜºÃÓõÄSQLÓï¾äÓÅ»¯¹¤¾ß ѹËõ°üÀﺬÓÐ×¢²á»úºÍºº»¯Îļþ Èí¼þÆƽâ×¢²á¼°ºº»¯ËµÃ÷ Æƽⷽ...
//ºáÆÁ»¹ÊÇÊúÆÁ¿ØÖÆ£º0£¬ÊúÆÁ£»1£¬ºáÆÁ¡£ u16 wramcmd; //¿ªÊ¼Ð´gramÖ¸Áî u16 setxcmd; //ÉèÖÃx×ø±êÖ¸Áî u16 setycmd; //ÉèÖÃy×ø±êÖ¸...
¹ãÖÝÊÐÐÇÒíµç×ӿƼ¼ÓÐÏÞ¹«Ë¾ ×÷ÕߣºÕýµãÔ×Ó @ALIENTEK ************************************************/ //Êý×Ö±í const u8* kbd_tbl[9]={"¡û","2",...
±ä»¯¶ø½øÐÐÐ޸ĵÄ×ܹæÔò£¬²¢¿ÉÒÔÓüòµ¥µÄÊýѧ¹«Ê½ ÌåÏÖ³ö¸Ã¹æÔòµÄÔÀí¡£Õâ¾ÍÊÇ×ÔÐÞÕýÒò×Ó·¨µÄ»ù±¾Ë¼ ·¡£
//ʱÖÓÍ£Ö¹±êÖ¾ init_lcd(); clrram_lcd(); Init_DS18B20( ) ; //DS18B20³õʼ»¯ Initial_DS1302(); //ʱÖÓоƬ³õʼ»¯ up_flag=0; down_flag=0; done=0; //½øÈëĬÈÏ...
if ( PcdAnticoll ( ucArray_ID ) == MI_OK ) //·À³åײ£¨µ±ÓжàÕÅ¿¨½øÈë¶ÁдÆ÷²Ù×÷·¶Î§Ê±£¬·À³åÍ»»úÖÆ»á´ÓÆäÖÐÑ¡ÔñÒ»ÕŽøÐвÙ×÷£© ...
¹â±êÓÒÒÆ,AC¼Ó1(00000110) #define DisplayOn 0x0c //ÕûÌåÏÔʾ¿ª,¹â±ê¹Ø,·´°×¹Ø #define DisplayOff 0x08 //ÕûÌåÏÔʾ¹Ø #define CursorOn 0x0e //¹â±êÏ...
//ÄÚ²¿¼Ä´æÆ÷Êý¾Ý£¬Çë²Î¿¼ÖÐÎÄpdf22Ò³ BH1750_Stop(); //·¢ËÍÍ£Ö¹ÐźŠ} //³õʼ»¯BH1750£¬¸ù¾ÝÐèÒªÇë²Î¿¼pdf½øÐÐÐÞ¸Ä**** void Init_...
//ʹÄܽÓÊÕÖÐ¶Ï USART_ITConfig(USART3, USART_IT_RXNE, ENABLE);//¿ªÆôÖÐ¶Ï //ÉèÖÃÖжÏÓÅÏȼ¶ NVIC_InitStructure.NVIC_IRQChannel = USART3_IRQn; NVIC_InitStructure....
¶Ë¿Ú¶¨Ò壺 ×Ô¶¯³µpwmÊä³ö¶Ë¿... EXIT:ÖжÏʹÄÜ MYIIC:Èí¼þi2c¶Ë¿ÚʹÄÜ FILTER: ¿¨¶ûÂüÂ˲¨ balanceº¯Êýº¯Êý¼ÆË㹫ʽ£º
//³õʼ»¯USBÖ÷»ú USBH_Init(&USB_OTG_Core,USB_OTG_FS_CORE_ID,&USB_Host,&USBH_MSC_cb,&USR_Callbacks); while(1) { USBH_Process(&USB_OTG_Core, &USB_Host); delay_ms(1); t++; if(t==...
¹ãÖÝÊÐÐÇÒíµç×ӿƼ¼ÓÐÏÞ¹«Ë¾ ×÷ÕߣºÕýµãÔ×Ó @ALIENTEK ************************************************/ int main(void) { u16 t; u16 len; u...
电气图例.zip室内设计CAD图库dwg格式下载室内设计CAD图库dwg格式下载 1.ʺÑÉÖ׸Öɼ²¿ 2.ʺ¸ÈÖ׸Öɼ²¿ 3.ʺ¹ËÖ׸Öɼ²¿
动态图库1.zip室内设计CAD图库dwg格式下载室内设计CAD图库dwg格式下载 1.ʺÑÉÖ׸Öɼ²¿ 2.ʺ¸ÈÖ׸Öɼ²¿ 3.ʺ¹ËÖ׸Öɼ²¿
立面图库04.zip室内设计CAD图库dwg格式下载室内设计CAD图库dwg格式下载 1.ʺÑÉÖ׸Öɼ²¿ 2.ʺ¸ÈÖ׸Öɼ²¿ 3.ʺ¹ËÖ׸Öɼ²¿