Error when creating string properties: BLOB/TEXT column 'XXX' can't have a default value

Hi there,

I'm trying out Designer with a very basic model.

I've created an entity which has a couple of string properties. When I update the database from the model I receive the following error:

BLOB/TEXT column 'Username' can't have a default value

Here's my log:

-- Add table Session to the database
CREATE TABLE `XXX`.`Session` (Id INT NOT NULL PRIMARY KEY ,
`ExpiryTime` DATETIME NOT NULL,
`SessionId` TEXT NULL,
`IsActive` BIT NOT NULL DEFAULT 0,
`SessionCreationTime` DATETIME NOT NULL,
`Username` TEXT NOT NULL DEFAULT '');
/* ERROR:
Session: Add table Session to the database
  - BLOB/TEXT column 'Username' can't have a default value
*/;

After doing some reading it seems BLOB/TEXT types cannot have default values on MySql5 on Windows (Other platforms generate a warning instead of an error).

I note that if I set the username property to nullable then no default is generated and the table is created successfully, however I don't want the property to be nullable.

Is this a problem with NHibernate itself, or a limitation of the Designer? (If it is the designer then is there a workaround?).

Cheers

That is currently a limitation of the designer. The only workaround at the moment would be to generate the column as nullable and then amend it to non-nullable through MySQL Workbench or another database tool, but we've implemented a fix and it will be sorted in the next nightly build (available from about 1200 GMT).

Thank you very much that was very quick :)

How do I access the nightly build?

You can download the nightly build from in your store account (click on the My account link in the top corner) and then click on the downloads button next to your subscription or for the trial nightly you can download this from http://www.mindscapehq.com/products/nhdesigner/nightly

Jeremy

I removed my post because I didnt realize this was from the NHibernate Designer forum. I am reposting in LightSpeed forum.