Newbie trying to add HiLo to cat tutorial

fstann · **Posted:** Fri Jul 20, 2007 7:56 pm

Hi,

This is my first post. I just did the cat tutorial and it works great. I am using SQL Server 2005 (express) for backing store.

I decided that I wanted the cat ID to have autogenerated numbers like "1" "2" "3" etc... so I changed my mapping file like this:

<id name="Id">
<column name="CatId" sql-type="int64" not-null="true"/>
<generator class="hilo">
<param name="table">hi_value</param>
<param name="column">next_value</param>
<param name="max_lo">100</param>
</generator>
</id>

I added a "hi_value" table to my Quickstart database with a single column named "next_value" typed as "bigint" which is the 64bit integer for SQL Server 2005.

When I run the rebuilt solution I get an exception at NHibernate.Id.IdentifierGeneratorFactory.Create(String strategy, Itype type …
“type is not a ValueTypeType\r\nParameter name: type”

Any ideas?

Cheers,
Fred

karlchu · **Posted:** Sat Jul 21, 2007 11:18 am

Instead of this:

Code:

<id name="Id">
  <column name="CatId" sql-type="int64" not-null="true"/>
  ...

try this:

Code:

<id name="Id">
  <column name="CatId" type="Int64" not-null="true"/>
  ...

or this:

Code:

<id name="Id" column="CatId" type="Int64" not-null="true">
   ...

fstann · **Posted:** Mon Jul 23, 2007 1:53 pm

Hi Karlchu,

The second option you provided worked when I took off the not-null attribute (I got an exception complaining about it).

Thanks so much. I now have cats with ids that go from 1-> n.

Cheers,
Fred