springboot集成jooq异常集合

た入场券 2023-06-14 14:59 27阅读 0赞

### 环境背景：jdk13、apache-maven-3.6.2、IDEA2019.2.4、springboot-**2.2.0.RELEASE、jooq3.12.2** ###

### 一、Error running jOOQ code generation tool ###

**1. 异常背景：通过jooq-codegen-maven插件生成代码时报错**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70][]

**2. 异常详情**

Failed to execute goal org.jooq:jooq-codegen-maven:3.12.2:generate (default-cli) on project jooq: Error running jOOQ code generation tool

**3. 异常原因：在pom.xml文件中，通过yaml-properties-maven-plugin插件读取application.yml配置文件中内容，直接操作jooq-codegen-maven插件无效**

**4. 解决方法：**

**4.1 方法1：通过maven，执行mvn compile命令**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 1][]

**4.1.1 查看效果**

E:\jdk\jdk-13.0.1\bin\java.exe -Dmaven.multiModuleProjectDirectory=F:\IdeaProjects\jooq -Dmaven.home=E:\maven\apache-maven-3.6.2 -Dclassworlds.conf=E:\maven\apache-maven-3.6.2\bin\m2.conf "-Dmaven.ext.class.path=E:\JetBrains\IntelliJ IDEA 2019.2.3\plugins\maven\lib\maven-event-listener.jar" -Dfile.encoding=UTF-8 -classpath E:\maven\apache-maven-3.6.2\boot\plexus-classworlds-2.6.0.jar org.codehaus.classworlds.Launcher -Didea.version2019.2.4 -s E:\maven\apache-maven-3.6.2\conf\settings.xml compile
    [INFO] Scanning for projects...
    [WARNING] 
    [WARNING] Some problems were encountered while building the effective model for com.zsx:jooq:jar:1.0-SNAPSHOT
    [WARNING] 'dependencies.dependency.scope' for org.springframework.boot:spring-boot-devtools:jar must be one of [provided, compile, runtime, test, system] but is 'true'. @ line 105, column 20
    [WARNING] 
    [WARNING] It is highly recommended to fix these problems because they threaten the stability of your build.
    [WARNING] 
    [WARNING] For this reason, future Maven versions might no longer support building such malformed projects.
    [WARNING] 
    [INFO] 
    [INFO] ----------------------------< com.zsx:jooq >----------------------------
    [INFO] Building jooq 1.0-SNAPSHOT
    [INFO] --------------------------------[ jar ]---------------------------------
    [INFO] 
    [INFO] --- yaml-properties-maven-plugin:1.1.3:read-project-properties (default) @ jooq ---
    [INFO] 
    [INFO] --- jooq-codegen-maven:3.12.2:generate (default) @ jooq ---
    [INFO] No <inputCatalog/> was provided. Generating ALL available catalogs instead.
    [INFO] License parameters       
    [INFO] ----------------------------------------------------------
    [INFO]   Thank you for using jOOQ and jOOQ's code generator
    [INFO]                          
    [INFO] Database parameters      
    [INFO] ----------------------------------------------------------
    [INFO]   dialect                : POSTGRES
    [INFO]   URL                    : jdbc:postgresql://127.0.0.1:5432/mydb11
    [INFO]   target dir             : F:\IdeaProjects\jooq\src\main\java
    [INFO]   target package         : com.zsx.generator.jooq
    [INFO]   includes               : [.*]
    [INFO]   excludes               : []
    [INFO]   includeExcludeColumns  : false
    [INFO] ----------------------------------------------------------
    [INFO]                          
    [INFO] JavaGenerator parameters 
    [INFO] ----------------------------------------------------------
    [INFO]   annotations (generated): true
    [INFO]   annotations (JPA: any) : false
    [INFO]   annotations (JPA: version): 
    [INFO]   annotations (validation): false
    [INFO]   comments               : true
    [INFO]   comments on attributes : true
    [INFO]   comments on catalogs   : true
    [INFO]   comments on columns    : true
    [INFO]   comments on keys       : true
    [INFO]   comments on links      : true
    [INFO]   comments on packages   : true
    [INFO]   comments on parameters : true
    [INFO]   comments on queues     : true
    [INFO]   comments on routines   : true
    [INFO]   comments on schemas    : true
    [INFO]   comments on sequences  : true
    [INFO]   comments on tables     : true
    [INFO]   comments on udts       : true
    [INFO]   daos                   : false
    [INFO]   deprecated code        : true
    [INFO]   global references (any): true
    [INFO]   global references (catalogs): true
    [INFO]   global references (keys): true
    [INFO]   global references (links): true
    [INFO]   global references (queues): true
    [INFO]   global references (routines): true
    [INFO]   global references (schemas): true
    [INFO]   global references (sequences): true
    [INFO]   global references (tables): true
    [INFO]   global references (udts): true
    [INFO]   indexes                : true
    [INFO]   instance fields        : true
    [INFO]   interfaces             : false
    [INFO]   interfaces (immutable) : false
    [INFO]   javadoc                : true
    [INFO]   keys                   : true
    [INFO]   links                  : true
    [INFO]   pojos                  : false
    [INFO]   pojos (immutable)      : false
    [INFO]   queues                 : true
    [INFO]   records                : true
    [INFO]   routines               : true
    [INFO]   sequences              : true
    [INFO]   table-valued functions : true
    [INFO]   tables                 : true
    [INFO]   udts                   : true
    [INFO]   relations              : true
    [INFO] ----------------------------------------------------------
    [INFO]                          
    [INFO] Generation remarks       
    [INFO] ----------------------------------------------------------
    [INFO]                          
    [INFO] ----------------------------------------------------------
    [INFO] Generating catalogs      : Total: 1
    WARNING: An illegal reflective access operation has occurred
    WARNING: Illegal reflective access by org.jooq.tools.reflect.Reflect (file:/E:/maven/repository/org/jooq/jooq/3.12.2/jooq-3.12.2.jar) to constructor java.lang.invoke.MethodHandles$Lookup(java.lang.Class)
    WARNING: Please consider reporting this to the maintainers of org.jooq.tools.reflect.Reflect
    WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
    WARNING: All illegal access operations will be denied in a future release
    [INFO] ARRAYs fetched           : 0 (0 included, 0 excluded)
    [INFO] Enums fetched            : 0 (0 included, 0 excluded)
    [INFO] Packages fetched         : 0 (0 included, 0 excluded)
    [INFO] Routines fetched         : 0 (0 included, 0 excluded)
    [INFO] Sequences fetched        : 0 (0 included, 0 excluded)
    [INFO] Tables fetched           : 3 (3 included, 0 excluded)
    [INFO] No schema version is applied for catalog . Regenerating.
    [INFO]                          
    [INFO] Generating catalog       : DefaultCatalog.java
    [INFO] ==========================================================
    [INFO] Generating schemata      : Total: 1
    [INFO] No schema version is applied for schema jooq. Regenerating.
    [INFO] Generating schema        : Jooq.java
    [INFO] ----------------------------------------------------------
    [INFO] UDTs fetched             : 0 (0 included, 0 excluded)
    [INFO] Generating tables        
    [INFO] Synthetic primary keys   : 0 (0 included, 0 excluded)
    [INFO] Overriding primary keys  : 3 (0 included, 3 excluded)
    [INFO] Generating table         : Accounts.java [input=accounts, output=accounts, pk=accounts_pkey]
    [INFO] Embeddables fetched      : 0 (0 included, 0 excluded)
    [INFO] Indexes fetched          : 4 (4 included, 0 excluded)
    [INFO] Generating table         : FlywaySchemaHistory.java [input=flyway_schema_history, output=flyway_schema_history, pk=flyway_schema_history_pk]
    [INFO] Generating table         : Transactions.java [input=transactions, output=transactions, pk=transactions_pkey]
    [INFO] Tables generated         : Total: 650.094ms
    [INFO] Generating table references
    [INFO] Table refs generated     : Total: 651.779ms, +1.685ms
    [INFO] Generating Keys          
    [INFO] Keys generated           : Total: 654.119ms, +2.339ms
    [INFO] Generating Indexes       
    [INFO] Indexes generated        : Total: 655.578ms, +1.459ms
    [INFO] Generating table records 
    [INFO] Generating record        : AccountsRecord.java
    [INFO] Generating record        : FlywaySchemaHistoryRecord.java
    [INFO] Generating record        : TransactionsRecord.java
    [INFO] Table records generated  : Total: 700.921ms, +45.343ms
    [INFO] Domains fetched          : 0 (0 included, 0 excluded)
    [INFO] Generation finished: jooq: Total: 711.908ms, +10.986ms
    [INFO]                          
    [INFO] Removing excess files    
    [INFO] 
    [INFO] --- flyway-maven-plugin:6.0.7:migrate (default) @ jooq ---
    [INFO] Flyway Community Edition 6.0.7 by Redgate
    [INFO] Database: jdbc:postgresql://127.0.0.1:5432/mydb11 (PostgreSQL 12.0)
    [INFO] Successfully validated 2 migrations (execution time 00:00.010s)
    [INFO] Current version of schema "jooq": 1
    [INFO] Schema "jooq" is up to date. No migration necessary.
    [INFO] 
    [INFO] --- maven-resources-plugin:3.1.0:resources (default-resources) @ jooq ---
    [INFO] Using 'UTF-8' encoding to copy filtered resources.
    [INFO] Copying 2 resources
    [INFO] 
    [INFO] --- maven-compiler-plugin:3.8.1:compile (default-compile) @ jooq ---
    [INFO] Changes detected - recompiling the module!
    [INFO] Compiling 13 source files to F:\IdeaProjects\jooq\target\classes
    [INFO] /F:/IdeaProjects/jooq/src/main/java/com/zsx/filter/AccountIDFilter.java: F:\IdeaProjects\jooq\src\main\java\com\zsx\filter\AccountIDFilter.java使用或覆盖了已过时的 API。
    [INFO] /F:/IdeaProjects/jooq/src/main/java/com/zsx/filter/AccountIDFilter.java: 有关详细信息, 请使用 -Xlint:deprecation 重新编译。
    [INFO] ------------------------------------------------------------------------
    [INFO] BUILD SUCCESS
    [INFO] ------------------------------------------------------------------------
    [INFO] Total time:  3.694 s
    [INFO] Finished at: 2019-11-20T10:13:54+08:00
    [INFO] ------------------------------------------------------------------------

