> Order order =
> Iterator i =
> tor i = lineItemValueObjectCollection.iterator();
> alueObject) i.next(), order);
Well, looking at the forums more in-depth, I found my problem. The problem I was facing was the fact that JBoss CMP 2.0 does not support not null foreign keys. In my example above, the LineItem database table had a 'not null' foreign key of order_id (the primary key in the Order database table).
My transaction was rolling back because my database (PostgreSQL 7.3.2) would not allow the insert into the LineItem database with 'null' as a value for 'order_id'.
Bringing up another question:
I saw in another forum post where someone asks is this a 'bug or a feature'. The answer from Dain was 'neither' which is a technically accurate answer. I'm in a development situation where I'm able to alter the database to get rid of the 'not null' constraints on the tables' foreign keys. But I have to think that most others are not. Also, I'm not comfortable leaving the foreign keys as 'null allowed'.
What is the best answer for this scenario? BMP? Suck it up and hope the spec comes around with an implementable solution?