List "key Column" and "List Index" values null.

[Mike Anna]

hi,
I have this scenarion. One Conference can have many Users. So,
I mapped my Conference class like this :

<class name = "com.jd.hibernate.associations.Conference" table = "TEST_JD_CONFERENCE" >
<id name = "conf_Id" column = "conf_Id">
<generator class = "identity"/>
</id>
<property name = "name" column = "Name" type = "java.lang.String" /> ...<!--other props-->.. 
<list name = "usersInConference" inverse="true" cascade = "save-update">
<key column="conf_Id" />
<list-index column="idx"></list-index>
<one-to-many class = "com.jd.hibernate.associations.Users"  />
</list>


</class>    

and my Users class like this :

  <class name = "com.jd.hibernate.associations.Users" table = "TEST_JD_USERS" discriminator-value="Users">
<id name = "id" column = "ID" type = "int">
<generator class = "increment"/>
</id>
<!-- following column need not be defined as property in pojo -->
<discriminator column = "Users_Type" type = "java.lang.String" />
<property name = "userType" type = "java.lang.String" column = "USERTYPE" /> 
..<!-- other properties --> ..
<component name="conference" class = "com.jd.hibernate.associations.Conference" >
<!-- mapping necessary only for the required attributes that will be saved along with this -->

<property name = "name" column = "Name" type = "java.lang.String" /> 
<property name = "desc" column = "Description" type = "java.lang.String" />
<property name = "startDate" column = "StartDate" type = "date" />
<property name = "endDate" column = "EndDate" type = "date" />
</component>
  

Now, the Conf_id and the idx columns are being updated as null and .. I have no clue why.



Heres the code that tests the updations:

 tx.begin();
//test for conference to users 
Conference conf = new Conference();
Users users = new Users();
Users users1 = new Users();

List userList = new ArrayList();

users.setEmail("[e-mail]");
users.setFirtName("navnith");
users.setHomePhone(342);
users.setLastName("M");
users.setPassword("navnith");
users.setUserType("S");
users.setWorkPhone(3214);



users1.setEmail("[e-mail]");
users1.setFirtName("11n1avnith");
users1.setHomePhone(11342);
users1.setLastName("11M");
users1.setPassword("11navnith");
users1.setUserType("11S");
users1.setWorkPhone(11214);



 

conf.setDesc("usersconfdesc");
conf.setEndDate(new Date(1,1,1));
conf.setName("Test for users");
conf.setStartDate(new Date());

users.setConference(conf);
users1.setConference(conf);


userList.add(users);
userList.add(users1);

conf.setUsersInConference(userList);

session.save(conf);   

Any help, greatly appreciated.

Rgds

[Mike Anna]

Hi,

Should I have actually mapped Conference in Users mapping as a component or.. may be just modify it into a many to one association.?

have I missed giving any details ?


rgds
[ October 15, 2007: Message edited by: Mike Anna ]

[Mark Spritzler]

I don't see a FK mapping of conf_Id in your User class, so how would Hibernate know to put a value into that field?

Also, be careful about id naming and capitalization. I got confused how in User you have "id" to a column called "ID" and in the conference it was "conf_Id", the normal default way, if you can change the database is to call the attribute in the class all lower case "id" and allow Hibernate to automatically combine the class name and id name like Class=Mark and id is "id" Hibernate will give you "mark_id" as the PK field name.

Mark

[Mike Anna]

Thanks Mark, for replying.
I am fairly new to hibernate.

I don't see a FK mapping of conf_Id in your User class, so how would Hibernate know to put a value into that field?

and how would I do that ?
map the conf_Id as a propertyu in the component mapping of the Users class ?

Right about the naming conventions, I will take care.

Rgds
[ October 15, 2007: Message edited by: Mike Anna ]