Mailing-List: contact user-help@struts.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Struts Users Mailing List" <user@struts.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
From: "Jerson John" <jerson@cprvision.com>
To: "'Struts Users Mailing List'" <user@struts.apache.org>
References: <003f01cbcf0d$3049f9b0$90dded10$@com>
 <AANLkTimbrxRGJCRhEjPe+JGAW265btF5D=Nno1284XuO@mail.gmail.com>
 <006c01cbcf16$f00439b0$d00cad10$@com>
In-Reply-To: <006c01cbcf16$f00439b0$d00cad10$@com>
Subject: RE: generate SQL Hibernate Query using session
Date: Fri, 18 Feb 2011 11:00:38 +0800
Message-ID: <007901cbcf18$05daa110$118fe330$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcvPFFAUQdg5x2bkTwuGFIr8utRG1gAAihPQAABUS1A=
Content-Language: en-us

Hi,
 By the way My query is below

"select b.Name as brand,a.Name as
eventname,c.Code,a.EventStartDate,a.EventEndDate,a.EventObjective,a.EventTyp
e from ASSET a,Brand b,LPDCOUNTRY c where a.Brand=b.id and a.Country=c.id"

It also says brand property not defined...Is there any syntax error...I
couldn't find any

Thanks in advance

Many Thanks and Regards,

Jerson


From: Jerson John [mailto:jerson@cprvision.com] 
Sent: Friday, February 18, 2011 10:53 AM
To: 'Struts Users Mailing List'
Subject: RE: generate SQL Hibernate Query using session

Hi,
  Thanks for your reply.
Actually I am bit confused here..What I do normally is that get the List of
the model calss from the HQL Query and cast it and iterate it in jsp...Here
If there values from more than one table then I can't cast it to any model
class because of the difference in properties.Please advice me a approach
for this....Thanks in advance

Many Thanks and Regards,

Jerson

-----Original Message-----
From: Dave Newton [mailto:davelnewton@gmail.com] 
Sent: Friday, February 18, 2011 10:34 AM
To: Struts Users Mailing List
Subject: Re: generate SQL Hibernate Query using session

What does having joins have to do with not being able to map to your data
model?

Dave
 On Feb 17, 2011 8:43 PM, "Jerson John" <jerson@cprvision.com> wrote:
> Hi,
> I am trying to generate SQL query using session.createSQLQuery and
> returning the list object..This select query contains joins and so it
cannot
> be mapped to any of my model objects.How can I now get the values in my
jsp
> page using iterator tag in Struts 2...
>
> Please help me on this
>
> Many Thanks and Regards,
>
> Jerson
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org