Hello!
I searched through the forums and documentation for this case but could not find anything. But in case I missed something, please forgive me!

Anyhow, tired of checking every nullable field for nothing'ness, I wanted to switch to the types used in the System.Data.SqlTypes namespace which have NULL-value compatibility. However, nHibernate cannot interpret these types and throws an exception:


I know it is possible to use user-defined types in hibernate, but I have no idea if and especially how it is possible to use .NET-framework integrated types.

Can anybody help me or give me a hint where to look for it?


further information:
we are using: VS.NET2003, using VB.NET ( :( ), nHibernate (incl. nUnit, nAnt, log4net, etc), SQL-Server 2000

thanks and cheers!

SqlTypes aren't supported out of the box right now, you'll have to write an IUserType implementation for them, but it should be pretty easy, just look at the docs for IUserType and at the Nullables implementation in NHibernateContrib.

Hi

Thanks for your answer! I tried to implement a library which works similar to the Nullables.NHibernate, by combining System.Data.SqlTypes with the interface IUserType but failed :(

So I decided to use Nullables.dll and Nullables.NHibernate.dll. After lots of tweaking, adapting, etc I finally got it to compile and (partially) run. Unfortunatly another error came up which I have no clue how to solve. in the following fuction:

it works fine until the getConfiguration() part (where I have all the _configuration.AddClass(GetType(MyDTO)) and the connection properties) but it fails when getting to BuildSessionFactory. The error message is:

(sometimes it is NullableInt32Type instead... so not consistant either :?: )

and the last log4net message is:


any ideas?


possible issues:
- that error message is thrown in AbstractEntityPersister
- I "extended" Nullables and Nullables.NHibernate by a NullableStringType. How come this doesn't exist? How do others map varchar fields?

btw: Console.Error shows


but that console window is usually not of much help to me..

I have tried further and just cannot get it to work.

Any input? *prettyplease*? :)

cheers!

NullableInt64Type doesn't implement IIdentifierType so it can't be used in id type="..."

Implementing IIdentifierType on NullableInt64Type wouldn't be much work. Just need to have a constant string - something like "FalseHasValue" - to indicate that NullableInt64.Default should be used.

thanks for the answer (i didn't see it until now because the notification did not work :( ..)

unfortunatly, i don't really understand what you mean with you explanation. i couldn't find anything about IIdentifierType, neither for NullableInt64Type nor for any other IntXxType.

if i DO after all understand you correctly, should it work if i keep all nullabletypes and use regular longs (or Int64s) for the identity?