I forgot to add that it's H2's connection pool that I'm using On Feb 25, 5:13 pm, bnschps <[email protected]> wrote: > I'm struggling to find a method of closing a connection pool > > closing the connection is fine because it's called like: > conn = getConnection(); (gets connection from pool) > ..... > conn.close(); > > but the connection pool has not been disposed and I'm not sure where I > can close it in a nice way > I'm not entirely sure how servlet listeners work. There will be > multiple databases to connect to so could they still be used to open > and close connections? > > thanks > > On Feb 22, 7:19 am, rado <[email protected]> wrote: > > > Hello, > > > I think the database is closed automatically when the last connection > > is closed. > > > There could be several problems with your approach: > > 1 - You should not depend on the finalize. There is no guarantee it > > will be ever called on war redeployment. > > Better to have a servlet listener and listen for application destroy. > > 2 - Check that code closes used connections in all situations - close > > them in a finally{} block. > > 3 - I don't know which connection pool you use, but check that it > > closes all connections when you say it so. > > > Regards, > > Rado > > > On Feb 21, 9:07 pm, bnschps <[email protected]> wrote: > > > > Thanks, I've since started it in mixed mode using auto_server=true > > > > My only problem seems to be with closing the database. > > > Sometimes (frequently in my case :) ) the war file for my program is > > > reinstalled and I think the connection to 'xx' database is being left > > > open, as I end up getting a database is already in use error > > > (Database may be already in use: Locked by another process). > > > > What I'm doing is starting a connection pool when my db class is > > > initialised and calling dispose in the finalize (and conn.close if > > > it's open). > > > The connection object is closed after being used e.g. > > > > this.conn = this.cp.getConnection(); > > > xxxx > > > this.conn.close(); > > > > but as I say I think it's being left open in those occassions. > > > Is there a way I can close any open connections or call shutdown > > > somehow > > > > I did try calling shutdown but as it couldn't connect it didn't seem > > > to be run > > > > thanks > > > Alex > > > > On Feb 18, 7:35 am, Thomas Mueller <[email protected]> > > > wrote: > > > > > Hi, > > > > > > currently I have it using embedded mode > > > > > multiple tutors or students could be > > > > > accessing a database at the same time > > > > > H2 supports both embedded mode, server mode, and mixed mode. I guess > > > > in your case the server mode would be the easiest to maintain. See > > > > alsohttp://h2database.com/html/features.html#connection_modes > > > > > 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.
