Hello all, I have tried this with both h2-1.4.196 and a build of the current sources from Git with similar results.
Databases are file-based and H2 runs in embedded mode. I am trying to dump a largish (1.3Gb) PageStore database as SQL to a file by executing "SCRIPT" on a single read-only connection with autocommit, MVCC and MULTI_THREADED set to FALSE ad then writing all rows from the ResultSet to a file. This works fine for all smaller databases but with this database I get either an Out of memory exception or org.h2.jdbc.JdbcSQLNonTransientConnectionException: The database has been closed [90098-197]. This runs on my local machine with no other access to the database. The process heap is already at 2.0G Is there anything I can do to make this work? Or is there a better way to dump a database as an SQL script to an OutputStream? The main function of this code is converting old PageStore databases to MVStore ones. Any ideas? Kind regards, Silvio -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
