My connection string is "jdbc:h2:file:c:\\db/tesh2;CACHE_SIZE=50000". I think, my database stored on disk.
On May 25, 10:53 am, Steve McLeod <[email protected]> wrote: > Hi Alexander, > > Can you post your database connection url? > > My guess is that you have an in-memory database and are using the > default Java memory configuration. If that's the case, you'll need to > start up your program with increased heap size. > > Regards, > > Steve > > On May 24, 10:04 pm, "Alexander.Sirenko" <[email protected]> > wrote: > > > Hello, > > I have some large table > > wordforms(key INT NOT NULL PRIMARY KEY AUTO_INCREMENT, > > key_base INT, > > name VARCHAR(50), > > type VARCHAR(10), > > isProcessed BOOLEAN ) > > with about 1 300 000 entries. > > > In my Java program I make query "SELECT key FROM wordforms" to get all > > keys. > > Executing query causes exception: > > > Exception in thread "Thread-7" java.lang.OutOfMemoryError: Java heap > > space > > at org.h2.value.Value.cache(Value.java:338) > > at org.h2.value.ValueString.get(ValueString.java:91) > > at org.h2.store.DataPage.readValue(DataPage.java:623) > > at org.h2.table.TableData.readRow(TableData.java:620) > > at org.h2.table.TableData.read(TableData.java:607) > > at org.h2.store.DiskFile.getRecord(DiskFile.java:595) > > at org.h2.store.Storage.getRecord(Storage.java:94) > > at org.h2.index.ScanIndex.getNextRow(ScanIndex.java:258) > > at org.h2.index.ScanCursor.next(ScanCursor.java:71) > > at org.h2.table.TableFilter.next(TableFilter.java:318) > > at org.h2.command.dml.Select.queryFlat(Select.java:491) > > at org.h2.command.dml.Select.queryWithoutCache(Select.java: > > 559) > > at org.h2.command.dml.Query.query(Query.java:233) > > at org.h2.command.CommandContainer.query(CommandContainer.java: > > 81) > > at org.h2.command.Command.executeQueryLocal(Command.java:141) > > at org.h2.command.Command.executeQuery(Command.java:122) > > at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java: > > 75) > > > // NetBeans error message > > > I use h2.1.1.111 in embedded mode. > > I tried different CACHE_SIZE from CACHE_SIZE=25000 to > > CACHE_SIZE=200000 > > > Database includes other tables and it is more than 1.5Gb --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
