Re: [h2] Move database files after shutdown
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 from the simplest possible case and get that working first. I have had other problems with deleting files from java on windows 7. - mike On Mon, Nov 11, 2013 at 5:16 AM, Ryan How r...@exemail.com.au wrote: 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 open connection somewhere I close and open my databases all the time from the same JVM and copy them around, so it does work. On 11/11/2013 8:13 AM, Mike Goodwin wrote: 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 shutting it down? Has anyone succeeded in doing so? - mike -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
Re: [h2] Move database files after shutdown
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 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 from the simplest possible case and get that working first. I have had other problems with deleting files from java on windows 7. - mike On Mon, Nov 11, 2013 at 5:16 AM, Ryan How r...@exemail.com.au mailto:r...@exemail.com.au wrote: 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 open connection somewhere I close and open my databases all the time from the same JVM and copy them around, so it does work. On 11/11/2013 8:13 AM, Mike Goodwin wrote: 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 shutting it down? Has anyone succeeded in doing so? - mike -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com mailto:h2-database%2bunsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com mailto:h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com mailto:h2-database%2bunsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com mailto:h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
Re: [h2] Move database files after shutdown
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 open connection somewhere I close and open my databases all the time from the same JVM and copy them around, so it does work. On 11/11/2013 8:13 AM, Mike Goodwin wrote: 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 shutting it down? Has anyone succeeded in doing so? - mike -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.