<database-object>

2010/3/10 David Laabs <[email protected]>

> I have the situation that I cannot set several columns to "NOT NULL"
> because otherwise some data initializations of some tables doesnt
> work. I'd really like to add the not null constraint after creating my
> db with hbm2ddl.SchemaExport and initially filling the neccessary
> tables with data.
>
> In the moment I simply write a sql query like:
>
> sql = "ALTER TABLE SYS_TITLE_ITEM MODIFY TITLETYPE_ID NUMBER(20) NOT
> NULL";
> session.CreateSQLQuery(sql).ExecuteUpdate();
>
> That works fine for an oracle db but I'd like to be vendor
> independent.
>
> Is there a way to call db independent schema manipulating functions
> within the hbm2ddl assembly manually? Those functionalities must be in
> there, but I didn't find anything like that from externally... The
> other thing I'd like to do is to create a foreign key constraint
> manually out of similar reasons as above.
>
> Thanks for any answers...
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>


-- 
Fabio Maulo

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to