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

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