将jooq-sbt插件与ojdbc一起使用

Question

我正在使用jOOQ。使用jooq-sbt-plugin配置（此处）解决问题会导致类路径问题，我认为该问题与原始问题不同。我设法使配置正常工作，但尝试使用Oracle驱动程序似乎是不可能的。

这里的问题是，插件似乎运行自己的java进程，因此所需的类路径（其中包含odbc14.jar）永远不会传递。有什么方法可以让插件工作吗？我不知道如何注入插件的类路径。

我唯一能想到的解决方法是定义一个任务（此处描述：https://gist.github.com/chris-martin/5140754)。

非常感谢您的帮助。谢谢

2013-09-10更新

这是配置：

import sbt._
import Keys._
import JOOQPlugin._
object SampleBuild extends Build {
    lazy val all = Project(id = "all", base = file("."), settings = defaultSettings) aggregate(
      one, two
    )
    lazy val one = Project(
        id = "one",
        base = file("one"),
        settings = defaultSettings ++ Seq(
            libraryDependencies ++= Dependencies.one
        )
    )
    lazy val two = Project(
        id = "two",
        base = file("two"),
        settings = defaultSettings ++ jooqSettings ++ customJooqSettings ++  Seq(
            libraryDependencies ++= Dependencies.two
        )
    ) dependsOn (one)
    override lazy val settings = super.settings ++ buildSettings
    lazy val buildSettings = Seq(
        organization := "org.sample",
        version      := "0.1-SNAPSHOT",
        scalaVersion := "2.10.2"
    )
    lazy val defaultSettings = Defaults.defaultSettings ++ Seq(
        scalacOptions in Compile ++= scalacParams,
        externalResolvers in Compile := Resolvers.commonResolvers,
        shellPrompt  := ShellPrompt.buildShellPrompt,
        resolvers ++= Resolvers.commonResolvers
    )
    lazy val customJooqSettings = Seq(
        jooqOptions := jooqBvpOptions,
        jooqOutputDirectory := new java.io.File("../src/appdb/src/main/java")
        )
    lazy val jooqBvpOptions = Seq(
        "jdbc.driver"                    -> "oracle.jdbc.OracleDriver",
        "jdbc.url"                       -> "jdbc:oracle:thin:@//<some server>",
        "jdbc.user"                      -> "<some user>",
        "jdbc.password"                  -> "<some pwd>",
        "generator.database.name"        -> "org.jooq.util.oracle.OracleDatabase",
        "generator.database.inputSchema" -> "<some schema>",
        "generator.database.includes"    -> "table1|table2|table3",
        "generator.target.packageName"   -> "org.example.generated")
}
object Resolvers { /* ... */ }
object Dependencies { /* ... */ }
object ShellPrompt { /* ... */ }

这是一个错误：

[info] Initialising properties  : /jooq-config2705409947508036761.xml
[error] Cannot read /jooq-config2705409947508036761.xml. Error : oracle.jdbc.OracleDriver
[error] java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
[error]     at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
[error]     at java.security.AccessController.doPrivileged(Native Method)
[error]     at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
[error]     at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
[error]     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
[error]     at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
[error]     at java.lang.Class.forName0(Native Method)
[error]     at java.lang.Class.forName(Class.java:171)
[error]     at org.jooq.util.GenerationTool.main(GenerationTool.java:269)
[error]     at org.jooq.util.GenerationTool.main(GenerationTool.java:123)
[error] Usage : GenerationTool <configuration-file>
[trace] Stack trace suppressed: run last appdb-tool/jooq:codegen for the full output.
[error] (appdb-tool/jooq:codegen) Failed with return code: 255
[error] Total time: 1 s, completed Sep 10, 2013 1:45:24 PM

Answer 1

jooq sbt插件的自述文件说：

• 将您的数据库驱动程序添加到具有"jooq"作用域的libraryDependencies列表中：

  libraryDependencies += "mysql" % "mysql-connector-java" % "5.1.22" % "jooq"
  

您在上面的摘录中遗漏了Dependencies.two，但也许您遗漏了它。