1 Reply Latest reply on Mar 8, 2006 3:00 PM by Tom Coker

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

    Tom Coker Newbie

      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