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]>: > 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]. > 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.
