Data Model:
----SOLDIER----
soldierId pk

-----ADDRESS-----
addressId pk
soldierId fk

A soldier can have one-to-many addresses. I'm trying to insert a soldier that has a collection of addresses. My soldierId fk is not being populated in the POJO and is failing on insert for that reason. Anyone see a reason this isn't working???


Hibernate version: 3. 2.3

Mapping documents:
<class name=x>
<properties..../>
<set name="addresses" lazy="false" cascade="save-update" inverse="true">
<key column="soldierId" not-null="true"/>
<one-to-many class="com.futuresoldiers.user.Address"/>
</set>
</class>

<class name="address>
<id name="addressId" type="long" column="ADDRESS_ID">
<generator class="TriggerAssignedIdentityGenerator"/>
</id>
<property name="soldierId" type="long" column="SOLDIER_ID"/>
</class>

Full stack trace of any exception that occurs:
at com.iplanet.ias.web.WebContainer.service(WebContainer.java:580)
Caused by: java.sql.SQLException: ORA-00904: "SOLDIER_ID": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

Name and version of the database you are using: Oracle 10G -10.2.0.1.0