This question concerns rc2 and the brand-new "bulk insert" function. What I need is to insert new entries into a table that has two foreign keys. What I cannot figure out after hours of searching here and elsewhere is how to represent the foreign-key fields in the HQL query. In the config file, here's an example of how one of the keys is defined:

<many-to-one name="employee" column="fk_employee_id" class="Employee" not-null="true" />

But in the INSERT ... SELECT HQL statement, trying to represent that entity in the value list preceding the select statement has been impossible thus far. I've tried: employee, fk_employee_id, employee.id and employee.employeeId with no joy.

I have tracked down what docs exist on this, but the example given did not address this issue.

Thanks for your time,
Steve