与ojdbc一起使用jooq sbt-plugin

Question

我在用jOOQ。使用jooq-sbt-plugin config (这里)解决问题会导致类路径问题，我认为这个问题与原来的问题是分开的。我设法使配置正常工作，但试图让它使用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-连接器-java“%5.1.22% "jooq”

你在上面的节选中遗漏了Dependencies.two，但也许你忽略了这一点。