![20191120101532907.png][]

**4.2 方法2：将pom.xml文件中jooq-codegen-maven插件关于数据库的配置**

<jdbc>
                            <url>${spring.datasource.url}</url>
                            <user>${spring.datasource.username}</user>
                            <password>${spring.datasource.password}</password>
                            <driver>${spring.datasource.driver-class-name}</driver>
                        </jdbc>

**修改为 **

<jdbc>
                            <url>jdbc:postgresql://127.0.0.1:5432/mydb11</url>
                            <user>postgres</user>
                            <password>1234</password>
                            <driver>org.postgresql.Driver</driver>
                        </jdbc>

**jooq-codegen-maven整体插件配置为**

<plugin>
                    <groupId>org.jooq</groupId>
                    <artifactId>jooq-codegen-maven</artifactId>
                    <executions>
                        <execution>
                            <goals>
                                <goal>generate</goal>
                            </goals>
                        </execution>
                    </executions>
                    <configuration>
                        
                        
                        
                        <jdbc>
                            <url>jdbc:postgresql://127.0.0.1:5432/mydb11</url>
                            <user>postgres</user>
                            <password>1234</password>
                            <driver>org.postgresql.Driver</driver>
                        </jdbc>
                        <generator>
                            
                            <name>org.jooq.codegen.JavaGenerator</name>
                            <database>
                                <name>org.jooq.meta.postgres.PostgresDatabase</name>
                                
                                <includes>.*</includes>
                                <excludes />
                                
                                <inputSchema>jooq</inputSchema>
                            </database>
                            <target>
                                
                                <packageName>com.zsx.generator.jooq</packageName>
                                <directory>src/main/java</directory>
                            </target>
                        </generator>
                    </configuration>
                </plugin>

