Hi everyone,

I am using Hibernate with Oracle Database with Java.

I have some trouble with the memory.

I have one-to-many association (Table A and Table B) and a huge database ( xxx k of Table B's element )
each day, the data from the Table B will grow ( +200k / day ).
During the data processing, I am doing a tableA.add(tableB elementB) which add a new element of Table B in the Set of one element of Table A.

My association is a lazy one and so when i am doing this, hibernate do the select * query which make me get a beautiful Out of memory exception.
Do you have any suggestion ?