Hello Sander,
This behaviour is due to #1312
https://sourceforge.net/apps/trac/jooq/ticket/1312
Since jOOQ 2.3.0, omitting the <inputSchema/> leads to generating the
whole available database. In that case, jOOQ will run something
similar to the following query:
select schema_name
from information_schema.schemata
Does the above return anything sensible on your database? Obviously,
you probably don't want to do that, so I guess the best fix for you is
to set the <inputSchema/> correctly as documented here:
http://www.jooq.org/manual/META/Configuration/
http://www.jooq.org/manual/META/AdvancedConfiguration/
By the way, the <inputSchema/> setting is not so new, see #958
introduced in jOOQ 2.0.0, November 2011:
https://sourceforge.net/apps/trac/jooq/ticket/958
Cheers
Lukas
2012/5/9 Sander Plas <[email protected]>:
> Jooq doesn't generate any code anymore since i upgraded to 2.3.0. For some
> reason it decides that there are 0 schemata. I tried this with the new
> "inputSchema" config, the old "schema" tag and without specifying any
> schemata.
>
> Any idea why this is happening?
>
> Maven output:
>
> ------------------------------------------------------------------------
> Building fm.yourmuze.site 1.0-SNAPSHOT
> ------------------------------------------------------------------------
>
> [clean:clean]
> Deleting /home/sander/NetBeansProjects/fm.yourmuze.site/target
>
> [jooq-codegen-maven:generate]
> Using this configuration:
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-2.3.0.xsd";>
> <jdbc>
> <driver>org.postgresql.Driver</driver>
>
> <url>jdbc:postgresql://yourmuze-fm.seeas.nl/yourmuze_fm?ssl&sslfactory=org.postgresql.ssl.NonValidatingFactory</url>
> <user>yourmuze_fm</user>
> <password>password</password>
> </jdbc>
> <generator>
> <name>org.jooq.util.DefaultGenerator</name>
> <database>
> <name>org.jooq.util.postgres.PostgresDatabase</name>
> <includes>.*</includes>
> <excludes></excludes>
> <dateAsTimestamp>false</dateAsTimestamp>
> <unsignedTypes>true</unsignedTypes>
> <inputSchema></inputSchema>
> <outputSchema></outputSchema>
> </database>
> <generate>
> <relations>true</relations>
> <navigationMethods>true</navigationMethods>
> <deprecated>false</deprecated>
> <instanceFields>true</instanceFields>
> <generatedAnnotation>true</generatedAnnotation>
> <records>true</records>
> <pojos>false</pojos>
> <jpaAnnotations>false</jpaAnnotations>
> <validationAnnotations>false</validationAnnotations>
> </generate>
> <target>
> <packageName>fm.yourmuze.site.db</packageName>
>
> <directory>/home/sander/NetBeansProjects/fm.yourmuze.site/target/generated-sources/jooq</directory>
> </target>
> </generator>
> </configuration>
>
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: No <inputSchema/> was provided. Generating ALL available schemata
> instead!
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: Database parameters
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: ----------------------------------------------------------
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: dialect : POSTGRES
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: target dir :
> /home/sander/NetBeansProjects/fm.yourmuze.site/target/generated-sources/jooq
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: target package : fm.yourmuze.site.db
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: ----------------------------------------------------------
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO:
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: Generation parameters
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: ----------------------------------------------------------
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: strategy : class
> org.jooq.util.DefaultGeneratorStrategy
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: deprecated : false
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: generated annotation : true
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: instance fields : true
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: JPA annotations : false
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: validation annotations : false
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: navigation methods : true
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: records : true
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: pojos : false
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: relations : true
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: ----------------------------------------------------------
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: Emptying :
> /home/sander/NetBeansProjects/fm.yourmuze.site/target/generated-sources/jooq/fm/yourmuze/site/db
> May 9, 2012 5:35:26 PM org.jooq.tools.JooqLogger info
> INFO: Generating schemata : Total: 0
