For the record, and for future visitors of this thread, this question was also asked on Stack Overflow: http://stackoverflow.com/q/26239396/521799
2014-10-07 19:41 GMT+02:00 Tarcisio A. <[email protected]>: > no problem, thanks for directing me to the tutorials and sorry again > No worries, we're here to help :-) > i read all but its no generating the classes that i need.... > > the part of the pom.xml > > <plugin> >> <!-- Specify the maven code generator plugin --> >> <groupId>org.jooq</groupId> >> <artifactId>jooq-codegen-maven</artifactId> >> <version>3.4.2</version> >> <!-- The plugin should hook into the generate goal --> >> <executions> >> <execution> >> <goals> >> <goal>generate</goal> >> </goals> >> </execution> >> </executions> >> <!-- Manage the plugin's dependency. In this example, we'll use a >> PostgreSQL database --> >> <dependencies> >> <!-- SQLite JDBC Driver --> >> <dependency> >> <groupId>org.xerial</groupId> >> <artifactId>sqlite-jdbc</artifactId> >> <version>3.7.2</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>org.sqlite.JDBC</driver> >> <url>jdbc:sqlite:F:\\BAIXA\\ATOS DOS >> GRUPOS\\bancodedados\\bdCertidoes.db</url> >> <user></user> >> <password></password> >> </jdbc> >> <!-- Generator parameters --> >> <generator> >> <name>org.jooq.util.DefaultGenerator</name> >> <database> >> <name>org.jooq.util.sqlite.SQLiteDatabase</name> >> <includes>.*</includes> >> <excludes></excludes> >> <inputSchema>public</inputSchema> <- remove this line >> </database> >> <target> >> <packageName>org.jooq.util.maven.example</packageName> >> <directory>target/generated-sources/jooq</directory> >> </target> >> </generator> >> </configuration> >> </plugin> > > > > > the """error"""": > > > [INFO] > [INFO] --- jooq-codegen-maven:3.4.2:generate (default) @ > cartorio.projeto.superpom --- > [INFO] Using this configuration: > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.4.0.xsd";> > <jdbc> > <driver>org.sqlite.JDBC</driver> > <url>jdbc:sqlite:F:\\BAIXA\\ATOS DOS > GRUPOS\\bancodedados\\bdCertidoes.db</url> > </jdbc> > <generator> > <name>org.jooq.util.DefaultGenerator</name> > <database> > <name>org.jooq.util.sqlite.SQLiteDatabase</name> > <includes>.*</includes> > <excludes></excludes> > <includeExcludeColumns>false</includeExcludeColumns> > <recordVersionFields></recordVersionFields> > <recordTimestampFields></recordTimestampFields> > <syntheticPrimaryKeys></syntheticPrimaryKeys> > <overridePrimaryKeys></overridePrimaryKeys> > <dateAsTimestamp>false</dateAsTimestamp> > <unsignedTypes>true</unsignedTypes> > <inputSchema>public</inputSchema> > <outputSchemaToDefault>false</outputSchemaToDefault> > </database> > <target> > <packageName>org.jooq.util.generated</packageName> > > <directory>C:\Users\cartorio\Documents\Java\Projetos\JavaDESKTOP\cartorio.atos.dos.grupos\target/generated-sources/jooq</directory> > </target> > </generator> > </configuration> > > [INFO] License parameters >> [INFO] ---------------------------------------------------------- >> [INFO] Thank you for using jOOQ and jOOQ's code generator >> [INFO] >> [INFO] Database parameters >> [INFO] ---------------------------------------------------------- >> [INFO] dialect : SQLITE >> [INFO] URL : jdbc:sqlite:F:\\BAIXA\\ATOS DOS >> GRUPOS\\bancodedados\\bdCertidoes.db >> [INFO] target dir : >> C:\Users\cartorio\Documents\Java\Projetos\JavaDESKTOP\cartorio.atos.dos.grupos\target/generated-sources/jooq >> [INFO] target package : org.jooq.util.generated >> [INFO] includes : [.*] >> [INFO] excludes : [] >> [INFO] includeExcludeColumns : false >> [INFO] ---------------------------------------------------------- >> [INFO] >> [INFO] DefaultGenerator parameters >> [INFO] ---------------------------------------------------------- >> [INFO] strategy : class >> org.jooq.util.DefaultGeneratorStrategy >> [INFO] deprecated : true >> [INFO] generated annotation : true >> [INFO] JPA annotations : false >> [INFO] validation annotations : false >> [INFO] instance fields : true >> [INFO] records : true >> [INFO] pojos : false >> [INFO] immutable pojos : false >> [INFO] interfaces : false >> [INFO] daos : false >> [INFO] relations : true >> [INFO] global references : true >> [INFO] ---------------------------------------------------------- >> [INFO] >> [INFO] Generation remarks >> [INFO] ---------------------------------------------------------- >> [INFO] none >> [INFO] >> [INFO] ---------------------------------------------------------- >> [INFO] Emptying : >> C:\Users\cartorio\Documents\Java\Projetos\JavaDESKTOP\cartorio.atos.dos.grupos\target\generated-sources\jooq\org\jooq\util\generated >> [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] >> [INFO] Generating schemata : Total: 0 > > > > > its correcty or i lost another point in the tutorial? :'( > Don't give up! :-) > i tried with and without <inputSchema>jooq_test</inputSchema>, > The inputSchema specifies the schema name as it is defined in your database. SQLite, however, does not have any schemas, so you should remove that <inputSchema/> element from your configuration. The rest looks OK to me - please ensure that your db file really contains a database, too (possible typo in the file path?) Best Regards, Lukas -- 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.
