I did this first. <syntheticPrimaryKeys>public\.PersonEmail\.(personId|contactTypeId)</ syntheticPrimaryKeys>
But that didn't work. Hence looked at the example again and thought perhaps I've to specify the column index instead i.e. COLUMN(1|3). That didn't work too. Then I tried <overridePrimaryKeys>PersonEmail_personId_contactTypeId_key</overridePrimaryKeys> which did not work either. Well now I'm able to generate the DAO with the above configurations. The only reasoning I can think of why it was not working earlier might have to do with a stale version of the configuration file being picked up from the "resource" folder, which is automatically copied to the class path by maven. I ran the "clean" task yesterday, for other reasons, and that may have inadvertently solved the issue after I retried since your reply. Thank you so much for your help and guidance. I'll definitely look into the composite primary key suggestion. -- 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.
