详解mybatis.generator配上最新的mysql 8.0.11的一些坑

<plugin>

   <groupid>org.mybatis. generator </groupid>

   <artifactid>mybatis-generator-maven-plugin</artifactid>

   <version> 1.3 . 5 </version>

   <configuration>

     <configurationfile>

       <!--这里是配置generatorconfig.xml的路径      

     不写默认在resources目录下找generatorconfig.xml文件     

      -->

     </configurationfile>

     <verbose> true </verbose>

     <overwrite> true </overwrite>

   </configuration>

   <dependencies>

     <dependency>

       <groupid>mysql</groupid>

       <artifactid>mysql-connector-java</artifactid>

       <version> 8.0 . 11 </version>

     </dependency>

   </dependencies>

</plugin>

<?xml version= "1.0" encoding= "utf-8" ?>

<!doctype generatorconfiguration

  public "-//mybatis.org//dtd mybatis generator configuration 1.0//en"   

  "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >

<generatorconfiguration>

   <!-- context 是逆向工程的主要配置信息 -->

   <!-- id：起个名字 -->

   <!-- targetruntime：设置生成的文件适用于那个 mybatis 版本 -->

   <context id= "default" targetruntime= "mybatis3" >

     <!--optional,旨在创建 class 时，对注释进行控制-->

     <commentgenerator>

       <property name= "suppressdate" value= "true" />

       <!-- 是否去除自动生成的注释 true ：是 ： false :否 -->

       <property name= "suppressallcomments" value= "true" />

     </commentgenerator>

     <!--jdbc的数据库连接-->

     <jdbcconnection driverclass= "com.mysql.cj.jdbc.driver"         

     connectionurl= "jdbc:mysql://localhost:3306/ajyl_medical_model?servertimezone=utc"             userid= "root"             password= "123456" ></jdbcconnection>

     <!--非必须，类型处理器，在数据库类型和java类型之间的转换控制-->

     <javatyperesolver>

       <!-- 默认情况下数据库中的 decimal，bigint 在 java 对应是 sql 下的 bigdecimal 类 -->

       <!-- 不是 double 和 long 类型 -->

       <!-- 使用常用的基本类型代替 sql 包下的引用类型 -->

       <property name= "forcebigdecimals" value= "false" />

     </javatyperesolver>

     <!-- targetpackage：生成的实体类所在的包 -->

     <!-- targetproject：生成的实体类所在的硬盘位置 -->

     <javamodelgenerator targetpackage= "com.ajyl.modules.asset.entity"     

           targetproject= "src/main/java" >

       <!-- 是否允许子包 -->

       <property name= "enablesubpackages" value= "false" />

       <!-- 是否对modal添加构造函数 -->

       <property name= "constructorbased" value= "true" />

       <!-- 是否清理从数据库中查询出的字符串左右两边的空白字符 -->

       <property name= "trimstrings" value= "true" />

       <!-- 建立modal对象是否不可改变 即生成的modal对象不会有setter方法，只有构造方法 -->

       <property name= "immutable" value= "false" />

     </javamodelgenerator>

     <!-- targetpackage 和 targetproject：生成的 mapper 文件的包和位置 -->

     <sqlmapgenerator targetpackage= "mapper"      

        targetproject= "src/main/resource" >

       <!-- 针对数据库的一个配置，是否把 schema 作为字包名 -->

       <property name= "enablesubpackages" value= "false" />

     </sqlmapgenerator>

     <!-- targetpackage 和 targetproject：生成的 interface 文件的包和位置 -->

     <javaclientgenerator type= "xmlmapper"    

            targetpackage= "com.ajyl.modules.asset.dao" targetproject= "src/main/java" >

       <!-- 针对 oracle 数据库的一个配置，是否把 schema 作为字包名 -->

       <property name= "enablesubpackages" value= "false" />

     </javaclientgenerator>

     <table tablename= "asset_product_feedback" domainobjectname= "assetproductfeedback"   

      enablecountbyexample= "false" enableupdatebyexample= "false"   

      enabledeletebyexample= "false" enableselectbyexample= "false"

       selectbyexamplequeryid= "false" ></table>

   </context>

</generatorconfiguration>

[info] ------------------------------------------------------------------------

[info] build failure

[info] ------------------------------------------------------------------------

[info] total time: 2.581 s

[info] finished at: 2018 - 08 -05t11: 51 : 49 + 08 : 00

[info] ------------------------------------------------------------------------

[error] failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin: 1.3 . 5 :generate ( default -cli) on project smart-campus: 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. -> [help 1 ]

[error] [

error] to see the full stack trace of the errors, re-run maven with the -e switch .

[error] re-run maven using the -x switch to enable full debug logging.

[error]

[error] for more information about the errors and possible solutions, please read the following articles:

[error] [help 1 ] http: //cwiki.apache.org/confluence/display/maven/mojoexecutionexception

process finished with exit code 1