How can I limit ANSI joins (resulting column #) in queries?

[tomcoker]

I've hit an Oracle bug (Bug 4369235 - ANSI joins may fail with ORA-1445) and I'm trying to find a work around. The bug causes a query to fail when the SQL that is generated contains more than 1050 columns.

I would like to limit the # of columns or the # of joins that result from querying an entity.

Any ideas? I'm using JBoss 4.0.3SP1 w/ EJB3.0 RC5

[tomcoker]

I couldn't find this before, but I guess posting a question always raises the possibility of finding it in the doc.

hibernate.max_fetch_depth - Set a maximum "depth" for the outer join fetch tree for single-ended associations (one-to-one, many-to-one). A 0 disables default outer join fetching. eg. recommended values between 0 and 3.