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
>
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
