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?

0 votes

1 answers

1588 views

ANSWER



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.

0 votes



ron
Thanks.

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.

12/04/2012