Hello

My problem is that once I've saved an object to my database (a sql server 2005 mdf file using the mssql2000 dialect) it never seems to actually appear when I look in the table data (my empty table is still empty!)

I was using an identity generator but this kept telling me that I couldn't insert null for the primary key (I thought that MS SQL 2005 would generate this for me...). So I used increment and now everything runs through fine without any exceptions.

im simply doing:


I checked the WasCommitted property on transaction at runtime and it is always set to true which is good. However the data just isnt appearing in my table! The mapping files all seem okay too...

Has anyone experienced this or get any suggestions?

Kind Regards

Tom.

What is your mapping?

Here is mine, it's running just fine against 2005 with the 2000 dialect:



Also, either set up log4net, set your log level to debug, and then set show_sql=true in your nhibernate config. Or, open sql profiler and turn on a trace and see what sql is being sent to the db.

Thanks for the quick response. I changed my mapping to adhere to your style, but now I am getting

{"Cannot insert the value NULL into column 'Id', table 'E:\\USERS\\TOM\\DOCUMENTS\\PROPERTYTRACKER.MDF.dbo.EstateAgents'; column does not allow nulls. INSERT fails.\r\nThe statement has been terminated."}

My EstateAgent class has a private field



and a public property



My mapping file now has this (based on your one)



Can't see what I'm doing wrong!

Can you script out your table?

Since I've done it so many times, the first thing I'd look at would be if the column is truly an identity column

Hello

there doesnt seem to be an option for scripting it out. However my log4net gave me this

18:23:36.718 [5436] DEBUG NHibernate.SQL - INSERT INTO EstateAgents (County, Country, Email, Address1, Name, Postcode, Fax, Town, Address2, Telephone) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9); select SCOPE_IDENTITY()

....

18:23:37.000 [5436] DEBUG NHibernate.Util.ADOExceptionReporter - could not insert: [PropertyTrackerBusiness.Domain.EstateAgent]
System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Id', table 'E:\USERS\TOM\DOCUMENTS\PROPERTYTRACKER.MDF.dbo.EstateAgents'; column does not allow nulls. INSERT fails.
The statement has been terminated.


I checked the IsIdentity on the Id via vs 2005 and it is set to 'Yes'. It is set to increment of 1.

The INSERT statement looks ok to me?

Well, I just tried to replicate your error but it turns out that I don't have Express loaded so I can't add an .mdf file to my solution (stupid thing, I've got SQL Server 2005 standard running).

Anyway, my hunch is that, if you tried to run that from a query window against the db you'd get the same error. I forget, does vs 2005 give you a query window? You might want to try sql server 2005 express management studio as well.

For whatever reason, that column doesn't seem like it's an identity column. If you go back to an assigned identity (just change generator class="identity" to "assigned"), what is the SQL in your log file?

ok well i replaced the parameters with values and ran from the query window in vs 2005




and this worked ok..... the data then appeared as expected, with the id column set to 1 automatically.

V. Confusing!!