I am trying to do a recursive fetch join as indicated
http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/queryhql.html.
Quote:
from Cat as cat
inner join fetch cat.mate
left join fetch cat.kittens child
left join fetch child.kittens
But when I do so I get the following error;
ORA-01000 Maximum open cursors exceeded.
The only thing I have been able to find that looked like it might work is setting the following property:
Code:
<property name="statement_cache.size">0</property>
Unfortunately that did not have any effect as I am still seeing the problem.
Anyone else have any other ideas?