I have also created an issue to track this: https://github.com/jOOQ/jOOQ/issues/5213
2016-04-22 8:45 GMT+02:00 Lukas Eder <[email protected]>: > Hi Brian, > > Thank you very much for bringing this to our attention. > > With NullPointerExceptions in libraies, user error is usually not to blame > indeed. This looks as though some issue is not handled properly at the > right spot, and later on, as it seems, the SchemaDefinition could not be > retrieved anymore inside of jOOQ meta. > > I believe this might be due to a case-sensitivity issue in MySQL / > MariaDB, where the meta query does return tables for the `TESTING` schema > (queried in upper case), but then cannot find the schema reference itself, > because the schema is really named `testing`. > > Can you confirm that you're using upper or lower case schema names here? > Does it work if you're putting lower case "testing" in that includes > reference? > > Best Regards, > Lukas > > 2016-04-21 22:29 GMT+02:00 <[email protected]>: > >> Pretty new to jooq but it looks like the error I'm seeing is an >> unsupported code generation against maria db version 10.1.13. >> I can try using the mariadb java client instead of mysql driver but I >> don't think it will make any difference. >> >> While this is not an issue for me (since I can easily switch to MySQL >> 5.5.8) I would like to confirm that user error is not too blame. >> >> thanks, >> Brian F. >> >> p.s. >> I can post more information if needed. >> >> >> <?xml version="1.0" encoding="UTF-8" standalone="yes"?> >> <configuration> >> <!-- Configure the database connection here --> >> <jdbc> >> <driver>com.mysql.jdbc.Driver</driver> >> <url>jdbc:mysql://localhost:3306</url> >> <user>sa</user> >> <password>fake</password> >> </jdbc> >> >> <generator> >> <database> >> <name>org.jooq.util.mariadb.MariaDBDatabase</name> >> <includes>TESTING</includes> >> </database> >> <generate> >> </generate> >> <target> >> <packageName>sample</packageName> >> <directory>/temp</directory> >> </target> >> </generator> >> </configuration> >> >> >> >> 2016-04-21T16:08:52,346 [main] INFO org.jooq.util.JavaGenerator - >> ---------------------------------------------------------- >> 2016-04-21T16:08:52,349 [main] INFO org.jooq.util.AbstractDatabase - >> Sequences fetched : 0 (0 included, 0 excluded) >> 2016-04-21T16:08:52,356 [main] ERROR org.jooq.util.AbstractDatabase - >> Error while fetching tables >> java.lang.NullPointerException >> at >> org.jooq.util.AbstractElementContainerDefinition.<init>(AbstractElementContainerDefinition.java:75) >> ~[jooq-meta-3.7.3.jar:?] >> at >> org.jooq.util.AbstractTableDefinition.<init>(AbstractTableDefinition.java:68) >> ~[jooq-meta-3.7.3.jar:?] >> at >> org.jooq.util.mysql.MySQLTableDefinition.<init>(MySQLTableDefinition.java:69) >> ~[jooq-meta-3.7.3.jar:?] >> at org.jooq.util.mysql.MySQLDatabase.getTables0(MySQLDatabase.java:247) >> ~[jooq-meta-3.7.3.jar:?] >> at org.jooq.util.AbstractDatabase.getTables(AbstractDatabase.java:730) >> [jooq-meta-3.7.3.jar:?] >> at org.jooq.util.JavaGenerator.generateSchema(JavaGenerator.java:3346) >> [jooq-codegen-3.7.3.jar:?] >> at org.jooq.util.JavaGenerator.generateSchema(JavaGenerator.java:3303) >> [jooq-codegen-3.7.3.jar:?] >> at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:301) >> [jooq-codegen-3.7.3.jar:?] >> at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:268) >> [jooq-codegen-3.7.3.jar:?] >> at org.jooq.util.GenerationTool.run(GenerationTool.java:434) >> [jooq-codegen-3.7.3.jar:?] >> at org.jooq.util.GenerationTool.generate(GenerationTool.java:180) >> [jooq-codegen-3.7.3.jar:?] >> at org.jooq.util.GenerationTool.main(GenerationTool.java:151) >> [jooq-codegen-3.7.3.jar:?] >> at >> com.proquest.pqd.canon.GenerateJooqFiles.main(GenerateJooqFiles.java:31) >> [test-classes/:?] >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> ~[?:1.8.0_31] >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> ~[?:1.8.0_31] >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> ~[?:1.8.0_31] >> at java.lang.reflect.Method.invoke(Method.java:483) ~[?:1.8.0_31] >> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144) >> [idea_rt.jar:?] >> >> >> >> >> -- >> 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.
