java - 无法通过 SSL 连接使用 JOOQ 和 MySQL 数据库生成代码

Question

我正在尝试从通过 SSL 连接到的 MySQL 数据库生成代码。我从设置数据库的人那里得到了 3 个文件(client-cert.pem、client-key.pem、ca-cert.pem)

要用 Java 连接到数据库，我首先必须解决证书的另一个问题。在http://bugs.mysql.com/bug.php?id=68957的帮助下以及来自[2013 年 4 月 17 日 9:04] Alexander Soklakov 的回答，我设法让 JDBC 连接在我的 Java 代码中按预期工作。

但是现在我不知道在JOOQs library.xml 中配置SSL 的位置。我在哪里提供 *.pem 文件？或者我创建的信任和 keystore ？没有配置 SSL 我得到

Jun 11, 2014 1:53:40 PM org.jooq.tools.JooqLogger info
Information: Initialising properties  : ./library.xml
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

javax.net.ssl.SSLException
MESSAGE: Unsupported record version Unknown-0.0

STACKTRACE:

javax.net.ssl.SSLException: Unsupported record version Unknown-0.0
    at sun.security.ssl.InputRecord.readV3Record(Unknown Source)
    at sun.security.ssl.InputRecord.read(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:72)
    at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4237)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1222)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.jooq.util.GenerationTool.run(GenerationTool.java:206)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:173)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:160)


** END NESTED EXCEPTION **



Last packet sent to the server was 396 ms ago.
    at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:87)
    at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4237)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1222)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.jooq.util.GenerationTool.run(GenerationTool.java:206)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:173)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:160)
Jun 11, 2014 1:53:41 PM org.jooq.tools.JooqLogger error
Schwerwiegend: Cannot read ./library.xml. Error : Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

javax.net.ssl.SSLException
MESSAGE: Unsupported record version Unknown-0.0

STACKTRACE:

javax.net.ssl.SSLException: Unsupported record version Unknown-0.0
    at sun.security.ssl.InputRecord.readV3Record(Unknown Source)
    at sun.security.ssl.InputRecord.read(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:72)
    at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4237)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1222)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.jooq.util.GenerationTool.run(GenerationTool.java:206)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:173)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:160)


** END NESTED EXCEPTION **



Last packet sent to the server was 396 ms ago.
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

javax.net.ssl.SSLException
MESSAGE: Unsupported record version Unknown-0.0

STACKTRACE:

javax.net.ssl.SSLException: Unsupported record version Unknown-0.0
    at sun.security.ssl.InputRecord.readV3Record(Unknown Source)
    at sun.security.ssl.InputRecord.read(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:72)
    at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4237)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1222)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.jooq.util.GenerationTool.run(GenerationTool.java:206)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:173)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:160)


** END NESTED EXCEPTION **



Last packet sent to the server was 396 ms ago.
    at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:87)
    at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4237)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1222)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.jooq.util.GenerationTool.run(GenerationTool.java:206)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:173)
    at org.jooq.util.GenerationTool.main(GenerationTool.java:160)
Jun 11, 2014 1:53:41 PM org.jooq.tools.JooqLogger error
Schwerwiegend: Usage : GenerationTool <configuration-file>

我的图书馆.xml:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-2.5.0.xsd">
  <!-- Configure the database connection here -->
  <jdbc>
    <driver>com.mysql.jdbc.Driver</driver>
    <url>jdbc:mysql://server:3306/dbname?useSSL=true&amp;requireSSL=true&amp;verifyServerCertificate=false;</url>
    <user>user</user>
    <password>pass</password>
  </jdbc>

  <generator>
    <!-- The default code generator. You can override this one, to generate your own code style
         Defaults to org.jooq.util.DefaultGenerator -->
    <name>org.jooq.util.DefaultGenerator</name>

    <database>
      <!-- The database type. The format here is:
           org.util.[database].[database]Database -->
      <name>org.jooq.util.mysql.MySQLDatabase</name>

      <!-- The database schema (or in the absence of schema support, in your RDBMS this
           can be the owner, user, database name) to be generated -->
      <inputSchema>dbname</inputSchema>

      <!-- All elements that are generated from your schema (several Java regular expressions, separated by comma)
           Watch out for case-sensitivity. Depending on your database, this might be important! -->
      <includes>smv_.*</includes>

      <!-- All elements that are excluded from your schema (several Java regular expressions, separated by comma).
              Excludes match before includes -->
      <excludes></excludes>
    </database>

    <target>
      <!-- The destination package of your generated classes (within the destination directory) -->
      <packageName>my.package</packageName>

      <!-- The destination directory of your generated classes -->
      <directory>./src</directory>
    </target>
  </generator>
</configuration>

当我查看 http://www.jooq.org/xsd/jooq-codegen-2.5.0.xsd 下的模式时，我也找不到任何提示。

现在看来我不得不放弃使用 JOOQ :(

编辑:我使用 Eclipse 生成 JOOQ 代码，如以下解释:http://www.jooq.org/doc/3.0/manual/code-generation/codegen-configuration/在“从 Eclipse 运行代码生成”下。

Answer 1

如果您需要一种更特殊的方式来设置您的数据库连接，正确的方法可能是使用编程代码生成配置。这记录在这里:

http://www.jooq.org/doc/latest/manual/code-generation/codegen-programmatic/

我们(不幸的是)还没有明确记录这一点，但您可以通过调用 setConnection()

将 JDBC 连接显式传递给 GenerationTool