Thank you!!! Took me a while to figure this out and your post worked for me immediately
On Wednesday, April 9, 2014 at 12:01:15 PM UTC-4, Lukas Eder wrote: > > Hello Harmeet, > > The relevant error message reads: > > WARNING: *No schemata were loaded* : Please check your connection > settings, and whether your database (and your database version!) is really > supported by jOOQ. Also, check the case-sensitivity in your configured > <inputSchema/> elements : [public] > > And you're also trying to select the public schema as your inputSchema: > > <inputSchema>public</inputSchema> > > "public" is a schema typically available in H2, HSQLDB, and PostgreSQL > databases. By default, MySQL does not have such a schema. You should > replace that schema name by the one you're using, probably "jooq_test". > Another option is to remove that XML element and generate all schemas. > > Hope this helps, > Lukas > > 2014-04-09 16:59 GMT+02:00 Harmeet Singh <[email protected] > <javascript:>>: > >> Hello Friend, >> I am trying to generate code using maven with MySQL db, but my logs >> produce some messages : >> >> Apr 09, 2014 8:10:52 PM org.jooq.tools.JooqLogger info >> INFO: Emptying : >> D:\Workspace\JOOQ\jooq-samples\src\main\java\com\the13star\entities\com\the13star\entities >> Apr 09, 2014 8:10:52 PM org.jooq.tools.JooqLogger warn >> WARNING: No schemata were loaded : Please check your connection >> settings, and whether your database (and your database version!) is really >> supported by jOOQ. Also, check the case-sensitivity in your configured >> <inputSchema/> elements : [public] >> Apr 09, 2014 8:10:52 PM org.jooq.tools.JooqLogger info >> INFO: Generating schemata : Total: 0 >> >> My maven File as Follow : >> >> <plugin> >> >> <!-- Specify the maven code generator plugin --> >> <groupId>org.jooq</groupId> >> <artifactId>jooq-codegen-maven</artifactId> >> <version>3.3.1</version> >> <!-- The plugin should hook into the generate goal --> >> <executions> >> <execution> >> <goals> >> <goal>generate</goal> >> </goals> >> </execution> >> </executions> >> >> <dependencies> >> <dependency> >> <groupId>mysql</groupId> >> <artifactId>mysql-connector-java</artifactId> >> <version>5.1.30</version> >> </dependency> >> </dependencies> >> >> <!-- Specify the plugin configuration. The configuration format is the >> same as for the standalone code generator --> >> <configuration> >> <!-- JDBC connection parameters --> >> <jdbc> >> <driver>com.mysql.jdbc.Driver</driver> >> <url>jdbc:mysql://localhost/jooq_test</url> >> <user>root</user> >> <password>root</password> >> </jdbc> >> >> <!-- Generator parameters --> >> <generator> >> <name>org.jooq.util.DefaultGenerator</name> >> <database> >> <name>org.jooq.util.mysql.MySQLDatabase</name> >> <includes>.*</includes> >> <excludes></excludes> >> <inputSchema>public</inputSchema> >> </database> >> <target> >> <packageName>com.the13star.entities</packageName> >> <directory>src/main/java/com/the13star/entities</directory> >> </target> >> </generator> >> </configuration> >> </plugin> >> >> what is the problem is that . In my MySQL db, the jooq_test db is >> present and one table is there user_detail. So What i do ? >> >> -- >> 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.
