Hi Ravi,
> 1. I'm getting compile errors like :
>
> public class IdTable extends
> org.jooq.impl.UpdatableTableImpl<org.jooq.Record> {
> type parameter org.jooq.Record is not within its bound
>
> These go away if I generate record classes.
That is a known issue:
https://sourceforge.net/apps/trac/jooq/ticket/1248
It was fixed in jOOQ 2.2.0
> 2. I've ensured that foreign keys are defined in the db but turning on
> navigationMethods has no effect. I'd assume that the methods will be present
> in the pojo/record classes and return an Object/Collection?
Navigation methods are only generated in Record classes, not POJOs.
> a) if a person table has a house_id that has a foreign key that references
> the primary key id of the house table, should I see a method like getHouse()
> on the Person record/pojo class?
Yes, there should be these two methods:
HouseRecord PersonRecord.fetchHouse()
List<PersonRecord> HouseRecord.fetchPersonList();
> b) If instead the house table has a person_id column that references primary
> key of person table, should I see a getHouses() method on Person
> record/pojo?
You should then get
List<HouseRecord> PersonRecord.fetchHouseList()
PersonRecord HouseRecord.fetchPerson();
Can you provide me with the DDL for your "person" and "house" tables
(including constraints), to see what's going on? What database are you
doing this on?
Cheers
Lukas
