Re: [Hibernate] Combination of 3 classes and display the result

[Emmanuel B. <emm...@hi...>]

This is the Hibernate developement mailing list

Please go to the user forum for such questions
http://forum.hibernate.org


edwarddurai wrote:
> Hi,
>
> I have 3 tables in MSSQL Database.
>
> 1. Auditfinding
> 2. AuditfindingsDisplayName
> 3. AuditFindingsFieldList
>
> Fine. I have Created Mapping Files And Java Bean files(Using getter and
> setter methods)
>
> My Hibernate Query is Working Perfectly.
>
> My Query is:
>
> select distinct Id as AuditId,substring(substring(CustomIssueField,
> patindex('%data_27="%',CustomIssueField)+9
> ,len(CustomIssueField)),1,patindex('%"%',substring(CustomIssueField,
> patindex('%data_27="%',CustomIssueField)+9 ,len(CustomIssueField)))-1) as
> [CustomIssueField], DisplayName from Auditfindingsfieldlist
> X,Auditfindingsdisplayname Y, Auditfinding where x.fieldid>25 and
> y.fieldid=x.fieldid
>
> Code is:
> ======================================================
> SQLQuery query = session.createSQLQuery("select distinct Id,
> substring(substring(CustomIssueField,
> patindex('%data_27=\"%',CustomIssueField)+9
> ,len(CustomIssueField)),1,patindex('%\"%',substring(CustomIssueField,
> patindex('%data_27=\"%',CustomIssueField)+9 ,len(CustomIssueField)))-1) as
> [CustomIssueField], DisplayName from Auditfindingsfieldlist
> X,Auditfindingsdisplayname Y, Auditfinding where x.fieldid>25 and
> y.fieldid=x.fieldid");
>
> query.addScalar("Id",Hibernate.INTEGER);
> query.addScalar("CustomIssueField",Hibernate.STRING);
> query.addScalar( "DisplayName", Hibernate.STRING);
> usrlist = query.list();
> =================================================
> I am Using Three tables from above
>
> The result is display like
>
> [Ljava.lang.Object;@24bef5
> [Ljava.lang.Object;@74d22e
> [Ljava.lang.Object;@192ee25
> [Ljava.lang.Object;@150cf54
> [Ljava.lang.Object;@5bc8c9
>
> I want to display id, customissuefield, displayname
>
> How can I fetch from List (List contains combines three tables/classes)
>
> Thanks
> edward
>