[Hibernate] Combination of 3 classes and display the result

[edwarddurai <edw...@ho...>]

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
-- 
View this message in context: http://www.nabble.com/Combination-of-3-classes-and-display-the-result-tf1893382.html#a5178062
Sent from the Hibernate forum at Nabble.com.