Yes, I can confirm it was this issue, I had several constraints on the same column. I upgraded to 3.1 and gave up navigation methods ;)
Thanks for your help ! Cheers, Julien 2013/7/2 Lukas Eder <[email protected]> > Hmm, I still cannot reproduce this issue, also with jOOQ 2.6.4. > > Did you include the complete, relevant DDL? Or are there any other > constraints (unique keys, foreign keys) involved with the STEP table? Note, > there was a fix in jOOQ 3.0.0 related to multiple foreign key constraints > defined on a single column: > https://github.com/jOOQ/jOOQ/issues/2025 > > > 2013/7/1 Julien Nicoulaud <[email protected]> > >> Using jOOQ 2.6.4 (can't upgrade, at least for now). >> >> The two tickets are: >> - #64: Code generation fails when foreign key references a unique key >> that is not the primary key >> - #69: Implement referential code generation for foreign keys that >> reference non-primary unique keys (closed without commits) >> >> It seems similar to my case, but not exactly the same, since I'm >> referencing a primary key... >> >> Julien >> >> >> 2013/7/1 Lukas Eder <[email protected]> >> >>> Hello, >>> >>> What jOOQ version are you using for this? I cannot reproduce these >>> warnings with your DDL with jOOQ 3.1. >>> The Trac tickets were merged into GitHub using the same ticket IDs >>> >>> Cheers >>> Lukas >>> >>> >>> 2013/7/1 Julien Nicoulaud <[email protected]> >>> >>>> Hi all, >>>> >>>> I have a table that looks like this (using H2): >>>> >>>> CREATE TABLE IF NOT EXISTS STEP ( >>>> >>>> DB_ID IDENTITY AUTO_INCREMENT NOT NULL PRIMARY KEY, >>>> >>>> PARENT BIGINT, >>>> >>>> CONSTRAINT STEP_PARENT_FK FOREIGN KEY (PARENT) REFERENCES STEP >>>> (DB_ID), >>>> >>>> ); >>>> >>>> >>>> jOOQ codegen fails at generating code, with the following message: >>>> >>>> [WARN ] Foreign key mismatch : STEP_PARENT_FK does not match >>>> its primary key! No code is generated for this key. See trac tickets #64 >>>> and #69 >>>> [WARN ] Foreign key mismatch : STEP_PARENT_FK does not match >>>> its primary key! No code is generated for this key. See trac tickets #64 >>>> and #69 >>>> >>>> It works fine for every other foreign key I have in the schema, that >>>> reference other tables. Am I missing something obvious ? I can't find trace >>>> of these tickets, jOOQ Trac seems to be closed. >>>> >>>> Regards, >>>> Julien >>>> >>>> -- >>>> 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/groups/opt_out. >>>> >>>> >>>> >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "jOOQ User Group" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/jooq-user/fLMQ8UWxtt4/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> -- >> 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/groups/opt_out. >> >> >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "jOOQ User Group" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/jooq-user/fLMQ8UWxtt4/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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/groups/opt_out.
