Note, if you find anything about this (or the manual) unclear, please tell me... It seems to me that this <inputSchema/> / <outputSchema/> stuff has been a source of confusion before.
2012/5/9 Lukas Eder <[email protected]>: > 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
