Hibernate Community • View topic - Left Join Fetch Query Returning More Rows Than Expected

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Left Join Fetch Query Returning More Rows Than Expected

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

jpalmer

Post subject: Left Join Fetch Query Returning More Rows Than Expected

Posted: Thu Sep 03, 2009 4:41 pm

Newbie

Joined: Fri Jul 17, 2009 10:06 am
Posts: 2

I have a query that should only be returning 1 row but instead is returning multiple rows. I suspect this is due to the fact that I'm using a left join fetch.

My query is as follows:

select d FROM Declaration d
left join fetch d.propertyAddress
left join fetch d.propertyAddress.additionalPins
...

Anyone know why this might be causing a problem?

Top

ejain

Post subject: Re: Left Join Fetch Query Returning More Rows Than Expected

Posted: Thu Sep 03, 2009 9:24 pm

Newbie

Joined: Wed Oct 01, 2008 2:27 pm
Posts: 18

Try:

select distinct d FROM Declaration d ...

Top

Page 1 of 1

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