upgraded to jOOQ 3.6.3 - seeing Invalid object name 'INFORMATION_SCHEMA.SEQUENCES' error

[Alex Tolompoiko]

Hi, we updated our jOOQ jar to latest 3.6.3 version and now seeing an error when generating code, using the same config.  Not sure if this is a regression or something else:

-----------------------------------

Sep 24, 2015 4:53:55 PM org.jooq.tools.JooqLogger warn

WARNING: SQL exception            : Exception while executing meta query: Invalid object name 'INFORMATION_SCHEMA.SEQUENCES'.

Please report this bug here: https://github.com/jOOQ/jOOQ/issues/new

select count(*)

from [INFORMATION_SCHEMA].[SEQUENCES]

Sep 24, 2015 4:53:55 PM org.jooq.tools.JooqLogger info

INFO: Sequences fetched        : 0 (0 included, 0 excluded)

Sep 24, 2015 4:53:55 PM org.jooq.tools.JooqLogger info

INFO: Tables fetched           : 24 (24 included, 0 excluded)

Sep 24, 2015 4:53:55 PM org.jooq.tools.JooqLogger info

INFO: UDTs fetched             : 0 (0 included, 0 excluded)

org.jooq.util.GeneratorException: Error generating code for schema dbo

at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:268)

at org.jooq.util.GenerationTool.run(GenerationTool.java:426)

at org.jooq.util.GenerationTool.generate(GenerationTool.java:176)

at org.jooq.util.GenerationTool.main(GenerationTool.java:151)

Caused by: java.util.regex.PatternSyntaxException: Illegal/unsupported escape sequence near index 9

(?s:^.*?\Rpackage\s+(.*?);?\R.*?$)

         ^

at java.util.regex.Pattern.error(Pattern.java:1924)

at java.util.regex.Pattern.escape(Pattern.java:2416)

at java.util.regex.Pattern.atom(Pattern.java:2164)

at java.util.regex.Pattern.sequence(Pattern.java:2046)

at java.util.regex.Pattern.expr(Pattern.java:1964)

at java.util.regex.Pattern.group0(Pattern.java:2847)

at java.util.regex.Pattern.sequence(Pattern.java:2018)

at java.util.regex.Pattern.expr(Pattern.java:1964)

at java.util.regex.Pattern.compile(Pattern.java:1665)

at java.util.regex.Pattern.<init>(Pattern.java:1337)

at java.util.regex.Pattern.compile(Pattern.java:1022)

at org.jooq.util.JavaWriter.beforeClose(JavaWriter.java:121)

at org.jooq.util.GeneratorWriter.close(GeneratorWriter.java:237)

at org.jooq.util.JavaGenerator.generateSchema(JavaGenerator.java:3131)

at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:298)

at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:265)

... 3 more

Sep 24, 2015 4:53:55 PM org.jooq.tools.JooqLogger error

SEVERE: Cannot read config.xml. Error : Error generating code for schema dbo

org.jooq.util.GeneratorException: Error generating code for schema dbo

at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:268)

at org.jooq.util.GenerationTool.run(GenerationTool.java:426)

at org.jooq.util.GenerationTool.generate(GenerationTool.java:176)

at org.jooq.util.GenerationTool.main(GenerationTool.java:151)

Caused by: java.util.regex.PatternSyntaxException: Illegal/unsupported escape sequence near index 9

(?s:^.*?\Rpackage\s+(.*?);?\R.*?$)

         ^

at java.util.regex.Pattern.error(Pattern.java:1924)

at java.util.regex.Pattern.escape(Pattern.java:2416)

at java.util.regex.Pattern.atom(Pattern.java:2164)

at java.util.regex.Pattern.sequence(Pattern.java:2046)

at java.util.regex.Pattern.expr(Pattern.java:1964)

at java.util.regex.Pattern.group0(Pattern.java:2847)

at java.util.regex.Pattern.sequence(Pattern.java:2018)

at java.util.regex.Pattern.expr(Pattern.java:1964)

at java.util.regex.Pattern.compile(Pattern.java:1665)

at java.util.regex.Pattern.<init>(Pattern.java:1337)

at java.util.regex.Pattern.compile(Pattern.java:1022)

at org.jooq.util.JavaWriter.beforeClose(JavaWriter.java:121)

at org.jooq.util.GeneratorWriter.close(GeneratorWriter.java:237)

at org.jooq.util.JavaGenerator.generateSchema(JavaGenerator.java:3131)

at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:298)

at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:265)

... 3 more

Sep 24, 2015 4:53:55 PM org.jooq.tools.JooqLogger error

SEVERE: Usage : GenerationTool <configuration-file> 

[Lukas Eder]

Thanks for reporting. This is indeed a regression introduced in jOOQ 3.6.3, which makes the code generator unusable with Java versions less than 8. We will immediately fix this and ship a new patch release for 3.6. The relevant issue on GitHub is:

https://github.com/jOOQ/jOOQ/issues/4576

Best Regards,

Lukas

--
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 jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.