Jooq和Spring boot:通过starter升级了JOOQ :无法将spring.jooq.sql-方言绑定到org.jooq.SQLDialect

Question

因此，我将spring-boot-parent-starter升级到2.2.8.RELEASE，结果是jooq 3.12.4。之前我的版本是3.11.5。

我收到以下错误

Failed to bind properties under 'spring.jooq.sql-dialect' to org.jooq.SQLDialect:

Property: spring.jooq.sqldialect
Value: MYSQL_5_7
Origin: "spring.jooq.SQLDialect" from property source "applicationConfig: [classpath:/config/application.yaml]"
Reason: failed to convert java.lang.String to org.jooq.SQLDialect

这是我以前的application.yaml

spring:
  jooq:
    sql-dialect: mysql_5_7

Answer 1

如果您阅读了整个错误消息，您将看到以下内容：

Failed to bind properties under 'spring.jooq.sql-dialect' to org.jooq.SQLDialect:

    Property: spring.jooq.sql-dialect
    Value: MYSQL_5_7
    Origin: class path resource [application.properties]:2:25
    Reason: failed to convert java.lang.String to org.jooq.SQLDialect

Action:

Update your application's configuration. The following values are valid:

    CUBRID
    DEFAULT
    DERBY
    FIREBIRD
    H2
    HSQLDB
    MARIADB
    MYSQL
    POSTGRES
    SQL99
    SQLITE

MYSQL_5_7不是jOOQ开源软件支持的值。它只在专业版中可用

MYSQL_5_7
@Pro
public static final SQLDialect MYSQL_5_7
The MySQL 5.7 dialect.
This dialect is available in commercial jOOQ distributions, only.