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 <[email protected]
<mailto:[email protected]>> 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 [email protected]
<mailto:h2-database%[email protected]>.
To post to this group, send email to
[email protected]
<mailto:[email protected]>.
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 [email protected]
<mailto:h2-database%[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
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 [email protected].
To post to this group, send email to [email protected].
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
