[dapriett]

Thanks for your reply. Could you explain exactly what each checkbox does on page 3 of the wizard:

Include referenced tables (A->B)
Include referencing tables (A<-B)

Generate support for ListedTable(fk)->UnlistedTable
Generate support for UnlistedTable(fk)->ListedTable

thanks,

Dan

[dapriett]

Also – another suggestion for the next release. You should include an option to specify the name of a sequence in the DB, for tables with use them as the ID generator.

[Brian Fernandes]

Dan,

Include referenced tables (A->B) 
Include referencing tables (A<-B) 

These two options will add more tables to the table list on page 3. If a table is not in this list, artifacts (POJOs, DAOs and Mapping files) will not be generated for that table.

Consider a table A which has a foreign key relationship with table B. Say you invoked RE by choosing table A from your schema; on page 3, you would see only table A and so artifacts for table A only would be generated. However, if you wish to include tables which A references in the generation process (B in this case), you can tick “Include referenced tables” and B will be added to the list ergo artifacts for B too will be generated.

Generate support for ListedTable(fk)->UnlistedTable
Generate support for UnlistedTable(fk)->ListedTable 

Consider the above case; if only table A is in the page 3 list, any relations that A has with other tables will not be included in the POJO and generated mapping files. However, if you tick “Generate support for ListedTable(fk)->UnlistedTable”, then the foreign key relationship that A shares with table B will be taken into account during generation, even though artifacts for B are not generated. If both A and B are in the list already, this option will have no effect and the relationship between A and B will be implicitly taken into account during generation.

Hope this helps – let us know if you require further clarification,
Best,
Brian

[Author]

Posts