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.
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
