Hello and thanks for any help!

When trying to use a list construct, the index column is null. The database tables map a one-to-many relationship between a Document table and a Page table. There may be 1...* pages in a document, but the order of the pages needs to be preserved.

I'm not using a mapping table, but do I even need to for list.

Any ideas?

-K

Hibernate version:1.2.0.400

Mapping documents:

Here's for the Document.hbm.xml:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-lazy="false">
<class name="PersistenceExperiments.Document, PersistenceExperiments" table="Document">
<id name="Id" column="Id" access="nosetter.camelcase">
<generator class="native" />
</id>

<list name="Pages" access="nosetter.camelcase" cascade="all" table="Page">
<key column="DocumentId" />
<index column="Position" />
<one-to-many class="PersistenceExperiments.Page, PersistenceExperiments"/>
</list>

<property name="Name" column="Name" type="String" />
</class>
</hibernate-mapping>

And for Page.hbm.xml:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-lazy="false">
<class name="PersistenceExperiments.Page, PersistenceExperiments" table="Page">
<id name="Id" column="Id" access="nosetter.camelcase">
<generator class="native" />
</id>
<property name="Randomize" column="Randomize" type="Boolean"/>
</class>
</hibernate-mapping>



Code between sessionFactory.openSession() and session.close():

Document doc = new Document();
doc.Name = "Doc with pages";
doc.AddPage();

ISession session = SessionManager.Instance.GetSession();
ITransaction tran = session.BeginTransaction();

try
{
session.Save(doc);
tran.Commit();
}
catch(Exception ex)
{
throw;
}



Stack trace of any exception that occurs:

NHibernate.ADOException : could not insert: [PersistenceExperiments.Page][SQL: INSERT INTO Page (Randomize) VALUES (?)]
----> System.Data.SqlClient.SqlException : Cannot insert the value NULL into column 'Position', table 'NHibernate_Testbed.dbo.Page'; column does not allow nulls. INSERT fails.



Name and version of the database you are using:SQLServer 2005

The generated SQL (show_sql=true):
INSERT INTO Page (Randomize) VALUES (?)

I forgot to add that when I turn off the NOT NULL constraint on my Page table, the index column is set. But, it seems like the index should be known during the INSERT call, so I imagine there is a directive in the xml that I'm lacking. I don't want my index to allow nulls in the db table.

After digging around the forums some more, I think the answer is: "it's not a bug, it's a feature."

This thread covers the issue, for those having the same problem.

http://forum.hibernate.org/viewtopic.ph ... nhibernate

Though it isn't ideal, I can deal with it.