Win a copy of Rust Web Development this week in the Other Languages forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

Join Table many-to-one issue

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I posted this on the hibernate forum, but no help. Sorry for the repost.

I have 3 tables:



My main table is PTNT_DATA_MSRMNT_CLCTN & join table is PTNT_PRCTC_PRFMNC_YR. I want to join these 2 tables by a non-primary key in the main table (PTNT_PRCTC_PRFMNC_YR_ID), but this does not work.

Hibernate Mapping:



The Hibernate generated SQL is:

where ptntdata.PTNT_DATA_MSRMNT_CLCTN_ID=prfmncyr.PTNT_PRCTC_PRFMNC_YR_ID.

But It should rather be
ptntdata.PTNT_PRCTC_PRFMNC_YR_ID=prfmncyr.PTNT_PRCTC_PRFMNC_YR_ID.


Hibernate version : 3.2.7.ga

Can you guys help me on this. Hope my question is clear & understandable
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic