I have the following tables:<br />
<br />
Day_Styles<br />
id<br />
name<br />
<br />
Day_Style_Assignments<br />
id<br />
day_style_id<br />
event_id<br />
<br />
Events<br />
name<br />
location (can be null)<br />
booking_type_id (can be null)<br />
age_restricton (can be null)<br />
<br />
<br />
My models look like this:<br />
<br />
public class DayStyles implements Serializable {<br />
<br />
@Id<br />
@Column(name = "id", nullable = false)<br />
private Integer id;<br />
<br />
@Column(name = "name", nullable = false)<br />
private String name;<br />
<br />
@ManyToOne(fetch = FetchType.EAGER,cascade = CascadeType.ALL )<br />
@JoinColumn(name="id",referencedColumnName="itinerary_day_style_id", nullable = <br />
false, insertable=false, updatable=false)<br />
private ItineraryDayStyleAssignments itineraryDayStyleAssignment;<br />
<br />
@OneToMany(mappedBy = "dayStyle",fetch = FetchType.EAGER, cascade = CascadeType.ALL )<br />
private Collection<DayStyleAssignments> dayStyleAssignments;<br />
.......................<br />
<br />
<br />
public class DayStyleAssignments implements Serializable {<br />
<br />
@Id<br />
@Column(name = "id", nullable = false)<br />
private Integer id;<br />
<br />
@Column(name = "day_style_id", nullable = false)<br />
private int dayStyleId;<br />
<br />
@Column(name = "event_id",nullable = false, insertable=false, updatable=false)<br />
private int eventId;<br />
<br />
@ManyToOne(fetch = FetchType.EAGER,cascade = CascadeType.ALL )<br />
@JoinColumn(name="day_style_id",referencedColumnName="id", nullable = false, <br />
insertable=false, updatable=false)<br />
private DayStyles dayStyle;<br />
<br />
@ManyToOne(fetch = FetchType.EAGER,cascade = CascadeType.ALL )<br />
@JoinColumn(name="event_id",referencedColumnName="id")<br />
private Events event;<br />
<br />
@OneToMany(mappedBy = "dayStyleAssignment",fetch = FetchType.EAGER, cascade = <br />
CascadeType.ALL )<br />
private Collection<Events> events;<br />
...........................<br />
<br />
public class Events implements Serializable {<br />
<br />
@Id<br />
@Column(name = "id", nullable = false)<br />
private Integer id;<br />
<br />
@Column(name = "name", nullable = false)<br />
private String name;<br />
<br />
@OneToMany(mappedBy = "event",fetch = FetchType.EAGER, cascade = CascadeType.ALL )<br />
private Collection<EventDays> eventDays;<br />
<br />
@OneToMany(mappedBy = "event",fetch = FetchType.EAGER, cascade = CascadeType.ALL )<br />
private Collection<EventDates> eventDates;<br />
<br />
@OneToMany(mappedBy = "event",fetch = FetchType.EAGER, cascade = CascadeType.ALL )<br />
private Collection<DayStyleAssignments> dayStyleAssignments;<br />
<br />
@ManyToOne(fetch = FetchType.EAGER,cascade = CascadeType.ALL )<br />
@JoinColumn(name="id",referencedColumnName="event_id", nullable = false, <br />
insertable=false, updatable=false)<br />
private DayStyleAssignments dayStyleAssignment;<br />
..............................<br />
<br />
<br />
My JSF page to create a new DayStyleAssignment looks like this :<br />
<br />
<f:view><br />
<h:messages errorStyle="color: red" infoStyle="color: green" layout="table"/><br />
<h1>Add Day Style Event</h1><br />
<h:form><br />
<h:panelGrid columns="2"><br />
<h:outputText value="Event:" <br />
rendered="#{dayStyleAssignments.dayStyleAssignments.event == null}"/><br />
<h:selectOneMenu id="event" <br />
value="#{dayStyleAssignments.dayStyleAssignments.event}" title="Event" <br />
rendered="#{dayStyleAssignments.dayStyleAssignments.event == null}"><br />
<f:selectItems value="#{dayStyleAssignments.events}"/><br />
</h:selectOneMenu><br />
</h:panelGrid><br />
<h:commandLink action="#{dayStyleAssignments.create}" value="Create" <br />
rendered="#{dayStyleAssignments.dayStyleAssignments.event == null}"/><br />
</h:form><br />
</f:view><br />
<br />
<br />
dayStyleAssignments is a session bean that maps to a DayStyleAssignmentController. The <br />
DayStyleAssignmentsController has an instance of the entity model DayStyleAssignments.<br />
<br />
<br />
Whenever my dayStyleAssignments.create function is called, I receive the following error.<br />
Exception Description: Cannot persist detached object [Aerobics]. Class> <br />
net.nanonation.rccl.model.Events Primary Key> [4]<br />
<br />
<br />
Can anyone provide any insight? Thanks in advance.<br />
<br />
Jim
[Message sent by forum member 'aantix' (aantix)]
http://forums.java.net/jive/thread.jspa?messageID=205330