Thanks Lukas, that appears to solve the situation. I just need to work out how to get it into the schema automatically as it's generated from a vertabelo export, but that's a whole other issue.
On Friday, June 17, 2016 at 8:27:55 AM UTC+1, Lukas Eder wrote: > > Hi Simon, > > Thank you very much for your enquiry. Your sequence has to be in a schema, > probably in public. I suspect that will solve the issue for you: > > <sequence> > <sequence_schema>public</sequence_schema> > <sequence_name>ticket_id_seq</sequence_name> > <data_type>BIGINT</data_type> > </sequence> > > Hope this helps, > Lukas > > 2016-06-16 14:28 GMT+01:00 Simon Williams <[email protected] > <javascript:>>: > >> Hi, >> >> I have a sequence in my database, but it's not getting created by the >> jooq generator? but all my tables and keys are generated fine? >> >> I'm using Jooq 3.5.0 >> >> The schema.xml contains this: >> >> <sequence> >> <sequence_schema/> >> <sequence_name>ticket_id_seq</sequence_name> >> <data_type>BIGINT</data_type> >> </sequence> >> >> >> and my pom.xml has: >> >> <plugin> >> <groupId>org.jooq</groupId> >> <artifactId>jooq-codegen-maven</artifactId> >> <executions> >> <execution> >> <id>generate-postgres</id> >> <phase>generate-sources</phase> >> <goals> >> <goal>generate</goal> >> </goals> >> <configuration> >> <generator> >> <name>org.jooq.util.DefaultGenerator</name> >> <database> >> <name>org.jooq.util.xml.XMLDatabase</name> >> <properties> >> <property> >> <key>dialect</key> >> <value>POSTGRES</value> >> </property> >> <property> >> <key>xml-file</key> >> <value> >> >> ${basedir}/target/generated-resources/xml/xslt/jooq-schema.xml >> </value> >> </property> >> </properties> >> <inputSchema>public</inputSchema> >> </database> >> <generate> >> <deprecated>false</deprecated> >> <instanceFields>true</instanceFields> >> <pojos>true</pojos> >> <pojosEqualsAndHashCode>true</pojosEqualsAndHashCode> >> <validationAnnotations>true</validationAnnotations> >> </generate> >> <target> >> <packageName>my.datastore.generated</packageName> >> >> <directory>target/generated-sources/jooq-postgres</directory> >> </target> >> </generator> >> </configuration> >> </execution> >> </executions> >> </plugin> >> >> >> any thoughts? >> >> Thanks in advance, >> >> Simon >> >> -- >> 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.
