Hi, > FetchSize to 10 - stmt.setFetchSize(10) > These options seem to have no effect for the H2 JDBC driver since all > results still seem to be loading into memory - shouldn't this > combination "stream" the results?
If using the server mode (remote connections) then yes. What is your database URL? > I am INSERTING rows into a few tables and then executing a SELECT > query made up of 8 LEFT JOINS on a very large database. The INSERT > goes well but when I execute the SELECT Statement, an OutOfMemory > exception is thrown. How many rows are in the result set? 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 -~----------~----~----~----~------~----~------~--~---
