I am trying to implement my object hierarchy in one table with the "table per class hierarchy" strategy in NHibernate. I'm getting an error with my NHibernate mapping that can be easily reproduced with a simple example. The error is:

System.NotSupportedException: Attempting to parse a null value into an sql string (column:activity0_.Type).
at NHibernate.SqlCommand.InFragment.ToFragmentString() in InFragment.cs: line 109
at NHibernate.Persister.Entity.SingleTableEntityPersister.DiscriminatorFilterFragment(String alias) in SingleTableEntityPersister.cs: line 551

I can reproduce this with the following domain classes:

public interface IActivity
{
Guid Id { get; set; }
}

public class Activity : IActivity
{
public DateTime StartTime { get; set; }
public Guid Id { get; set; }
}

public class Running : Activity
{
public string Where { get; set; }
}

public class Talking : Activity
{
public string ToWhom { get; set; }
}

And the following XML mapping:

<?xml version="1.0" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
assembly="NHibernateTesting"
namespace="NHibernateTesting" >
<class name="IActivity"
lazy="false"
table="Activity"
discriminator-value="0"
abstract="true">
<id name="Id">
<generator class="guid" />
</id>
<discriminator column="Type" type="Int16" />
<subclass name="Activity"
discriminator-value="1"
abstract="true"
lazy="false">
<property name="StartTime" />
</subclass>
<subclass name="Running"
discriminator-value="2"
lazy="false"
extends="Activity">
<property name="Where" />
</subclass>
<subclass name="Talking"
discriminator-value="3"
lazy="false"
extends="Activity">
<property name="ToWhom" />
</subclass>
</class>
</hibernate-mapping>

Does anyone have an idea of what I am doing wrong?

Not sure, but maybe try the discriminator as a string type

have look at:
viewtopic.php?t=974225

I crossed posted this to stack overflow and got an answer there:

http://stackoverflow.com/questions/1045 ... -per-class

Thanks,
Michael Hedgpeth