**4.2.2 查看效果**

**执行mvn compile命令效果**

E:\jdk\jdk-13.0.1\bin\java.exe -Dmaven.multiModuleProjectDirectory=F:\IdeaProjects\jooq -Dmaven.home=E:\maven\apache-maven-3.6.2 -Dclassworlds.conf=E:\maven\apache-maven-3.6.2\bin\m2.conf "-Dmaven.ext.class.path=E:\JetBrains\IntelliJ IDEA 2019.2.3\plugins\maven\lib\maven-event-listener.jar" -Dfile.encoding=UTF-8 -classpath E:\maven\apache-maven-3.6.2\boot\plexus-classworlds-2.6.0.jar org.codehaus.classworlds.Launcher -Didea.version2019.2.4 -s E:\maven\apache-maven-3.6.2\conf\settings.xml compile
    [INFO] Scanning for projects...
    [WARNING] 
    [WARNING] Some problems were encountered while building the effective model for com.zsx:jooq:jar:1.0-SNAPSHOT
    [WARNING] 'dependencies.dependency.scope' for org.springframework.boot:spring-boot-devtools:jar must be one of [provided, compile, runtime, test, system] but is 'true'. @ line 105, column 20
    [WARNING] 
    [WARNING] It is highly recommended to fix these problems because they threaten the stability of your build.
    [WARNING] 
    [WARNING] For this reason, future Maven versions might no longer support building such malformed projects.
    [WARNING] 
    [INFO] 
    [INFO] ----------------------------< com.zsx:jooq >----------------------------
    [INFO] Building jooq 1.0-SNAPSHOT
    [INFO] --------------------------------[ jar ]---------------------------------
    [INFO] 
    [INFO] --- yaml-properties-maven-plugin:1.1.3:read-project-properties (default) @ jooq ---
    [INFO] 
    [INFO] --- jooq-codegen-maven:3.12.2:generate (default) @ jooq ---
    [INFO] No <inputCatalog/> was provided. Generating ALL available catalogs instead.
    [INFO] License parameters       
    [INFO] ----------------------------------------------------------
    [INFO]   Thank you for using jOOQ and jOOQ's code generator
    [INFO]                          
    [INFO] Database parameters      
    [INFO] ----------------------------------------------------------
    [INFO]   dialect                : POSTGRES
    [INFO]   URL                    : jdbc:postgresql://127.0.0.1:5432/mydb11
    [INFO]   target dir             : F:\IdeaProjects\jooq\src\main\java
    [INFO]   target package         : com.zsx.generator.jooq
    [INFO]   includes               : [.*]
    [INFO]   excludes               : []
    [INFO]   includeExcludeColumns  : false
    [INFO] ----------------------------------------------------------
    [INFO]                          
    [INFO] JavaGenerator parameters 
    [INFO] ----------------------------------------------------------
    [INFO]   annotations (generated): true
    [INFO]   annotations (JPA: any) : false
    [INFO]   annotations (JPA: version): 
    [INFO]   annotations (validation): false
    [INFO]   comments               : true
    [INFO]   comments on attributes : true
    [INFO]   comments on catalogs   : true
    [INFO]   comments on columns    : true
    [INFO]   comments on keys       : true
    [INFO]   comments on links      : true
    [INFO]   comments on packages   : true
    [INFO]   comments on parameters : true
    [INFO]   comments on queues     : true
    [INFO]   comments on routines   : true
    [INFO]   comments on schemas    : true
    [INFO]   comments on sequences  : true
    [INFO]   comments on tables     : true
    [INFO]   comments on udts       : true
    [INFO]   daos                   : false
    [INFO]   deprecated code        : true
    [INFO]   global references (any): true
    [INFO]   global references (catalogs): true
    [INFO]   global references (keys): true
    [INFO]   global references (links): true
    [INFO]   global references (queues): true
    [INFO]   global references (routines): true
    [INFO]   global references (schemas): true
    [INFO]   global references (sequences): true
    [INFO]   global references (tables): true
    [INFO]   global references (udts): true
    [INFO]   indexes                : true
    [INFO]   instance fields        : true
    [INFO]   interfaces             : false
    [INFO]   interfaces (immutable) : false
    [INFO]   javadoc                : true
    [INFO]   keys                   : true
    [INFO]   links                  : true
    [INFO]   pojos                  : false
    [INFO]   pojos (immutable)      : false
    [INFO]   queues                 : true
    [INFO]   records                : true
    [INFO]   routines               : true
    [INFO]   sequences              : true
    [INFO]   table-valued functions : true
    [INFO]   tables                 : true
    [INFO]   udts                   : true
    [INFO]   relations              : true
    [INFO] ----------------------------------------------------------
    [INFO]                          
    [INFO] Generation remarks       
    [INFO] ----------------------------------------------------------
    [INFO]                          
    [INFO] ----------------------------------------------------------
    [INFO] Generating catalogs      : Total: 1
    WARNING: An illegal reflective access operation has occurred
    WARNING: Illegal reflective access by org.jooq.tools.reflect.Reflect (file:/E:/maven/repository/org/jooq/jooq/3.12.2/jooq-3.12.2.jar) to constructor java.lang.invoke.MethodHandles$Lookup(java.lang.Class)
    WARNING: Please consider reporting this to the maintainers of org.jooq.tools.reflect.Reflect
    WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
    WARNING: All illegal access operations will be denied in a future release
    [INFO] ARRAYs fetched           : 0 (0 included, 0 excluded)
    [INFO] Enums fetched            : 0 (0 included, 0 excluded)
    [INFO] Packages fetched         : 0 (0 included, 0 excluded)
    [INFO] Routines fetched         : 0 (0 included, 0 excluded)
    [INFO] Sequences fetched        : 0 (0 included, 0 excluded)
    [INFO] Tables fetched           : 3 (3 included, 0 excluded)
    [INFO] No schema version is applied for catalog . Regenerating.
    [INFO]                          
    [INFO] Generating catalog       : DefaultCatalog.java
    [INFO] ==========================================================
    [INFO] Generating schemata      : Total: 1
    [INFO] No schema version is applied for schema jooq. Regenerating.
    [INFO] Generating schema        : Jooq.java
    [INFO] ----------------------------------------------------------
    [INFO] UDTs fetched             : 0 (0 included, 0 excluded)
    [INFO] Generating tables        
    [INFO] Synthetic primary keys   : 0 (0 included, 0 excluded)
    [INFO] Overriding primary keys  : 3 (0 included, 3 excluded)
    [INFO] Generating table         : Accounts.java [input=accounts, output=accounts, pk=accounts_pkey]
    [INFO] Embeddables fetched      : 0 (0 included, 0 excluded)
    [INFO] Indexes fetched          : 4 (4 included, 0 excluded)
    [INFO] Generating table         : FlywaySchemaHistory.java [input=flyway_schema_history, output=flyway_schema_history, pk=flyway_schema_history_pk]
    [INFO] Generating table         : Transactions.java [input=transactions, output=transactions, pk=transactions_pkey]
    [INFO] Tables generated         : Total: 565.474ms
    [INFO] Generating table references
    [INFO] Table refs generated     : Total: 567.482ms, +2.008ms
    [INFO] Generating Keys          
    [INFO] Keys generated           : Total: 569.667ms, +2.184ms
    [INFO] Generating Indexes       
    [INFO] Indexes generated        : Total: 571.302ms, +1.635ms
    [INFO] Generating table records 
    [INFO] Generating record        : AccountsRecord.java
    [INFO] Generating record        : FlywaySchemaHistoryRecord.java
    [INFO] Generating record        : TransactionsRecord.java
    [INFO] Table records generated  : Total: 588.816ms, +17.513ms
    [INFO] Domains fetched          : 0 (0 included, 0 excluded)
    [INFO] Generation finished: jooq: Total: 599.116ms, +10.3ms
    [INFO]                          
    [INFO] Removing excess files    
    [INFO] 
    [INFO] --- flyway-maven-plugin:6.0.7:migrate (default) @ jooq ---
    [INFO] Flyway Community Edition 6.0.7 by Redgate
    [INFO] Database: jdbc:postgresql://127.0.0.1:5432/mydb11 (PostgreSQL 12.0)
    [INFO] Successfully validated 2 migrations (execution time 00:00.011s)
    [INFO] Current version of schema "jooq": 1
    [INFO] Schema "jooq" is up to date. No migration necessary.
    [INFO] 
    [INFO] --- maven-resources-plugin:3.1.0:resources (default-resources) @ jooq ---
    [INFO] Using 'UTF-8' encoding to copy filtered resources.
    [INFO] Copying 2 resources
    [INFO] 
    [INFO] --- maven-compiler-plugin:3.8.1:compile (default-compile) @ jooq ---
    [INFO] Changes detected - recompiling the module!
    [INFO] Compiling 13 source files to F:\IdeaProjects\jooq\target\classes
    [INFO] /F:/IdeaProjects/jooq/src/main/java/com/zsx/filter/AccountIDFilter.java: F:\IdeaProjects\jooq\src\main\java\com\zsx\filter\AccountIDFilter.java使用或覆盖了已过时的 API。
    [INFO] /F:/IdeaProjects/jooq/src/main/java/com/zsx/filter/AccountIDFilter.java: 有关详细信息, 请使用 -Xlint:deprecation 重新编译。
    [INFO] ------------------------------------------------------------------------
    [INFO] BUILD SUCCESS
    [INFO] ------------------------------------------------------------------------
    [INFO] Total time:  3.638 s
    [INFO] Finished at: 2019-11-20T10:22:40+08:00
    [INFO] ------------------------------------------------------------------------

