This content has been marked as final.
Show 2 replies
-
1. Re: Power Failure causing java.sql.SQLException
hbaxmann Jun 2, 2004 12:12 PM (in response to dmorris1238)- use a true (transactional) _DataBase_, not MySQL _and_not_ hsqldb
- have your DB on another machine
- have a recovery procedure for your DB (may last hours in case of Oracle ;-)
JBoss can not guaranty ACID if the underlying system is not able of.
bax -
2. Re: Power Failure causing java.sql.SQLException
genman Jun 2, 2004 1:19 PM (in response to dmorris1238)
If you use HSQL and the .script file is corrupted (look at the end), simply edit off the last lines in the script and restart. You can test this by using the HSQL client program to connect to the database and do a SHUTDOWN COMPACT.
Which filesystem are you using?