topic How to control createTablePolicy of SQL tableReference that has a non-SQL sourceDirectory in Nuxeo Forum

How to control createTablePolicy of SQL tableReference that has a non-SQL sourceDirectory

ron_1 — Mon, 03 Dec 2012 20:45:55 GMT

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?

Re: How to control createTablePolicy of SQL tableReference that has a non-SQL sourceDirectory

Olivier_Grisel — Tue, 04 Dec 2012 11:28:45 GMT

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.

Re: How to control createTablePolicy of SQL tableReference that has a non-SQL sourceDirectory

ron_1 — Tue, 04 Dec 2012 15:20:48 GMT

Thanks.