Hi,
I've got a problem where JOOQ is omitting some foreign key relationships.
When I call MyTable.getReferences() not all references are returned. I'm
using JOOQ 2.6.2
In the example below, the one for PLAN_ID is created in jooq, but the
SALES_LEAD_ID and INTERESTED references are not in JOOQ. Maybe they are
looking for PRIMARY_KEY in the index name?
JOOQ CODE
public
java.util.List<org.jooq.ForeignKey<au.com.greatlivinghomes.buildflow.data.jooq.tables.records.SalesLeadInterestedOtherRecord,
?>> getReferences() {
return
java.util.Arrays.<org.jooq.ForeignKey<au.com.greatlivinghomes.buildflow.data.jooq.tables.records.SalesLeadInterestedOtherRecord,
?>>asList(au.com.greatlivinghomes.buildflow.data.jooq.Keys.CONSTRAINT_FBD0);
}
In H2
CONSTRAINT_CATALOG
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
CONSTRAINT_SCHEMA
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
CONSTRAINT_NAME
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
CONSTRAINT_TYPE
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
TABLE_CATALOG
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
TABLE_SCHEMA
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
TABLE_NAME
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
UNIQUE_INDEX_NAME
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
CHECK_EXPRESSION
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
COLUMN_LIST
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
REMARKS
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
SQL
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
ID
<http://192.168.2.61:55205/query.do?jsessionid=69da5f337b663538036a8f28974b94ec#>
GLHBUILDFLOWPUBLICCONSTRAINT_FBREFERENTIALGLHBUILDFLOWPUBLIC
SALES_LEAD_INTERESTED_OTHERCONSTRAINT_4D8_INDEX_F*null*SALES_LEAD_IDALTER
TABLE PUBLIC.SALES_LEAD_INTERESTED_OTHER ADD CONSTRAINT
PUBLIC.CONSTRAINT_FB FOREIGN KEY(SALES_LEAD_ID) INDEX
PUBLIC.CONSTRAINT_FB_INDEX_7 REFERENCES PUBLIC.SALES_LEAD(SALES_LEAD_ID)
NOCHECK348GLHBUILDFLOWPUBLICCONSTRAINT_FBD0REFERENTIALGLHBUILDFLOWPUBLIC
SALES_LEAD_INTERESTED_OTHERPRIMARY_KEY_25*null*PLAN_IDALTER TABLE
PUBLIC.SALES_LEAD_INTERESTED_OTHER ADD CONSTRAINT PUBLIC.CONSTRAINT_FBD0
FOREIGN KEY(PLAN_ID) INDEX PUBLIC.CONSTRAINT_INDEX_F REFERENCES
PUBLIC.PLAN(PLAN_ID) NOCHECK73GLHBUILDFLOWPUBLICCONSTRAINT_FBDREFERENTIAL
GLHBUILDFLOWPUBLICSALES_LEAD_INTERESTED_OTHERCONSTRAINT_44_INDEX_6*null*
INTERESTEDALTER TABLE PUBLIC.SALES_LEAD_INTERESTED_OTHER ADD CONSTRAINT
PUBLIC.CONSTRAINT_FBD FOREIGN KEY(INTERESTED) INDEX
PUBLIC.CONSTRAINT_FBD_INDEX_7 REFERENCES
PUBLIC.VALUE_LIST_ITEM(VALUE_LIST_ITEM_ID) NOCHECK292GLHBUILDFLOWPUBLIC
CONSTRAINT_FPRIMARY KEYGLHBUILDFLOWPUBLICSALES_LEAD_INTERESTED_OTHER
PRIMARY_KEY_7E*null*SALES_LEAD_INTERESTED_OTHER_IDALTER TABLE
PUBLIC.SALES_LEAD_INTERESTED_OTHER ADD CONSTRAINT PUBLIC.CONSTRAINT_F
PRIMARY KEY(SALES_LEAD_INTERESTED_OTHER_ID) INDEX PUBLIC.PRIMARY_KEY_7E319(4
rows, 2 ms)
Any ideas of where the issue might be?. I'd rather use JOOQ references than
query the database every time, but it isn't reliable.
Thanks, Ryan
--
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.
