2.1.6
Oracle9i

I have the following two mappings:

<hibernate-mapping>
<class name="com.demo.Event" table="EVENT">
<id name="id" type="long" column="EVNT_ID">
<generator class="sequence" />
</id>
<property name="eventTitle" type="java.lang.String" column="EVNT_TITLE" not-null="true" length="255"/>
<!-- bi-directional many-to-one association to EventType #eventType -->
<many-to-one name="eventType" class="com.demo.EventType" not-null="true">
<column name="EVNT_TYP_ID" />
</many-to-one>
</class>
</hibernate-mapping>


<hibernate-mapping>
<class name="com.demo.EvntTyp" table="EVNT_TYP">
<id name="id" type="long" column="EVNT_TYP_ID">
<generator class="sequence" />
</id>
<property name="eventTypeName" type="java.lang.String" column="EVNT_TYP_NME" unique="true" not-null="true" length="255"/>
<!-- bi-directional one-to-many association to Event #events -->
<set name="events" lazy="true" inverse="true" cascade="none">
<key column="EVNT_TYP_ID" />
<one-to-many class="com.demo.Event" />
</set>
</class>
</hibernate-mapping>


After I generate the schema, my EVNT_TYP_ID in the EVENT table allows nulls. Thanks for your help in advance.

I'm attaching the sql that gets generated. As you can see the EVNT_TYP_ID number(19,0) is NOT set to 'not null'.

I was expecting something like this: EVNT_TYP_ID number(19,0) not null, since I defined the mapping as

<many-to-one name="eventType" class="com.demo.EventType" not-null="true">.

Is there anything else I need to set, or is this a bug?




[schemaexport] alter table EVENT drop constraint FK3F47A7AAADFC277;
[schemaexport] drop table EVENT cascade constraints;
[schemaexport] drop table EVNT_TYP cascade constraints;
[schemaexport] drop sequence hibernate_sequence;
[schemaexport] create table EVENT (
[schemaexport] EVNT_ID number(19,0) not null,
[schemaexport] EVNT_TITLE varchar2(255) not null,
[schemaexport] EVNT_TYP_ID number(19,0),
[schemaexport] primary key (EVNT_ID)
[schemaexport] );
[schemaexport] create table EVNT_TYP (
[schemaexport] EVNT_TYP_ID number(19,0) not null,
[schemaexport] EVNT_TYP_NME varchar2(255) not null unique,
[schemaexport] primary key (EVNT_TYP_ID)
[schemaexport] );
[schemaexport] alter table EVENT add constraint FK3F47A7AAADFC277 foreign key (EVNT_TYP_ID) references EVNT_TYP;

I'm reformatting the hibernate mapping code, so it's easier to read. My problemis that the highlited text (in red bold) does not have an effect on DB schema.

<hibernate-mapping>
<class name="com.demo.Event" table="EVENT">
<id name="id" type="long" column="EVNT_ID">
<generator class="sequence" />
</id>

<property name="eventTitle" type="java.lang.String" column="EVNT_TITLE" not-null="true" length="255"/>

<!-- bi-directional many-to-one association to EventType #eventType -->
<many-to-one name="eventType" class="com.demo.EventType" [color=red][b]not-null="true"[/b][/color]>
<column name="EVNT_TYP_ID" />
</many-to-one>

</class>
</hibernate-mapping>


<hibernate-mapping>
<class name="com.demo.EventType" table="EVNT_TYP">
<id name="id" type="long" column="EVNT_TYP_ID">
<generator class="sequence" />
</id>

<property name="eventTypeName" type="java.lang.String" column="EVNT_TYP_NME" unique="true" not-null="true" length="255"/>

<!-- bi-directional one-to-many association to Event #events -->
<set name="events" lazy="true" inverse="true" cascade="none">
<key column="EVNT_TYP_ID" />
<one-to-many class="com.demo.Event" />
</set>

</class>
</hibernate-mapping>[color=orange][/color]

I'm using hibernate 2.1.8, and I have the exact same problem. SchemaExport does not generates not-null in the DDL for many-to-one relationships. Actually, the many-to-one tag does not even support the not-null property in the hibernate mappings.

How can I make SchemaExport generate the not-null information correctly for many-to-one columns?

Thanks in advance,
Felipe de Alvarenga Leite