• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with querying and one to many relationship..

 
Annie Jones
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have the following mappings in my hibernate hbm.xml file (this cannot be changed, the table structure has been decided by the DBA):


We are passing these Postcode objects through to struts instead of having data transfer objects, this is read only data - the application will never modify any postcode/suburb information.

My problem is that I need a query that gives the same result as the following two queries:

but instead of returning Suburb objects and Postcode objects, only returns Postcode objects. As you can see, the first query will return Suburb objects as I am searching on the nzTownCity or nzSuburb columns because the suburbRequiredFlag is set to 'Y' on the Postcode.

I know this seems fairly complicated but if there is a way that I can get only Postcode objects with the matching Suburb objects (instead of all the Suburb objects that are bound to a Postcode because of the one-to-many relationship) then that would be great.

Thanks in advance,
Annie



 
Abraham Gimeno
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't know if I understood well but, have you tried



and since it's ManyToOne you should be able to access Postcode object

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic