Due to abnormal power outage, the h2 database file was damaged, and the exception prompt is:
java.lang.IllegalStateException: File corrupted in chunk 1546880 not found [1.4.200/9] [50000-200] HY000/50000
Try using:java -cp h2-1.4.200.jar org.h2.tools.Recover
The damaged database file is 640MB, and the generated SQL file is only 15KB. Then run:
java -cp h2-1.4.200.jar org.h2.tools.RunScript -url jdbc:h2:./snsdba -user sns -password sns - script snsdb.h2.sql
The generated snsdba.db file is only 16KB, which is why I need to know how to fix my database file.
Thank you very much!!!