Is there a way to reconnect to the DB at all after the sync error?
(Shutdown & restart server, some command line option, etc?)
Would something like this work, in general?
try
{
domySQLcommand();
}
catch(IOError e)
{
//do nothing, just set some state flag that forces it to retry the
same insert command next pass through the loop
}
Basically, it's failing in a loop that inserts rows; there shouldn't
be an issue with retrying an insert with the same data if one fails,
up to some point.
Also, while this is off-topic, the "network drive" isn't; the location
of the database file is on the c:\ drive, same as the server and the
running app. In other words, it can't become "unavailable" if the app
is running in the first place, so I find the error very odd.
--
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.