Thank you very much for your report. I've noticed, you've reported this issue also on GitHub: https://github.com/jOOQ/jOOQ/issues/7323
I will reply directly there 2018-03-19 2:14 GMT+01:00 吕兵阳 <[email protected]>: > In the use of the latest jooq version, generate code error > Expected behavior and actual behavior: > > Configuration configuration = new Configuration() > .withJdbc(new Jdbc().withDriver("oracle.jdbc.driver.OracleDriver") > .withUser("HNMCC").withPassword("HNMCC").withUrl( > "jdbc:oracle:thin:localhost:3306:orcl")) > .withGenerator(new Generator() > .withDatabase(new Database() > .withIncludes("other_resource") > .withInputSchema("public")) > .withTarget(new Target() > .withPackageName("org.jooq.util.maven.example") > .withDirectory("target/generated-sources/jooq"))); > > try { > GenerationTool.generate(configuration); > } catch (Exception e) { > e.printStackTrace(); > } > > Steps to reproduce the problem: > > org.jooq.exception.DataAccessException: SQL [select 1 "one"]; ORA-00923: > 未找到要求的 FROM 关键字 > > at org.jooq_3.10.5.DEFAULT.debug(Unknown Source) ~[?:?] > at org.jooq.impl.Tools.translate(Tools.java:2239) ~[jooq-3.10.5.jar:?] > at > org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:704) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:361) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:317) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2597) ~[jooq-3.10.5.jar:?] > at org.jooq.util.AbstractDatabase$1.start(AbstractDatabase.java:264) > ~[jooq-meta-3.10.5.jar:?] > at org.jooq.impl.ExecuteListeners.start(ExecuteListeners.java:122) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.ExecuteListeners.<init>(ExecuteListeners.java:116) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.ExecuteListeners.get(ExecuteListeners.java:82) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:289) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:317) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:408) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2650) ~[jooq-3.10.5.jar:?] > at OracleDatabase.getSchemata0(OracleDatabase.java:299) ~[test-classes/:?] > at org.jooq.util.AbstractDatabase.getSchemata(AbstractDatabase.java:441) > ~[jooq-meta-3.10.5.jar:?] > at org.jooq.util.AbstractDatabase.getSchemata(AbstractDatabase.java:468) > ~[jooq-meta-3.10.5.jar:?] > at org.jooq.util.CatalogDefinition.getSchemata(CatalogDefinition.java:63) > ~[jooq-meta-3.10.5.jar:?] > at org.jooq.util.JavaGenerator.generateCatalogIfEmpty(JavaGenerator.java:345) > ~[jooq-codegen-3.10.0.jar:?] > at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:324) > ~[jooq-codegen-3.10.0.jar:?] > at org.jooq.util.GenerationTool.run(GenerationTool.java:639) > ~[jooq-codegen-3.10.0.jar:?] > at org.jooq.util.GenerationTool.generate(GenerationTool.java:200) > ~[jooq-codegen-3.10.0.jar:?] > at TestHnmccServer.test2(TestHnmccServer.java:43) ~[test-classes/:?] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_144] > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > ~[?:1.8.0_144] > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > ~[?:1.8.0_144] > at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_144] > at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) > ~[junit-4.12.jar:4.12] > at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > ~[junit-4.12.jar:4.12] > at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) > ~[junit-4.12.jar:4.12] > at > org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) > ~[junit-4.12.jar:4.12] > at > org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:73) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at > org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:83) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at > org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at > org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at > org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) > ~[junit-4.12.jar:4.12] > at > org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at > org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) > ~[junit-4.12.jar:4.12] > at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) > ~[junit-4.12.jar:4.12] > at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) > ~[junit-4.12.jar:4.12] > at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) > ~[junit-4.12.jar:4.12] > at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) > ~[junit-4.12.jar:4.12] > at > org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at > org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at org.junit.runners.ParentRunner.run(ParentRunner.java:363) > ~[junit-4.12.jar:4.12] > at > org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190) > ~[spring-test-5.0.4.RELEASE.jar:5.0.4.RELEASE] > at org.junit.runner.JUnitCore.run(JUnitCore.java:137) ~[junit-4.12.jar:4.12] > at > com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68) > ~[junit-rt.jar:?] > at > com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47) > ~[junit-rt.jar:?] > at > com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242) > ~[junit-rt.jar:?] > at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70) > ~[junit-rt.jar:?] > > Caused by: java.sql.SQLSyntaxErrorException: ORA-00923: 未找到要求的 FROM 关键字 > > at > oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at > oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at > oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374) > ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] > at > org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:3248) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:262) > ~[jooq-3.10.5.jar:?] > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:347) > ~[jooq-3.10.5.jar:?] > ... 49 more > > Versions: > > - jOOQ:3.10.5 > - Java:1.8 > - Database (include vendor):oracle11g > - OS:windows10 > - JDBC Driver (include name if inofficial driver):oracle.jdbc.driver. > OracleDriver > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
