After this to post switching to the issue tracker. Two notes before
switching to the issue tracker.
The problem does seem to be case sensitivity but with the inputSchema
element and not the includes element.
<inputSchema>MNEMONICS</inputSchema>
Secondly:
My sample configuration did not faithfully replicate my actual
configuration.
Here is corrected configuration with the <inputSchema> element added which
faithfully replicates the NPE I'm seeing.
If I change <inputSchema>MNEMONICS</inputSchema> to <inputSchema>mnemonics
</inputSchema>
then I avoid the NPE but don't generate any tables.
Most importantly; If I remove the inputSchema element then I can
successfully generate my tables but get a few extra like
InformationSchema.java (which I suspect I could fix by updating the
excludes element ).
<?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>TEMPLATE_TYPE</includes>
<excludes>
UNUSED_TABLE # This table (unqualified name) should not be generated
| PREFIX_.* # Objects with a given prefix should not be generated
| SECRET_SCHEMA\.SECRET_TABLE # This table (qualified name) should
not be generated
| SECRET_ROUTINE # This routine (unqualified name) ...
</excludes>
<inputSchema>MNEMONICS</inputSchema>
</database>
<generate></generate>
<target>
<packageName>sample</packageName>
<directory>temp</directory>
</target>
</generator>
</configuration>
On Friday, April 22, 2016 at 2:48:05 AM UTC-4, Lukas Eder wrote:
>
> 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] <javascript:>>:
>
>> 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] <javascript:>>:
>>
>>> 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] <javascript:>.
>>> 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.
