Workaround the not-null="true"

skillipedia · **Joined:** Fri Dec 15, 2006 11:44 am **Posts:** 8

In my web site, users have to sign in to submit items: the logical Hibernate mapping from the many-to-one mapping side , I am using is :

<many-to-one
column="job_submitter_company_key" not-null="true"
/>

Now, I am thinking to let users submit items without registration, do I still have to create anonymous company, or is there any workaround removing the not-null="true"

Thanks

nordborg · **Posted:** Wed Sep 03, 2008 2:27 pm

If you can manually issue an SQL statment similar to the MySQL example below it should be safe to remove the not-null attribute.

Code:

ALTER TABLE tbl MODIFY job_submitter_company INT NULL;

skillipedia · **Joined:** Fri Dec 15, 2006 11:44 am **Posts:** 8

Do i have to use different hibernate session in this case and different mapping with no relationships?

nordborg · **Posted:** Fri Sep 05, 2008 2:00 am

Quote:

Do i have to use different hibernate session in this case and different mapping with no relationships?

I'm sorry but I don't understand what this has to do with the NULL vs. NOT NULL problem.