hello i am stuck can anyone help please... all of this works fine for mapping and retrieving data, BUT when i save a new object i get an error because the channelid is column in my table and has a foreign key relation.

what do i need to add to the xdoclet hibernate.set to fix this? or what do i need to change in the database shema to makes this work... thanks

/**
* @hibernate.set cascade="all"
*
* @hibernate.collection-key column="channelID"
*
* @hibernate.collection-one-to-many class="Channel"
*/
public Set getChannels() {
return channels;
}

public void setChannels(Set channels) {
this.channels = channels;
}


here is my error

java.sql.BatchUpdateException: null, message from server: "Cannot add
or update a child row: a foreign key constraint fails (`site`,
CONSTRAINT `fk_channelID` FOREIGN KEY (`channelID`) REFERENCES `channel`
(`channelID`))"

is this a mysql bug then?

http://bugs.mysql.com/bug.php?id=5103