You could try running a backup or a script to, then copy that and import it?
I quite often don't close a H2 database and very rarely lose data.
Actually in my dev environment I never close it, that's one thing I love
about it :). Are you sure it's copying the right file?. Do the values
show up after a while?, or if you close the database?
What if you explicitly call commit just to make sure?.
And it can be dangerous copying an in-use file incase it is changed
while copying. But it sounds like if it is only updated once an hour it
would be pretty safe :). You could just close the database inbetween and
copy it while closed?
On 14/02/2013 3:54 AM, Marc Fisher wrote:
I have a very strange issue I am running in to. I have a Java program
which has a TimerTask executing once every hour. Each execution it
updates a couple rows in the database. When I copy the database file
and then open it via the H2 Console, the values for those rows do not
appear updated however dumping the values to the command line in the
Java program shows them as updated values. So I know the updates are
correctly occurring but I would like the ability to grab the database
file from a remote system, copy it over, and see the values at any
time. I am running autoCommit(true) as well as explicitly
calling CHECKPOINT SYNC.
Any ideas?
Thanks
--
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?hl=en.
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
