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 -~----------~----~----~----~------~----~------~--~---
