[h2] Move database files after shutdown

2013-11-10 Thread Mike Goodwin
Hi, I have found I am unable to move the database directory after a shutdown. I have tried waiting, gc(), calling for a shutdown (using the SHUTDOWN sql command). I have made sure there are no more connections open. Is there any expectation that it should be possible to close a database after shu

Re: [h2] Move database files after shutdown

2013-11-10 Thread Ryan How
The database will close when all connections to it are closed. So you must still have some connections open (Are you using a connection pool??) Also see http://h2database.com/html/grammar.html#set_db_close_delay Is there still the lock file present?. If that is still present then there is an o

Re: [h2] Move database files after shutdown

2013-11-11 Thread Mike Goodwin
Hi Ryan, Thanks for the answer. It is helpful to have confirmation that it can be done normally. Pretty sure there are no open connections as I have been counting them in and out (as they open/close), and I don't have the close delay set (and call shutdown in any case). I guess I need to start fr

Re: [h2] Move database files after shutdown

2013-11-11 Thread Ryan How
Do you have any backup software running? On occasion I get backup software locking files while it backs them up and it stops me deleting the file. And I've had anti-virus do the same, but that was mainly with zip files... On 11/11/2013 8:21 PM, Mike Goodwin wrote: Hi Ryan, Thanks for the an