mybatis-generator:According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL

问题描述

在使用mybatis-generator时，遇到了下面这个问题

Mon Apr 01 17:43:37 CST 2024 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

 排查一

根据提示信息，在jdbc链接加上useSSL=false；

运行后结果如下，还是报错，出现以下问题，有点绕了

Unknown system variable 'query_cache_size'

排查二

根据原有提示，出现了版本号的信息，所以分析可能是MYSQL8.0 跟mysql-connector-java版本不匹配的问题

<build>
    <plugins>

        <plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <version>1.3.7</version>
            <configuration>
                <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
                <overwrite>true</overwrite>
                <verbose>true</verbose>
            </configuration>
            <dependencies>
                <dependency>
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <!--<version>5.1.42</version>-->
                    <version>8.0.13</version>
                </dependency>
                <dependency>
                    <groupId>com.github.supergaga</groupId>
                    <artifactId>generator</artifactId>
                    <version>1.0.2</version>
                </dependency>
            </dependencies>
        </plugin>
    </plugins>
</build>

 执行后成功