Hi, Could you post the complete error message with all stack traces? How large was the database file at that time? What database URL did you use, and how did you try to import? How did you start the Java process?
The exception "java.io.IOException: Insufficient system resources exist to complete" sounds like a resource or file system problem, something outside of the control of the database. I found this issue: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4938442 About the performance: there are some tricks, for example CREATE TABLE AS ... - see also http://h2database.com/html/performance.html#fast_import , and possibly the "Sorted Insert Optimization" higher up on that page. Also, possibly the 32-bit version of Java is faster / uses less resources. Regards, Thomas -- 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.
