• 升级mysql-connector 5到8遇到的问题


    https://mangocool.com/1535426841921.html

    以下是我升级mysql-connector 从5.1.46到8.0.11时遇到的问题 :

    1、Establishing SSL connection without server's identity verification is not recommend

    解决办法:在mysql连接字符串url中加入ssl=true或者false即可,如下:

                    url=jdbc:mysql://xxx.xxx.xxx.xxx:3306/xxx?characterEncoding=utf8&useSSL=true

    参考:https://blog.csdn.net/guoweimelon/article/details/50810399

    2、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. 

    解决办法:在mysql连接字符串url中加入serverTimezone=UTC即可,如下:。

                   url=jdbc:mysql://xxx.xxx.xxx.xxx:3306/xxx?characterEncoding=utf8&useSSL=true&serverTimezone=UTC

    参考:https://blog.csdn.net/yefengzhichen/article/details/51834511

    3、java.sql.SQLException: The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 'convertToNull' is not acceptable.
    java.lang.IllegalArgumentException: No enum constant com.mysql.cj.conf.PropertyDefinitions.ZeroDatetimeBehavior.CONVERTTONULL

    解决办法:由于MySql废弃了convertToNull该写法,改为 CONVERT_TO_NULL

                    url=jdbc:mysql://xxx.xxx.xxx.xxx:3306/xxx?characterEncoding=utf8&useSSL=true&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL

    考:https://blog.csdn.net/qq_32454537/article/details/80109800

    4、Exception in thread "main" org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Unable to locate Spring NamespaceHandler for XML schema namespace [http://www.springframework.org/schema/context]
    Offending resource: class path resource [spring-mybatis.xml]

    参考http://chenzhou123520.iteye.com/blog/1971322

  • 相关阅读:
    [恢]hdu 2203
    [恢]hdu 2089
    [恢]hdu 1597
    [恢]hdu 1239
    [恢]hdu 2141
    [恢]hdu 2152
    [恢]hdu 2078
    [恢]hdu 2304
    [恢]hdu 1799
    非金钱激励员工的108种手段 ,你一定要懂!
  • 原文地址:https://www.cnblogs.com/lizhenlzlz/p/12485785.html
Copyright © 2020-2023  润新知