Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

One join too many?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

ivo.houbrechts

Post subject: One join too many?

Posted: Fri Nov 21, 2003 8:36 am

Newbie

Joined: Thu Nov 06, 2003 8:28 am
Posts: 8

I have a bidirectional many-to-many between Folder and Record and a class Test that extends Record.
Following HQL

Code:

select test.stringfield from Test test join test.folders folder where folder.id=?

creates following SQL

Code:

select test0_.stringfield as x0_0_ from S_Test test0_ inner join Record test0__1_ on test0_.id=test0__1_.id inner join folder_records folders1_ on test0_.id=folders1_.record_id inner join Folder folder2_ on folders1_.folder_id=folder2_.id where (folder2_.id=? )

Isn't the join on the collection table folder_records enough?
Maybe it is not possible for Hibernate to figure out that the join on Folder is not needed?

PS: In fact the join on Record is also not needed, but I can imagine that leaving that one out would make things too complex.
Ivo Houbrechts

Top

gavin

Post subject:

Posted: Fri Nov 21, 2003 8:50 am

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

Try:

Code:

select test.stringfield from Test test where ? in elements( test.folders )

and see if it as faster (if you have subqueries available).

Otherwise you would have to sue a composite element instead.

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