As stated I'm new to NHibernate. I've gotten the Cat example to work, but when I tried to get a simple class working with my actual data I came across a problem that I'm hoping someone can help me with.

Keep in mind that I'm not an SQL Server expert, being more familiar with MySQL.



I'm using NHibernate-1.2.0Beta2 with MS SQLServer 2000, and the site is using ASP.Net 2.0 which I'm editing with Web Developer Express.


In a nutshell I've defined my schema, placed the assemblies, etc, but it keeps trying to insert a null for the primary key.


Here's the relevant bits:

schema



POCO class



The primary key is setup as an int identity with an increment of 1.


Whenever I attempt to insert into the table I get the following error:



----------------------------

Also note the sql-type. I tried to use type="Int32" but it kept giving me an error about it not being supported.


I've been banging my head against this problem for several hours now so any advice would be greatly appreciated.

Hi,

Don't know if this will help, but this is an example of an id-declaration in our mapping files:


Please rate this post if it helped.
X.

Thank you for the reply xasp.

I can see from your example part of my misunderstanding. The type attribute is for the id/property, while the sql-type is for the column. I feel a bit foolish, but I was so aggravated yesterday I don't think I was paying attention the way I should have been.


Unfortunately I'm still getting the exact same error. Here's my current xml file:



I've tried both native and identity generators with the same error.

In the interest of being complete I'll list the assemblies that I'm referencing:



Is it possible that I'm not referencing a needed assembly? I'll look around, but if someone could nudge me in the right direction I'd really appreciate it.

PS
I went ahead and rated you even though it didn't solve the problem since it helped me understand the xml files better.

In the NHibernate configuration file, are you using the MSQL2000 dialect ?


X.

By the way, what statement are you using for persisting your object to the datastore: session.Save(), Update() or SaveOrUpdate() ?
As you're not using the unsaved-value attribute, maybe NHibernate is trying to execute an Update instead of an Insert (although the message is quite explicitely saying it's an insert that is failing).

Could you maybe send some more code along ?

X.

I apologize I should have updated the thread.

The problem was user error. I had made a few changes to the table involving the primary key, relationships, et al, and I forgot to set the new primary key column to identity...

I'm traditionally a linux guy so I'm picking up C#, ASP.Net, SQL Server, & NHibernate all at the same time. At least that's my excuse as I can't believe I actually missed that (it just clicked in my head this morning).

Nothing like a good old fashioned PEBKAC error. I promise you I'll never make that mistake again, although I'm now officially happy with NHibernate :)

I do have 1 more question. Is there a default-value attribute for NHibernate? or do I need to reflect that in the code itself?


Thanks for all the help xasp, you've definately helped me.

I'm glad you found the error, because I was also at a loss about the possible causes. ;-)

I'm not sure I understand your question: yes, there is a default-value attribute for id-tags, as mentioned above. Is that what you wanted to know, or did I misunderstand you ?

X.

Oops, I just reread my own post ... I'm sorry, I understand your question now.

As far as I know, there's no default-value attribute, you should implement default values yourself in code.

X.