I have the same problem. I want to export 20000 customers in an XML file. If I do it with a single transaction I get a transaction time out, if I do it with a transaction for each customer I get an OutOfMemory.
will anybody help me
thanks in advance
i guess if you reduce the read-ahead page size and the number of instances in entity cache you should overcome this problem. essentially, you should tell the container to cache fewer entities. i might be wrong, but you can try fiddling around with these settings
I have solved the problem for now by providing more heap to the JVM. I guess the best solution would be a transaction for every single bean in combination with the commit option "C". But when I do so, some new error occur (locking problems). Somewhere I'v read, this problem is known with the commit option "C".