I was under the impression that H2 has a simple connection pool built into it. Is there a way to configure H2 to use the built-in connection pool when it hands out connections? Perhaps through the URL?
Bruce On Fri, 2011-04-22 at 01:04 -0700, rado wrote: > Hello, > > What comes to mind as a possible problem is that the Base doesn't use > a connection pool and the database connection is closed/opened several > times. > > Regards > > > On Apr 21, 11:34 pm, Bruce Alspaugh <[email protected]> wrote: > > I have H2 running successfully in a Linode VPS using the Tanuki Service > > Wrappers to run it as a linux daemon process. I am able to connect > > using the web console and the response time is quite good when I connect > > that way even though the Linode is in London and I am in the central > > United States. > > > > Then I tried connecting to the same database using OpenOffice Base. It > > connects, but it is painfully slow. I am using release 1.3.154 on both > > ends of the connection. Is there a reason why connecting through JDBC > > would be so much slower than with the web console? Is there anything I > > can do to speed up the JDBC connection? > > > > OpenOffice Base runs fine when I connect to H2 over a LAN at my office, > > or even if I connect to my office from home using a cable modem at home > > and at the office. > > > > Bruce > -- 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.
