Has anybody been able to get a CMR one to many working? I'm trying to get it to work but keep getting "foreign key constraint not allowed for this type of data store".

The relationship is simple, I have two entity beans, person and company and I want to have one to many unidirectional relationship between these two beans. A person has one company, but a company has many persons.

I want to have a company_id field in my person table that refers to the id field in my company table. Maybe I'm missing something or doing this wrong?

If somebody could post a working example of one to many unidirectional I'd be mighty grateful. I'm trying to use the foreign-key-mapping rather than relation-table, can you do this with foregin-key-mapping?

Here's what I have:

/**
* @return the company the person belongs to
*
* @ejb.persistent-field
* @ejb.persistence
* column-name="COMPANY_ID"
* sql-type="integer"
* jdbc-type="integer"
*
* @ejb.interface-method
*
* @ejb.relation
* name="Person-Company"
* role-name="Person-belongs-to-Company"
* target-ejb="Company"
* target-role-name="Company-has-many-Persons"
* target-multiple="yes"
*
* @jboss.relation
* fk-constraint="true"
* fk-column="COMPANY_ID"
* related-pk-field="id"
*
*/
public abstract CompanyLocal getCompany();