Shell

Interactive command line tool to access a database using JDBC.

Methods
static void main(String... args)
Options are case sensitive.
static void main(String... args) throws SQLException
Options are case sensitive. Supported options are:
[-help] or [-?] Print the list of options
[-url "<url>"] The database URL (jdbc:h2:...)
[-user <user>] The user name
[-password <pwd>] The password
[-driver <class>] The JDBC driver class to use (not required in most cases)
[-sql "<statements>"] Execute the SQL statements and exit
[-properties "<dir>"] Load the server properties from this directory
If special characters don't work as expected, you may need to use -Dfile.encoding=UTF-8 (Mac OS X) or CP850 (Windows).
Parameters:
args - the command line arguments
void print(String s)
Print the string without newline, and flush.
void print(String s)
Print the string without newline, and flush.
Parameters:
s - the string to print
void runTool(String... args)
Run the shell tool with the given command line settings.
void runTool(String... args) throws SQLException
Run the shell tool with the given command line settings.
Parameters:
args - the command line settings
void setErr(PrintStream err)
Sets the standard error stream.
void setErr(PrintStream err)
Sets the standard error stream.
Parameters:
err - the new standard error stream
void setIn(InputStream in)
Redirects the standard input.
void setIn(InputStream in)
Redirects the standard input. By default, System.in is used.
Parameters:
in - the input stream to use
void setInReader(BufferedReader reader)
Redirects the standard input.
void setInReader(BufferedReader reader)
Redirects the standard input. By default, System.in is used.
Parameters:
reader - the input stream reader to use