Package org.h2.tools
Class Recover
- java.lang.Object
-
- org.h2.util.Tool
-
- org.h2.tools.Recover
-
- All Implemented Interfaces:
org.h2.store.DataHandler
public class Recover extends org.h2.util.Tool implements org.h2.store.DataHandler
Helps recovering a corrupted database.
-
-
Constructor Summary
Constructors Constructor Description Recover()
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description void
checkPowerOff()
INTERNALvoid
checkWritingAllowed()
INTERNALstatic void
execute(java.lang.String dir, java.lang.String db)
Dumps the contents of a database to a SQL script file.org.h2.value.CompareMode
getCompareMode()
Return compare mode.java.lang.String
getDatabasePath()
INTERNALorg.h2.util.SmallLRUCache<java.lang.String,java.lang.String[]>
getLobFileListCache()
INTERNALorg.h2.store.LobStorageInterface
getLobStorage()
INTERNALjava.lang.Object
getLobSyncObject()
INTERNALint
getMaxLengthInplaceLob()
INTERNALorg.h2.util.TempFileDeleter
getTempFileDeleter()
INTERNALstatic void
main(java.lang.String... args)
Options are case sensitive.org.h2.store.FileStore
openFile(java.lang.String name, java.lang.String mode, boolean mustExist)
INTERNALstatic java.io.InputStream
readBlobMap(java.sql.Connection conn, long lobId, long precision)
INTERNALstatic java.io.Reader
readClobMap(java.sql.Connection conn, long lobId, long precision)
INTERNALint
readLob(long lobId, byte[] hmac, long offset, byte[] buff, int off, int length)
INTERNALvoid
runTool(java.lang.String... args)
Dumps the contents of a database file to a human readable text file.
-
-
-
Method Detail
-
main
public static void main(java.lang.String... args) throws java.sql.SQLException
Options are case sensitive.Supported options [-help] or [-?] Print the list of options [-dir <dir>] The directory (default: .) [-db <database>] The database name (all databases if not set) [-trace] Print additional trace information [-transactionLog] Print the transaction log - Parameters:
args
- the command line arguments- Throws:
java.sql.SQLException
- on failure
-
runTool
public void runTool(java.lang.String... args) throws java.sql.SQLException
Dumps the contents of a database file to a human readable text file. This text file can be used to recover most of the data. This tool does not open the database and can be used even if the database files are corrupted. A database can get corrupted if there is a bug in the database engine or file system software, or if an application writes into the database file that doesn't understand the file format, or if there is a hardware problem.- Specified by:
runTool
in classorg.h2.util.Tool
- Parameters:
args
- the command line arguments- Throws:
java.sql.SQLException
- on failure
-
readBlobMap
public static java.io.InputStream readBlobMap(java.sql.Connection conn, long lobId, long precision) throws java.sql.SQLException
INTERNAL- Parameters:
conn
- to uselobId
- id of the LOB streamprecision
- not used- Returns:
- InputStream to read LOB content from
- Throws:
java.sql.SQLException
- on failure
-
readClobMap
public static java.io.Reader readClobMap(java.sql.Connection conn, long lobId, long precision) throws java.lang.Exception
INTERNAL- Parameters:
conn
- to uselobId
- id of the LOB streamprecision
- not used- Returns:
- Reader to read LOB content from
- Throws:
java.sql.SQLException
- on failurejava.lang.Exception
-
execute
public static void execute(java.lang.String dir, java.lang.String db) throws java.sql.SQLException
Dumps the contents of a database to a SQL script file.- Parameters:
dir
- the directorydb
- the database name (null for all databases)- Throws:
java.sql.SQLException
- on failure
-
getDatabasePath
public java.lang.String getDatabasePath()
INTERNAL- Specified by:
getDatabasePath
in interfaceorg.h2.store.DataHandler
- Returns:
- the database path
-
openFile
public org.h2.store.FileStore openFile(java.lang.String name, java.lang.String mode, boolean mustExist)
INTERNAL- Specified by:
openFile
in interfaceorg.h2.store.DataHandler
- Parameters:
name
- the file namemode
- the modemustExist
- whether the file must already exist- Returns:
- the file
-
checkPowerOff
public void checkPowerOff()
INTERNAL- Specified by:
checkPowerOff
in interfaceorg.h2.store.DataHandler
-
checkWritingAllowed
public void checkWritingAllowed()
INTERNAL- Specified by:
checkWritingAllowed
in interfaceorg.h2.store.DataHandler
-
getMaxLengthInplaceLob
public int getMaxLengthInplaceLob()
INTERNAL- Specified by:
getMaxLengthInplaceLob
in interfaceorg.h2.store.DataHandler
- Returns:
- the maximum size
-
getLobSyncObject
public java.lang.Object getLobSyncObject()
INTERNAL- Specified by:
getLobSyncObject
in interfaceorg.h2.store.DataHandler
- Returns:
- the synchronization object
-
getLobFileListCache
public org.h2.util.SmallLRUCache<java.lang.String,java.lang.String[]> getLobFileListCache()
INTERNAL- Specified by:
getLobFileListCache
in interfaceorg.h2.store.DataHandler
- Returns:
- the cache or null
-
getTempFileDeleter
public org.h2.util.TempFileDeleter getTempFileDeleter()
INTERNAL- Specified by:
getTempFileDeleter
in interfaceorg.h2.store.DataHandler
- Returns:
- the temp file deleter
-
getLobStorage
public org.h2.store.LobStorageInterface getLobStorage()
INTERNAL- Specified by:
getLobStorage
in interfaceorg.h2.store.DataHandler
- Returns:
- the lob storage mechanism
-
readLob
public int readLob(long lobId, byte[] hmac, long offset, byte[] buff, int off, int length)
INTERNAL- Specified by:
readLob
in interfaceorg.h2.store.DataHandler
- Parameters:
lobId
- the lob idhmac
- the message authentication codeoffset
- the offset within the lobbuff
- the target bufferoff
- the offset within the target bufferlength
- the number of bytes to read- Returns:
- the number of bytes read
-
getCompareMode
public org.h2.value.CompareMode getCompareMode()
Description copied from interface:org.h2.store.DataHandler
Return compare mode.- Specified by:
getCompareMode
in interfaceorg.h2.store.DataHandler
- Returns:
- Compare mode.
-
-