Hi Thomas, Thanks for the reply.
You have answered my questions "If using the server mode (remote connections) then yes" - I am using embedded mode. BTW, why the "limitation" when using embedded mode? Thanks, Jorge On Feb 25, 8:30 pm, Thomas Mueller <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
