• 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
  • Junilu Lacar
  • Liutauras Vilda
Sheriffs:
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
Bartenders:
  • Jesse Duncan
  • Frits Walraven
  • Mikalai Zaikin

join problem in hibernate 3.x

 
Ranch Hand
Posts: 261
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hibernate-Version: 3.2.4.sp1

I am a beginner in hibernate, I used to use microsoft sql server T-SQL and there is left outer join, inner join, right outer join keyword. but is it not support in hibernate?

I find left join fetch, right join fetch, inner join fetch keyword in hibernate, is it similar to left outer join, inner join, right outer join in T-Sql?
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
By and large these HQL clauses are synonymous with their SQL equivalent (NB: these are ANSI SQL, not Transact-SQL, they will work on all complient databases).

The difference here is the word "fetch". This is used to support eager fetching, whereby you know you are going to use the data in the associated entity so you tell Hibernate to get it at the same time, rather than relying on lazy fetching. In this way you avoid multiple extra select queries when you access an associated property in your result set. If you turn on sql logging in Hibernate and try the two you'll see the difference.

Be aware that there are restrictions on when you can use eager fetching. Have a read of the documentation to see what these are.
 
peter tong
Ranch Hand
Posts: 261
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I feel the document is for expert user to see!!
it write "the associated objects should not be used in the where clause ..."

then can I write something like
1)"from Supplier s inner join fetch s.products as p where s.products.price > 100";

also, the document write ""Nor should fetch be used together with setMaxResults() or setFirstResult() as these operations are based on the result rows, which usually contain duplicates for eager collection fetching, hence, the number of rows is not what you'd expect."

I cannot understand what it said!! for example, I want to retrieve 1000 rows, even with duplicate record, then can I use .setMaxResults(1000); ??
 
Paul Sturrock
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


then can I write something like
1)"from Supplier s inner join fetch s.products as p where s.products.price > 100";


It doesn't make sense to write what you've written (and it wouldn't make much sense if this were a SQL query either). You've defined a join on products and assigned this association an alias of p, then you've refered to products without using the alias. The only situation where an eager fetch (remember, as I said earlier this is a different thing than a simple join) might need an alias is if you are fetching accross two associated collections. i.e. if products had a collection of items for example.


also, the document write ""Nor should fetch be used together with setMaxResults() or setFirstResult() as these operations are based on the result rows, which usually contain duplicates for eager collection fetching, hence, the number of rows is not what you'd expect."

I cannot understand what it said!! for example, I want to retrieve 1000 rows, even with duplicate record, then can I use .setMaxResults(1000); ??


No. But you can use them if you use a normal join, rather than one that uses eager fetching.
 
peter tong
Ranch Hand
Posts: 261
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
then can I write something like
1)"from Supplier s inner join fetch s.products where s.products.price > 100"; ??

I ask this question becuase the document said "the associated objects should not be used in the where clause ..."

but now I use "...where s.products.price > 100", is it ok?
 
Paul Sturrock
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Not sure what you are asking, these where clauses look the same to me?
 
peter tong
Ranch Hand
Posts: 261
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
the initial statement contain alias "as p"
"from Supplier s inner join fetch s.products as p where s.products.price > 100";

the revised statement move out the alias "as p"
"from Supplier s inner join fetch s.products where s.products.price > 100";

is the revised statement ok?
 
rubbery bacon. rubbery tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic