I played around with WilsonNHibernateExample (http://weblogs.asp.net/pwilson/archive/ ... 09042.aspx).

It is a nice example program and I got it working with MySql. But when I try to get it to work with FireBird I seem te have problems with the Contacts table.

I think it has to do with te AutoInc field in MySql and the lack of it in FireBird.

So I created the contact table like this:

CREATE GENERATOR "CONTACTS_GENERATOR";

CREATE TABLE "CONTACTS"
(
"CONTACTID" INTEGER NOT NULL,
"CONTACTNAME" VARCHAR(50) NOT NULL,
"CONTACTTYPE" CHAR(1) NOT NULL,
"COMPANYNAME" VARCHAR(50),
"ADDRESSLINE" VARCHAR(50),
"ADDRESSCITY" VARCHAR(50),
"ADDRESSSTATE" VARCHAR(2),
"ADDRESSZIP" VARCHAR(5),
PRIMARY KEY ("CONTACTID")
);
SET TERM ^ ;


/* Triggers only will work for SQL triggers */

CREATE TRIGGER "CONTACTS_BI" FOR "CONTACTS"
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
NEW.ContactId = GEN_ID(CONTACTS_GENERATOR, 1);
END
^

COMMIT WORK ^
SET TERM ;^

Changed the mapping file to:
<id name="Id" column="ContactId" access="nosetter.camelcase" unsaved-value="0">
<!--generator class="identity" /-->
<generator class="sequence" />
</id>

And it ttill doesn't work. I get an error "Could not save object" when I process the line session.SaveOrUpdate(this.contact);

So how do I use FireBird with a generator?

Bas

You have to add the name of the generator in the mapping:



It's also an option to change the class of the generator to 'native' and still add the sequence parameter. This way, you don't have to alter the mapping file when switching between MySQL (or SQL Server) and Firebird.

Finally, I don't think you need the insert trigger because NHibernate retrieves the new sequence value itself.

Thank you that worked!
Is this is a wiki entry worth?

Sure, add it if you want.

Is it not possible to configure hibernate not to take care of the PK-generation at all?

I want that only the trigger in Firebird takes care. The application should not need to know about that.