I have two table
1)application(application_id(pk),application_type,application_date,......,................,............)
2)application_survey(application_survey_id,application_id(fk),survey_no,resurvey_no,...............,..................,....................)

Here application_survey table includes multiple entries corresponding to application_id.

So I have created veiw

CREATE OR REPLACE VIEW v_application_survey AS
SELECT application_survey.application_id, string_agg(application_survey.survey_no::text,
CASE
WHEN btrim(application_survey.survey_no::text) = ''::text OR application_survey.survey_no IS NULL THEN ''::text
ELSE ','::text
END) AS survey_no, string_agg(application_survey.resurvey_no::text,
CASE
WHEN btrim(application_survey.resurvey_no::text) = ''::text OR application_survey.resurvey_no IS NULL THEN ''::text
ELSE ','::text
END) AS resurvey_no
FROM application_survey
GROUP BY application_survey.application_id;

ALTER TABLE v_application_survey OWNER TO postgres;



Then I need query

select* from application
left join v_application_survey on(v_application_survey.application_id=application.application_id),

using hibernate criteria query.Is it possible.If possible please reply with example.

Corresponding pojo class for v_application_survey is as follows

public class VApplicationSurvey implements java.io.Serializable {

private VApplicationSurveyId id;

public VApplicationSurvey() {
}

public VApplicationSurvey(VApplicationSurveyId id) {
this.id = id;
}

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

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

}

Corresponding mapping file for v_application_survey is as follows

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Aug 1, 2013 10:36:46 AM by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="nic.mams.model.VApplicationSurvey" table="v_application_survey" schema="public">
<composite-id name="id" class="nic.mams.model.VApplicationSurveyId">
<key-property name="applicationId" type="java.lang.Long">
<column name="application_id" />
</key-property>
<key-property name="surveyNo" type="string">
<column name="survey_no" />
</key-property>
<key-property name="resurveyNo" type="string">
<column name="resurvey_no" />
</key-property>
</composite-id>
</class>
</hibernate-mapping>