Hibernate Community • View topic - Select into type safe object: Ordering

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Select into type safe object: Ordering

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

jabriscoe

Post subject: Select into type safe object: Ordering

Posted: Wed Jul 13, 2005 12:09 pm

Newbie

Joined: Thu Jun 09, 2005 12:47 pm
Posts: 5

I have this HQL statement:

Code:

SELECT new caats.SearchSourceResultDTO(source.id, sourceName.companyName, source.county.name) FROM caats.entity.Source as source inner join source.sourceNames as sourceName 

I need to order by companyName, and county.name . When I try to do this:

Code:

SELECT new caats.SearchSourceResultDTO(source.id, sourceName.companyName, source.county.name) as ssrDTO FROM caats.entity.Source as source inner join source.sourceNames as sourceName ORDER BY ssrDTO.id ASC

It fails, even though I have getter "id" in that object. How is it possible to order by a type safe object. I got this idea from the docs where there is an example:

Code:

 or as an actual typesafe Java object
select new Family(mother, mate, offspr)
from eg.DomesticCat as mother
    join mother.mate as mate
    left join mother.kittens as offspr

Thanks in Advance,
Jacob[/code]

Top

pksiv

Post subject: Re: Select into type safe object: Ordering

Posted: Wed Jul 13, 2005 12:11 pm

Expert

Joined: Mon Feb 14, 2005 12:32 pm
Posts: 609
Location: Atlanta, GA - USA

jabriscoe wrote:

I have this HQL statement:

Code:

SELECT new caats.SearchSourceResultDTO(source.id, sourceName.companyName, source.county.name) FROM caats.entity.Source as source inner join source.sourceNames as sourceName 

I need to order by companyName, and county.name . When I try to do this:

Code:

SELECT new caats.SearchSourceResultDTO(source.id, sourceName.companyName, source.county.name) as ssrDTO FROM caats.entity.Source as source inner join source.sourceNames as sourceName ORDER BY ssrDTO.id ASC

It fails, even though I have getter "id" in that object. How is it possible to order by a type safe object. I got this idea from the docs where there is an example:

Code:

 or as an actual typesafe Java object
select new Family(mother, mate, offspr)
from eg.DomesticCat as mother
    join mother.mate as mate
    left join mother.kittens as offspr

Thanks in Advance,
Jacob[/code]

Show the stack trace and mappings and someone might be able to help you.

Top

jabriscoe

Post subject: TypeSafeObject even Possible

Posted: Wed Jul 13, 2005 2:30 pm

Newbie

Joined: Thu Jun 09, 2005 12:47 pm
Posts: 5

My question was; How is it possible to order by a type safe object? If you need mapping information, I can supply that however, I don't feel it is relevant. I'm not asking someone to solve my problem, I'm asking if and how it is possible to order/access a type safe object. The exception I'm experiencing is due to me not knowing how to access this type safe object (caats.SearchSourceResultDTO).

Thanks,
Jacob

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum