Mapping View using Hibernate Spring

[Rizwan Ahmad Khan]

Hi ALL,
This is first time i am posting on JavaRanch.
I have created mapping files for view using hibernate code generator plugin of eclipse . When i query to View i am getting empty list from query object but the view contains data. This is my mapping file

<hibernate-mapping>
    <class name="com.sample.ViewLoginPage" table="ViewLoginPage" schema="FENDEV">
        <composite-id name="id" class="com.sample.ViewLoginPageId">
            <key-property name="cid" type="big_decimal">
                <column name="cId" precision="22" scale="0" />
            </key-property>
            <key-property name="ctype" type="string">
                <column name="cType" length="50" />
            </key-property>
            <key-property name="ctag" type="string">
                <column name="cTag" length="50" />
            </key-property>
            <key-property name="ctagAttr" type="string">
                <column name="cTagAttr" length="50" />
            </key-property>
            <key-property name="cvalue" type="string">
                <column name="cValue" length="300" />
            </key-property>
            <key-property name="cparent" type="big_decimal">
                <column name="cParent" precision="22" scale="0" />
            </key-property>
            <key-property name="cdisplayOrder" type="big_decimal">
                <column name="cDisplayOrder" precision="22" scale="0" />
            </key-property>
        </composite-id>
    </class>
</hibernate-mapping>

And My entity classes is :

public class ViewLoginPage implements java.io.Serializable {

	/**
	 *
	 */
	private static final long serialVersionUID = 1L;
	private ViewLoginPageId id;

	public ViewLoginPage() {
	}

	public ViewLoginPage(ViewLoginPageId id) {
		this.id = id;
	}

	public ViewLoginPageId getId() {
		return this.id;
	}

	public void setId(ViewLoginPageId id) {
		this.id = id;
	}

}

/**
 * ViewLoginPageId generated by hbm2java
 */
public class ViewLoginPageId implements java.io.Serializable {

	private BigDecimal cid;
	private String ctype;
	private String ctag;
	private String ctagAttr;
	private String cvalue;
	private BigDecimal cparent;
	private BigDecimal cdisplayOrder;

	public ViewLoginPageId() {
	}

	public ViewLoginPageId(BigDecimal cid, String ctag, BigDecimal cdisplayOrder) {
		this.cid = cid;
		this.ctag = ctag;
		this.cdisplayOrder = cdisplayOrder;
	}

	public ViewLoginPageId(BigDecimal cid, String ctype, String ctag, String ctagAttr, String cvalue, BigDecimal cparent, BigDecimal cdisplayOrder) {
		this.cid = cid;
		this.ctype = ctype;
		this.ctag = ctag;
		this.ctagAttr = ctagAttr;
		this.cvalue = cvalue;
		this.cparent = cparent;
		this.cdisplayOrder = cdisplayOrder;
	}

	public BigDecimal getCid() {
		return this.cid;
	}

	public void setCid(BigDecimal cid) {
		this.cid = cid;
	}

	public String getCtype() {
		return this.ctype;
	}

	public void setCtype(String ctype) {
		this.ctype = ctype;
	}

	public String getCtag() {
		return this.ctag;
	}

	public void setCtag(String ctag) {
		this.ctag = ctag;
	}

	public String getCtagAttr() {
		return this.ctagAttr;
	}

	public void setCtagAttr(String ctagAttr) {
		this.ctagAttr = ctagAttr;
	}

	public String getCvalue() {
		return this.cvalue;
	}

	public void setCvalue(String cvalue) {
		this.cvalue = cvalue;
	}

	public BigDecimal getCparent() {
		return this.cparent;
	}

	public void setCparent(BigDecimal cparent) {
		this.cparent = cparent;
	}

	public BigDecimal getCdisplayOrder() {
		return this.cdisplayOrder;
	}

	public void setCdisplayOrder(BigDecimal cdisplayOrder) {
		this.cdisplayOrder = cdisplayOrder;
	}

	public boolean equals(Object other) {
		if ((this == other))
			return true;
		if ((other == null))
			return false;
		if (!(other instanceof ViewLoginPageId))
			return false;
		ViewLoginPageId castOther = (ViewLoginPageId) other;

		return ((this.getCid() == castOther.getCid()) || (this.getCid() != null && castOther.getCid() != null && this.getCid().equals(
				castOther.getCid())))
				&& ((this.getCtype() == castOther.getCtype()) || (this.getCtype() != null && castOther.getCtype() != null && this.getCtype().equals(
						castOther.getCtype())))
				&& ((this.getCtag() == castOther.getCtag()) || (this.getCtag() != null && castOther.getCtag() != null && this.getCtag().equals(
						castOther.getCtag())))
				&& ((this.getCtagAttr() == castOther.getCtagAttr()) || (this.getCtagAttr() != null && castOther.getCtagAttr() != null && this
						.getCtagAttr().equals(castOther.getCtagAttr())))
				&& ((this.getCvalue() == castOther.getCvalue()) || (this.getCvalue() != null && castOther.getCvalue() != null && this.getCvalue()
						.equals(castOther.getCvalue())))
				&& ((this.getCparent() == castOther.getCparent()) || (this.getCparent() != null && castOther.getCparent() != null && this
						.getCparent().equals(castOther.getCparent())))
				&& ((this.getCdisplayOrder() == castOther.getCdisplayOrder()) || (this.getCdisplayOrder() != null
						&& castOther.getCdisplayOrder() != null && this.getCdisplayOrder().equals(castOther.getCdisplayOrder())));
	}

	public int hashCode() {
		int result = 17;

		result = 37 * result + (getCid() == null ? 0 : this.getCid().hashCode());
		result = 37 * result + (getCtype() == null ? 0 : this.getCtype().hashCode());
		result = 37 * result + (getCtag() == null ? 0 : this.getCtag().hashCode());
		result = 37 * result + (getCtagAttr() == null ? 0 : this.getCtagAttr().hashCode());
		result = 37 * result + (getCvalue() == null ? 0 : this.getCvalue().hashCode());
		result = 37 * result + (getCparent() == null ? 0 : this.getCparent().hashCode());
		result = 37 * result + (getCdisplayOrder() == null ? 0 : this.getCdisplayOrder().hashCode());
		return result;
	}

}

Can any one tell me why i am getting Empty List object when i query to view the view dose not have any Primary Key field.
this is the method which i am calling

private static void queryPerson(Session session) {
		Query query = session.createSQLQuery("Select cId as id From ViewLoginPage");
		List<ViewLoginPage> list = query.list();

		if (list.size() > 0) {
			System.out.println("list:- " + list.get(0));
		}


		session.getTransaction().commit();

	}