HI, Te listener is configured in web.xml - it is very simple to use, but better to check the servlet specification for details.
To close the pool use its method dispose() Regards, Rado On Feb 25, 2:33 pm, bnschps <[email protected]> wrote: > 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.
