Hello,

I am using VB.NET w/ .NET 1.1 and MSSQL 2000 and NHibernate 1.0.3. I'm trying to cope with columns that allow nulls, in my particular case it's an integer column. It's defined in my .hbm.xml file like this:



In my VB.NET class the property is defined as:



I have inserted one row into this table, which contains a NULL in the NullableInt column. It loads my one entry from the database table just fine, then I set the value of the NULL property to 0:



... but after I flush the session, I see the following generated SQL:



This fails - because it should be testing in the WHERE clause that "NullableInt IS NULL" - right?

Then the exception occurs:



I understand why the exception is occuring, it just doesn't make any sense to my what the generated UPDATE statement is not looking like what I expect. Can anyone tell me what I should do or look at in order to investigate this?

Thanks!
David McClelland

This does look like a bug in the nullables library, or maybe in NH itself, I am not sure.
Please open a JIRA with a test case.

At any rate, this looks like you are using full optimistic concurrency, can you use <version> instead?

There are two ways to resolve your problem:

one:
in your class define, change .net data type to NHibernate date type,
example:

NHibernateUtil.int32 year;


two:

set the default: example:
int year=2007;


other,like string ,datetime,long etc ,you must do like up,too.

There are two ways to resolve your problem:

one:
in your class define, change .net data type to NHibernate date type,
example:

NHibernateUtil.int32 year;


two:

set the default: example:
int year=2007;


other,like string ,datetime,long etc ,you must do like this,too.

FYI, I just finished testing this with 1.2 beta 3, and same thing occurs:



I will open up a JIRA issue with a test case. I would love to be using <version> instead, but for now I cannot change the database schema to add any columns.

I really really really wish this worked, so that I could use NHibernate! Of course I also wish that we were using .NET Framework 2.0 so that we'd have built-in nullable types :-)

- David McClelland

If you take another look at the VB.NET code that I listed above, you'll see that I'm using the NullableInt32 datatype in my class, not the built-in datatype.

Also, I don't understand why you are referring to NHibernateUtil.Int32 - this isn't a datatype, it's an instance of NHibernate.Type.NullableType.

This has been submitted as JIRA issue NH-864.

The fix looks great in 1.2.0 CR1, thanks Ayende & Sergey!

I am using C#.NET w/ .NET 2.0 and MSSQL 2000 and NHibernate 1.0.3. I'm trying to insert a row in table which is having instead of insert trigger on it. It's defined in my .hbm.xml file like this:

[code<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" assembly="ECM.Domain" namespace="ECM.Domain" >
<class name="Employee" table="Employee" >
<id name="Id" column="EMPLOYEE_ID" type="Int32" unsaved-value="0">
<generator class="identity"/>
</id>
<property name="Name" column="NAME" type="String" length="100" not-null="true" />
</class>
</hibernate-mapping>

public class Employee
{

private int id;

public int Id
{
get { return id; }
set { id = value; }
}

private String name;

public String Name
{
get { return name; }
set { name = value; }
}

}


CODE:

sessionFactory = new NHibernate.Cfg.Configuration().Configure().BuildSessionFactory();

ISession dataSession;
Employee EmployeeItem = null;
try
{
dataSession = sessionFactory.OpenSession();
EmployeeItem = (Employee)dataSession.CreateCriteria(typeof(Employee))
.Add(Expression.Eq(id, Name)).UniqueResult();

if (EmployeeItem != null)
return 2;

EmployeeItem = new Employee();
EmployeeItem.Name = Name;

tx = dataSession.BeginTransaction();
dataSession.Save(EmployeeItem);
tx.Commit();

while saving it is giving DBnull cannot be changed to Int32,64
I debugged and tried while inserting query generated is like this
Select SCOPE_IDENTITY(); it returns null since a trigger is there and
the sope of query is over.

if we use @@identity it will return identity even sope of query is over.
can we generate @@identity through nhibernate.

is there any way i can get identity even trigger is there .