Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
We are using composite-PK in Database wich is having one auto-increment column. When inserting a new row i am not assigning the value for the second column. When I returned serialisable object it is giving null value for that column even though database insertion happend. This is happening while using this composite-id as foreign key.
The scenario is like this
Declare the composite-user type in hibernate with both assigned as given below,
<id name="eventCompId" type="EventUserTypeId">
<column name="event_id"/>
<column name="event_version"/>
</id>
The business scenario is like this once a row is created for the entity, user updates and changes the second column, which is assigned. We need to save this as second row(infact a insert) with first column being saved with same id.
compsite pk is like this for event column,
CREATE TABLE `event` (
`event_id` int(30) unsigned NOT NULL auto_increment,
`event_version` int(10) unsigned NOT NULL default '1',
.....
.....
PRIMARY KEY (`event_id`,`event_version`),
...
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Thanks for any help forthcoming.
Srihari.
Hibernate version:3.0
Name and version of the database you are using:Mysql 5.0.18