How to control createTablePolicy of SQL tableReference that has a non-SQL sourceDirectory
I have a SQLDirectory with a tableReference whose sourceDirectory is a MultiDirectory. I want to supply my own dataFile to populate the tableReference. How can I specify the createTablePolicy for the tableReference so that it will load the data in my datafile?
You can invert the relationship between the source multi and the target sql directories:
Put the TableReference
to resolve the field of the SQLDirectory and put and InverseReference
to resolve the field of the multi. That way the table reference should be initializable with the SQLSession of the SQLDirectory and hence it's dataFile
attribute should be taken into account.
In the group2group table, is the childGroupId intended to store the group name and the parentGroupId the subgroup name? This is what I'm seeing but seems counter-intuitive. I'm wondering if I have my reference/inverse reference backwards.