**通过jooq-codegen-maven插件运行**

E:\jdk\jdk-13.0.1\bin\java.exe -Dmaven.multiModuleProjectDirectory=F:\IdeaProjects\jooq -Dmaven.home=E:\maven\apache-maven-3.6.2 -Dclassworlds.conf=E:\maven\apache-maven-3.6.2\bin\m2.conf "-Dmaven.ext.class.path=E:\JetBrains\IntelliJ IDEA 2019.2.3\plugins\maven\lib\maven-event-listener.jar" "-javaagent:E:\JetBrains\IntelliJ IDEA 2019.2.3\lib\idea_rt.jar=54669:E:\JetBrains\IntelliJ IDEA 2019.2.3\bin" -Dfile.encoding=UTF-8 -classpath E:\maven\apache-maven-3.6.2\boot\plexus-classworlds-2.6.0.jar org.codehaus.classworlds.Launcher -Didea.version2019.2.4 -s E:\maven\apache-maven-3.6.2\conf\settings.xml org.jooq:jooq-codegen-maven:3.12.2:generate
    [INFO] Scanning for projects...
    [WARNING] 
    [WARNING] Some problems were encountered while building the effective model for com.zsx:jooq:jar:1.0-SNAPSHOT
    [WARNING] 'dependencies.dependency.scope' for org.springframework.boot:spring-boot-devtools:jar must be one of [provided, compile, runtime, test, system] but is 'true'. @ line 105, column 20
    [WARNING] 
    [WARNING] It is highly recommended to fix these problems because they threaten the stability of your build.
    [WARNING] 
    [WARNING] For this reason, future Maven versions might no longer support building such malformed projects.
    [WARNING] 
    [INFO] 
    [INFO] ----------------------------< com.zsx:jooq >----------------------------
    [INFO] Building jooq 1.0-SNAPSHOT
    [INFO] --------------------------------[ jar ]---------------------------------
    [INFO] 
    [INFO] --- jooq-codegen-maven:3.12.2:generate (default-cli) @ jooq ---
    [INFO] No <inputCatalog/> was provided. Generating ALL available catalogs instead.
    [INFO] License parameters       
    [INFO] ----------------------------------------------------------
    [INFO]   Thank you for using jOOQ and jOOQ's code generator
    [INFO]                          
    [INFO] Database parameters      
    [INFO] ----------------------------------------------------------
    [INFO]   dialect                : POSTGRES
    [INFO]   URL                    : jdbc:postgresql://127.0.0.1:5432/mydb11
    [INFO]   target dir             : F:\IdeaProjects\jooq\src\main\java
    [INFO]   target package         : com.zsx.generator.jooq
    [INFO]   includes               : [.*]
    [INFO]   excludes               : []
    [INFO]   includeExcludeColumns  : false
    [INFO] ----------------------------------------------------------
    [INFO]                          
    [INFO] JavaGenerator parameters 
    [INFO] ----------------------------------------------------------
    [INFO]   annotations (generated): true
    [INFO]   annotations (JPA: any) : false
    [INFO]   annotations (JPA: version): 
    [INFO]   annotations (validation): false
    [INFO]   comments               : true
    [INFO]   comments on attributes : true
    [INFO]   comments on catalogs   : true
    [INFO]   comments on columns    : true
    [INFO]   comments on keys       : true
    [INFO]   comments on links      : true
    [INFO]   comments on packages   : true
    [INFO]   comments on parameters : true
    [INFO]   comments on queues     : true
    [INFO]   comments on routines   : true
    [INFO]   comments on schemas    : true
    [INFO]   comments on sequences  : true
    [INFO]   comments on tables     : true
    [INFO]   comments on udts       : true
    [INFO]   daos                   : false
    [INFO]   deprecated code        : true
    [INFO]   global references (any): true
    [INFO]   global references (catalogs): true
    [INFO]   global references (keys): true
    [INFO]   global references (links): true
    [INFO]   global references (queues): true
    [INFO]   global references (routines): true
    [INFO]   global references (schemas): true
    [INFO]   global references (sequences): true
    [INFO]   global references (tables): true
    [INFO]   global references (udts): true
    [INFO]   indexes                : true
    [INFO]   instance fields        : true
    [INFO]   interfaces             : false
    [INFO]   interfaces (immutable) : false
    [INFO]   javadoc                : true
    [INFO]   keys                   : true
    [INFO]   links                  : true
    [INFO]   pojos                  : false
    [INFO]   pojos (immutable)      : false
    [INFO]   queues                 : true
    [INFO]   records                : true
    [INFO]   routines               : true
    [INFO]   sequences              : true
    [INFO]   table-valued functions : true
    [INFO]   tables                 : true
    [INFO]   udts                   : true
    [INFO]   relations              : true
    [INFO] ----------------------------------------------------------
    [INFO]                          
    [INFO] Generation remarks       
    [INFO] ----------------------------------------------------------
    [INFO]                          
    [INFO] ----------------------------------------------------------
    [INFO] Generating catalogs      : Total: 1
    WARNING: An illegal reflective access operation has occurred
    WARNING: Illegal reflective access by org.jooq.tools.reflect.Reflect (file:/E:/maven/repository/org/jooq/jooq/3.12.2/jooq-3.12.2.jar) to constructor java.lang.invoke.MethodHandles$Lookup(java.lang.Class)
    WARNING: Please consider reporting this to the maintainers of org.jooq.tools.reflect.Reflect
    WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
    WARNING: All illegal access operations will be denied in a future release
    [INFO] ARRAYs fetched           : 0 (0 included, 0 excluded)
    [INFO] Enums fetched            : 0 (0 included, 0 excluded)
    [INFO] Packages fetched         : 0 (0 included, 0 excluded)
    [INFO] Routines fetched         : 0 (0 included, 0 excluded)
    [INFO] Sequences fetched        : 0 (0 included, 0 excluded)
    [INFO] Tables fetched           : 3 (3 included, 0 excluded)
    [INFO] No schema version is applied for catalog . Regenerating.
    [INFO]                          
    [INFO] Generating catalog       : DefaultCatalog.java
    [INFO] ==========================================================
    [INFO] Generating schemata      : Total: 1
    [INFO] No schema version is applied for schema jooq. Regenerating.
    [INFO] Generating schema        : Jooq.java
    [INFO] ----------------------------------------------------------
    [INFO] UDTs fetched             : 0 (0 included, 0 excluded)
    [INFO] Generating tables        
    [INFO] Synthetic primary keys   : 0 (0 included, 0 excluded)
    [INFO] Overriding primary keys  : 3 (0 included, 3 excluded)
    [INFO] Generating table         : Accounts.java [input=accounts, output=accounts, pk=accounts_pkey]
    [INFO] Embeddables fetched      : 0 (0 included, 0 excluded)
    [INFO] Indexes fetched          : 4 (4 included, 0 excluded)
    [INFO] Generating table         : FlywaySchemaHistory.java [input=flyway_schema_history, output=flyway_schema_history, pk=flyway_schema_history_pk]
    [INFO] Generating table         : Transactions.java [input=transactions, output=transactions, pk=transactions_pkey]
    [INFO] Tables generated         : Total: 547.66ms
    [INFO] Generating table references
    [INFO] Table refs generated     : Total: 549.687ms, +2.027ms
    [INFO] Generating Keys          
    [INFO] Keys generated           : Total: 551.926ms, +2.238ms
    [INFO] Generating Indexes       
    [INFO] Indexes generated        : Total: 553.472ms, +1.546ms
    [INFO] Generating table records 
    [INFO] Generating record        : AccountsRecord.java
    [INFO] Generating record        : FlywaySchemaHistoryRecord.java
    [INFO] Generating record        : TransactionsRecord.java
    [INFO] Table records generated  : Total: 571.963ms, +18.491ms
    [INFO] Domains fetched          : 0 (0 included, 0 excluded)
    [INFO] Generation finished: jooq: Total: 582.197ms, +10.233ms
    [INFO]                          
    [INFO] Removing excess files    
    [INFO] ------------------------------------------------------------------------
    [INFO] BUILD SUCCESS
    [INFO] ------------------------------------------------------------------------
    [INFO] Total time:  1.597 s
    [INFO] Finished at: 2019-11-20T10:26:01+08:00
    [INFO] ------------------------------------------------------------------------

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191120100538343.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191120100843442.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz,size_16,color_FFFFFF,t_70
[20191120101532907.png]: https://img-blog.csdnimg.cn/20191120101532907.png