package com.nyl.ie2.model;
import java.util.Date;
import java.util.List;
/**
* @author Marcin Czauz
*/
public class ERMEvent extends Event {
private List statusHistoryCollection;
//private Status status;
private DmsMetadata dmsMetadata;
private FilenetMetadata filenetMetadata;
private CenteraMetadata centeraMetadata;
private Date newRetentionDate;
private long requestId;
private long messageId;
/**
* @return Returns the messageId.
*/
public long getMessageId() {
return messageId;
}
/**
* @param messageId The messageId to set.
*/
public void setMessageId(long messageId) {
this.messageId = messageId;
}
/**
* @return Returns the centeraMetadata.
*/
public CenteraMetadata getCenteraMetadata() {
return centeraMetadata;
}
/**
* @param centeraMetadata The centeraMetadata to set.
*/
public void setCenteraMetadata(CenteraMetadata centeraMetadata) {
this.centeraMetadata = centeraMetadata;
}
/**
* @return Returns the dmsMetadata.
*/
public DmsMetadata getDmsMetadata() {
return dmsMetadata;
}
/**
* @param dmsMetadata The dmsMetadata to set.
*/
public void setDmsMetadata(DmsMetadata dmsMetadata) {
this.dmsMetadata = dmsMetadata;
}
/**
* @return Returns the newRetentionDate.
*/
public Date getNewRetentionDate() {
return newRetentionDate;
}
/**
* @param newRetentionDate The newRetentionDate to set.
*/
public void setNewRetentionDate(Date newRetentionDate) {
this.newRetentionDate = newRetentionDate;
}
/**
* @return Returns the requestType.
*/
public long getRequestId() {
return requestId;
}
/**
* @param requestType The requestType to set.
*/
public void setRequestId(long requestType) {
this.requestId = requestType;
}
/**
* @return Returns the statusHistoryCollection.
*/
public List getStatusHistoryCollection() {
return statusHistoryCollection;
}
/**
* @param statusHistoryCollection The statusHistoryCollection to set.
*/
public void setStatusHistoryCollection(List statusHistoryCollection) {
this.statusHistoryCollection = statusHistoryCollection;
}
/**
* @return Returns the filenetMetadata.
*/
public FilenetMetadata getFilenetMetadata() {
return filenetMetadata;
}
/**
* @param filenetMetadata The filenetMetadata to set.
*/
public void setFilenetMetadata(FilenetMetadata filenetMetadata) {
this.filenetMetadata = filenetMetadata;
}
/**
* @return Returns the status.
*/
/*public Status getStatus() {
return status;
}*/
/**
* @param status The status to set.
*/
/*public void setStatus(Status status) {
this.status = status;
}*/
}
package com.nyl.ie2.model;
import java.util.Date;
/**
* @author Marcin Czauz
*/
public abstract class Event {
private Date dateCreated;
private Status status;
private long id;
/**
* @return Returns the dateCreated.
*/
public Date getDateCreated() {
return dateCreated;
}
/**
* @param dateCreated The dateCreated to set.
*/
public void setDateCreated(Date dateCreated) {
this.dateCreated = dateCreated;
}
/**
* @return Returns the id.
*/
public long getId() {
return id;
}
/**
* @param id The id to set.
*/
public void setId(long id) {
this.id = id;
}
/**
* @return Returns the staus.
*/
public Status getStatus() {
return status;
}
/**
* @param staus The staus to set.
*/
public void setStatus(Status staus) {
this.status = staus;
}
}
package com.nyl.ie2.model;
import java.util.Date;
/**
* @author Marcin Czauz
*/
public class Status {
private Date date;
private String description;
StatusType statusType;
/**
* @return Returns the date.
*/
public Date getDate() {
return date;
}
/**
* @param date The date to set.
*/
public void setDate(Date date) {
this.date = date;
}
/**
* @return Returns the description.
*/
public String getDescription() {
return description;
}
/**
* @param description The description to set.
*/
public void setDescription(String description) {
this.description = description;
}
/**
* @return Returns the statusType.
*/
public StatusType getStatusType() {
return statusType;
}
/**
* @param statusType The statusType to set.
*/
public void setStatusType(StatusType statusType) {
this.statusType = statusType;
}
}
package com.nyl.ie2.model;
/**
* @author Rolando Garcia
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class StatusType {
private long id;
private String statusCode;
/**
*
*/
public StatusType() {
super();
// TODO Auto-generated constructor stub
}
/**
* @return Returns the id.
*/
public long getId() {
return id;
}
/**
* @param id The id to set.
*/
public void setId(long id) {
this.id = id;
}
/**
* @return Returns the statusCode.
*/
public String getStatusCode() {
return statusCode;
}
/**
* @param statusCode The statusCode to set.
*/
public void setStatusCode(String statusCode) {
this.statusCode = statusCode;
}
}
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.nyl.ie2.model.ERMEvent" table="PENDING_TRANSACTIONS">
<id name="id" type="long" column="TRANSACTION_ID">
<generator class="identity"/>
</id>
<!-- Common properties -->
<property name="dateCreated" column="REQUEST_TM"/>
<property name="messageId" column="MESSAGE_ID"/>
<property name="requestId" column="REQUEST_ID"/>
<component name="status" class="com.nyl.ie2.model.Status">
<property name="date" column="STATUS_TM"/>
<property name="description" column="STATUS_DN"/>
<component name="statusType" class="com.nyl.ie2.model.StatusType">
<property name="id" column="STATUS_ID"/>
</component>
</component>
<!-- Object specific -->
<property name="newRetentionDate" column="RETENTION_REVISED_DT"/>
<!-- DMS Metadata object -->
<component name="dmsMetadata" class="com.nyl.ie2.model.DmsMetadata">
<property name="folderNumber" column="FOLDER_NO"/>
<property name="businessType" column="DOCUMENT_TYPE_CD"/>
</component>
<!-- Filenet Metadata object -->
<component name="filenetMetadata" class="com.nyl.ie2.model.FilenetMetadata">
<property name="documentId" column="DOCUMENT_ID"/>
</component>
<!-- Centera Metadata object -->
<component name="centeraMetadata" class="com.nyl.ie2.model.CenteraMetadata">
<property name="clipId" column="CLIP_ID"/>
<property name="retentionDate" column="RETENTION_INITIAL_DT"/>
</component>
</class>
</hibernate-mapping>
Here is the method...
public static ERMEvents getERMPendingEvents() throws IE2DAOException
{
try {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
ArrayList oRecords = new ArrayList();
session.beginTransaction();
String queryStr = "'%Pending%'";
// String test="from ERMEvent as e join e.status as s join s.statusType as t where t.statusCode like " + queryStr;
String test="from ERMEvent as e join e.status.statusType.id where e.status.statusType.statusCode like " + queryStr;
System.out.println(test);
Query query = session.createQuery(test);
System.out.println("Bad item");
//Query query = session.createQuery("from ERMEvent e join e.status.statusType.id WHERE e.status.statusType.statusCode LIKE " + queryStr);
if (query==null) {
System.out.println("Bad item");
}
System.out.println("Size " + query.getQueryString());
ArrayList list = (ArrayList) query.list();
for (int index=0; index < list.size(); index++){
ERMEvent obj = (ERMEvent)list.get(index);
System.out.println("Name " + obj.getId() + " Desc " + obj.getStatus().getDescription());
oRecords.add(obj);
}
session.getTransaction().commit();
return (new ERMEvents(oRecords));
} catch (Exception e) {
e.printStackTrace();
throw new IE2DAOException("Error on getERMPendingEvents " + e.getMessage());
}
}
Login
FAQ
Search
