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 know why it shouldn't. Regards, Thomas On Thu, May 30, 2013 at 4:45 PM, Florian Schurke <[email protected]>wrote: > 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 yields in keeping all the big results > in memory. > > My questions are: > - Is this a (known) bug (which might be fixed in a newer version)? > - Is 1.3.172 running in jboss 7.1.1.Final? So may I replace the jar with > the newer one? > > Thank you for your help, > Flo > > > *Detailed information:* > > The jboss-configuration is: > <datasources> > <datasource jndi-name="java:/TestDS" pool-name="TestDS" > enabled="true" use-java-context="true"> > > <connection-url>jdbc:h2:mem:test;REFERENTIAL_INTEGRITY=0;LOG=0;MULTI_THREADED=1;OPTIMIZE_REUSE_RESULTS=0;DB_CLOSE_DELAY=-1;QUERY_CACHE_SIZE=0;DEFAULT_LOCK_TIMEOUT=1000</connection-url> > <driver>h2</driver> > > <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> > <pool> > <min-pool-size>1</min-pool-size> > <max-pool-size>12</max-pool-size> > <prefill>true</prefill> > </pool> > <timeout> > > <blocking-timeout-millis>30000</blocking-timeout-millis> > <idle-timeout-minutes>1</idle-timeout-minutes> > </timeout> > <statement> > > <prepared-statement-cache-size>100</prepared-statement-cache-size> > > <share-prepared-statements>true</share-prepared-statements> > </statement> > </datasource> > <drivers> > <driver name="h2" module="com.h2database.h2"> > > <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> > </driver> > </drivers> > </datasources> > > The reference-chain is the following: > org.h2.jdbc.JdbcPreparedStatement.command > -> org.h2.command.CommandContainer.prepared > -> org.h2.command.dml.Select.topTableFilter > -> org.h2.table.TableFilter.cursor > -> org.h2.index.IndexCursor.cursor > -> org.h2.index.ViewCursor.result > -> org.h2.result.LocalResult containig all the data of the result > > Maybe result in ViewCursor should be set to null after usage? > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en-US. For more options, visit https://groups.google.com/groups/opt_out.
