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.
