[hibernate-dev] Transform theta style join to inner join

[Emanuele.Gesuato at finantix.com]

Hi there,

we are using hibernate3 and we would like to change one of the behaviour 
of hibernate in a way to eliminate theta style join in favour of an inner 
or left join.

In some cases theta style join on oracle causes a bug because oracle 
doesn't support "oracle style" FROM caluse ("from a,d") with ANSI ("inner 
join ...").
("http://forums.oracle.com/forums/thread.jspa?threadID=412019")

So, one of the way could be to remove the theta style join in favour of an 
inner join in the sql that should be equivalent.

Not sure if it's the best way to accomplish this task. Looking in the 
source code i've tried to modify DotNode class in a way to avoid implicit 
joins. But running
testcases i discovered i added several regression :(. This is because i'm 
here to ask to the hibernate guru what is the best way (if there is one) 
to accomplish this task.

Thanks for the patience,
Emanuele Gesuato