Hi,

I have a unidirectional ternary association like page 347 of the book between
Person (Category in the book), Category (Item in the book) and Career (User in the book).
The difference is that the person_id and the category_id are not nullable but the Career_id can be null in the association table.
When I try to save a Person with a Category in the key of the map but null in the value.
No insert occurs in the PERSON_CATEGORY table.

Is there a way of "telling" hibernate in the mapping to insert a line in PERSON_CATEGORY if the career is null ?

thanks

Paskos

Here are my details.

Hibernate version:3.2.2 ga

Mapping documents:

Code:

<class name="Person" table="PERSON">
  <id name="id" type="java.lang.Integer">
   <generator class="identity"/>
  </id>
  <property name="name" type="string"/>
 
  <map name="careerPath" table="PERSON_CATEGORY" cascade="all-delete-orphan">
   <key column="PERSON_ID"/>
   <map-key-many-to-many column="CATEGORY_ID" class="Category"/>
   <many-to-many column="CAREER_ID" class="Career"/>
  </map>
</class>

Code between sessionFactory.openSession() and session.close():

Code:

Person person = new Person();
person.setName("toto");
person.getCareerPath().put(newHire,null);
getSessionFactory().getCurrentSession().save(person);

Name and version of the database you are using: hsqldb v 1.8

The generated SQL (show_sql=true):

Code:

insert into person (id, name) values (?,?);

Paskos,
I remember having the same issue some time ago in my project. I had a ternary association that had one entity of the association nullable.

The mapping was looking like:

<map name="profiles" table="USERPROFILENICKNAME" cascade="all">
<key>
<column name="USER_ID" precision="10" scale="0" not-null="true"/>
</key>

<map-key-many-to-many entity-name="Nickname">
<column name="NICKNAME_ID" not-null="true"/>
</map-key-many-to-many>
<many-to-many entity-name="Profile" column="PROFILE_ID"/>
</map>

I could not save the record when the nickname part of the relation was null. I wonder if this is a limitation of hibernate, maybe an expert could provide some advises.

Best regards.

I was able to specify that the CAREER_ID could be null


But

still doesn't insert anything. And even worse

works perfectly well but when I try to read the person with id2 the null Career doesn't appear.

Here my unit test fails because my Map is empty. And it shouldn't because the "manual" insert worked well.

What I would like to achieve in Person is a Map<Category,Career> where sometimes for a Category the Career object is null. It's a business requirement.
When a Career object is null the following SQL is executed :

When a Career object is not null
And when I call Map<Category,Career> Person.getCareerPath() method I get the Map with category objects as key but sometimes Career instances sometimes null.

Is it possible to achieve this in Hibernate ?
Any expert out there ?

Oops replied to the wrong message.