Hello,

I must use Criteria and due to performance reasons I need to have `inner join' instead of `left join' in generated SQL.

Mapping is classic many-to-one.

When I use `fetch="join"' I get left join in generated SQL (which is significantly slower than inner join in that specific query)
When I use `fetch="select"' I get 100s of unwanted additional queries

To sum it up: The generated sql will be perfectly ok after s/left join/inner join/

I will be thankful for any help..

Jan Havelka

Im using hibernate 3.0 final, this problem is not database specific..

i need get left join only but hibernate returns my left join and automatic inner join.

Hello,




any details? What hibernate version are you using and what are your attributes in mapping (probably many-to-one)?
Im not able to have inner join in final SQL query without HQL...

Hibernate version: 2.1.8

Yes, I need make 3 outer joins with many-to-one but Hibernate don´t undestand and return SQL with my outer join and automatic inner join.

I have any entities with more then 8 relationships. Each relationship have others relationships. When i using hibernate metohd get() by ID, hibernate need many queries for return my entity. To decide this problem, i use hibernate method find(HQL) in following format:

select A.Id, A.Name, A.CelPhone, A.B.Id, A.B.Description where A, B where A.B.Id = B.Id(+)

I testing .....where left outer join A.B.Id and ....from A left outer join B but had not results different.

I have SOME entities with more then 8 relationships, not all!

lol

My english is bad!