Package org.h2.tools

Various tools.

Most tools are command line driven, but not all (for example the CSV tool).

Interface Summary

Interface	Description
SimpleRowSource	This interface is for classes that create rows on demand.

Class Summary

Class	Description
Backup	Creates a backup of a database.
ChangeFileEncryption	Allows changing the database file encryption password or algorithm.
CompressTool	A tool to losslessly compress data, and expand the compressed data again.
Console	Starts the H2 Console (web-) server, as well as the TCP and PG server.
ConvertTraceFile	Converts a .trace.db file to a SQL script and Java source code.
CreateCluster	Creates a cluster from a stand-alone database.
Csv	A facility to read from and write to CSV (comma separated values) files.
DeleteDbFiles	Deletes all files belonging to a database.
DirectRecover	Enhanced database recovery tool with streaming and compression support.
GUIConsole	Console for environments with AWT support.
MultiDimension	A tool to help an application execute multi-dimensional range queries.
Recover	Helps recovering a corrupted database.
Restore	Restores a H2 database by extracting the database files from a .zip file.
RunScript	Runs a SQL script against a database.
Script	Creates a SQL script file by extracting the schema and data of a database.
Server	Starts the H2 Console (web-) server, TCP, and PG server.
Shell	Interactive command line tool to access a database using JDBC.
SimpleResultSet	This class is a simple result set and meta data implementation.
SimpleResultSet.SimpleArray	A simple array implementation, backed by an object array
TriggerAdapter	An adapter for the trigger interface that allows to use the ResultSet interface instead of a row array.
Upgrade	Upgrade utility.
ZeroBytesEOFInputStream	A wrapper InputStream that works around the issue where some compressed streams (like Kanzi CompressedInputStream) may return 0 bytes instead of -1 for EOF, causing StreamDecoder to throw "Underlying input stream returned zero bytes".

Enum Summary

Enum	Description
CompressionType	Compression types for SQL output