Are you following the tutorial? I realise that the tutorial / manual sample database schema has two foreign keys between BOOK and AUTHOR: AUTHOR_ID and CO_AUTHOR_ID. That makes using the onKey() method ambiguous, as it cannot know which foreign key it should prefer.
If you just want to see how onKey() works, I suggest dropping the CO_AUTHOR_ID column Best regards, Lukas 2014-09-29 8:18 GMT+02:00 <[email protected]>: > Hi Lukas > > When I set foriegn key in my database(Library) and use onkey() method , I > face this error " key ambiguous between tables library.author and > library.book " . What is reason the error? and How do I fix it? > > Thanks > > > -- > 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.
