Win a copy of JDBC Workbook this week in the JDBC and Relational Databases forum
or A Day in Code in the A Day in Code 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Hibernate Query by Example

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I'm stuck with a problem.
I want to use Hibernate Query by Example but am getting a problem with my result.
I'm querying over two tables, a parent-child situation.

I have a class called CheckSum and a class called Record.
CheckSum has a set of Record.
When i execute the query, the resultset of CheckSum is equal to all the resultset of Record.
I'm not getting a parent-child resultset.

Thus is CheckSum has {chk01,chk02,chk03}
chk01 has {rec01,rec02}
chk02 has {rec03,rec04,rec05}
chk03 has {rec06,rec07,rec08}

if I query chk02 and all his record I get a list of 3 CheckSum and in all those 3 the same amount of record is repeated.

How does query by example work with joins???

thanks in advance.

 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does Record have a primary key?
 
yusuf nazir
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Paul,

Record does have a primary key and so does checksum

This is the record class:



this is the hibernate record mapping:


This is the checksum class:


this is the checksum hibernate mapping:

 
Bras cause cancer. And tiny ads:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic