Ticket and TicketAudit are related with OneToMany releationship, i.e. there can be many records in TicketAudit with respect to one Ticket. Below is the class definition
@Entity
@Table(name="hd_ticket")
public class Ticket implements Serializable {
private String ticketID;
private Set auditTrails;
@OneToMany(targetEntity=AuditTrail.class, cascade=CascadeType.ALL, fetch=FetchType.EAGER)
@JoinColumn(name = "TICKET_ID")
public Set getAuditTrails() {
return auditTrails;
}
public void setAuditTrails(Set auditTrails) {
this.auditTrails = auditTrails;
}
@Id
@Column(name="Ticket_Id")
public String getTicketID() {
return ticketID;
}
public void setTicketID(String ticketID) {
this.ticketID = ticketID;
}
@Column(name="Date_Created")
public String getDateCreated() {
return dateCreated;
}
public void setDateCreated(String dateCreated) {
this.dateCreated = dateCreated;
}
}
@Entity
@Table(name="hd_audit_trail")
public class AuditTrail implements Serializable {
private String ticketID;
@Id
@Column(name="Ticket_Id")
public String getTicketID() {
return ticketID;
}
public void setTicketID(String ticketID) {
this.ticketID = ticketID;
}
@Column(name="Revision_Date_time")
public String getRevisionDatetime() {
return revisionDatetime;
}
public void setRevisionDatetime(String revisionDateTime) {
this.revisionDatetime = revisionDateTime;
}
}
The method definition of DAO is as below
@SuppressWarnings("unchecked")
public List getTickets(final String userID, final String statusID) throws AppException{
if(logger.isDebugEnabled()){
logger.debug("AudtiTrial userID:"+userID);
logger.debug("getHibernateTemplate():"+getHibernateTemplate());
}
List results=null;
try {
results = (List)getHibernateTemplate().find(" from com.helpdesk.domain.Ticket ticket where creator='"+userID+"' and statusID LIKE '"+statusID+"'");
} catch (RuntimeException e) {
logger.fatal("RuntimeException", e);
throw new AppException(e);
}
if(logger.isDebugEnabled()){
logger.debug("TicketAudti details is :"+results);
}
if(results==null){
results = new ArrayList();
}
return results;
}
Although I did all the setups but I was getting below exception
org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: com.helpdesk.domain.Ticket.auditTrails, no session or session was closed
@OneToMany(targetEntity=AuditTrail.class, cascade=CascadeType.ALL)
The above annotation was having one flag missing and that is, fetch=FetchType.EAGER. Add this property in your annotation and enjoy cascade data fetch.
@OneToMany(targetEntity=AuditTrail.class, cascade=CascadeType.ALL, fetch=FetchType.EAGER)
Chillex.
