(OpenJPA 1.1, Glassfish, mysql)
Hi, my problem is:
I have a stateful bean with "openjpa.ConnectionRetainMode" - "always" for
handle large relult sets, and with fetch configuration:
Query q = em.createQuery("select m from Account m ");
kq = OpenJPAPersistence.cast(q);
JDBCFetchPlan fetch = (JDBCFetchPlan) kq.getFetchPlan();
fetch.setQueryResultCacheEnabled(false);
fetch.setFetchBatchSize(pageS);
fetch.setResultSetType(ResultSetType.SCROLL_INSENSITIVE);
fetch.setFetchDirection(FetchDirection.FORWARD);
fetch.setLRSSizeAlgorithm(LRSSizeAlgorithm.LAST);
s = kq.getResultList();
It works fine, but in task manager (Windows) grow a memory usage of
Glassfish when i scroll result set. Seems like Glassfish or OpenJPA cache
requested data. After application is closed, memory size freeze and not
decrease.
How to localize a problem?
--
View this message in context:
http://n2.nabble.com/Caching-large-result-set-problem-%28Glassfish-memory-usage-grow%29-tp641198p641198.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
