LocalResult hold by PreparedStatement consumes a lot of Memory

2013-05-30 Thread Florian Schurke
Hi all, we are using a H2 database (1.3.161) embedded in jboss 7.1.1.Final. We wanted to cache the prepared queries but without caching the result of it. Therefore we set OPTIMIZE_REUSE_RESULTS=0. But unfortunately there is another reference-chain from the PreparedStatement to its result. This y

[h2] Re: LocalResult hold by PreparedStatement consumes a lot of Memory

2013-05-31 Thread Thomas Mueller
Hi, > Is this a (known) bug (which might be fixed in a newer version)? To find out, you could check the change log at http://www.h2database.com/html/changelog.html - but it's probably easier if you test it. > Is 1.3.172 running in jboss 7.1.1.Final? I never heard it doesn't run, and wouldn't kn

[h2] Re: LocalResult hold by PreparedStatement consumes a lot of Memory

2017-05-13 Thread Vitali
One of test cases I have written recently has failed with OOM. It actually tests some SELECT logic loading "heavy" records with large binary objects (geometries). Investigation that I have done showed exactly the described below case: prepared statements (every SELECT in my test produces a

Re: [h2] Re: LocalResult hold by PreparedStatement consumes a lot of Memory

2017-05-14 Thread Noel Grandin
probably what is easier to set QUERY_CACHE_SIZE to zero: https://www.h2database.com/javadoc/org/h2/engine/DbSettings.html#QUERY_CACHE_SIZE ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving email