Hibernate version: 3.2.6


Name and version of the database you are using: Oracle 10g


Hello,

I’m having trouble with a mapping where I’m not getting the list-index set. The index is always null. Can someone see what is wrong with this mapping: (and I'm only including what what I think is needed because I can't copy/paste--I have to retype this because our development environment is an isolated environment. Let me know if you have an idea but need more.)


After saving a DummyDataEntity object, the data in the database looks like this:


The database structure needs to stay like this where the child SMARTY table's DUMMY_ID is a foreign key to it's parent DummyDataEntity.DUMMY_ID. That's why Smarty doesn't have an id generator of it's own.

So when I try to load the DummyDataEntity, there are problems because the list order(SMART_ORDER) is null.

Thanks.

I think the problem is that you have inverse="true" in the <list> mapping. This will make Hibernate ignore the list when updating the database. And the SMART_ORDER column is not mapped in the Smarty class so there is no place for Hibernate to get a value for it.

Thanks. I think you are right. When I set inverse to false, then the list-index fills in the SMART_ORDER column. However, If I attempt to delete the top level object(DummyDataEntity), I expect it to remove all of the Smarty objects too. But all I get is an exception:

Hibernate operation: could not delete collection [....]; uncategorized SQLException for SQL [update SMARTY set DUMMY_ID=null where DUMMY_ID=?; ..... java.sql.SQLException ORA-1407: cannot update ("SMARTY"."DUMMY_ID") to NULL


So instead of deleting, its attempting to set the id to null.