# RunScript Runs a SQL script against a database.
Methods
static ResultSet | execute(Connection conn, Reader reader) Executes the SQL commands read from the reader against a database.
static ResultSet | execute(Connection conn, Reader reader) throws SQLException Executes the SQL commands read from the reader against a database. Parameters: conn - the connection to a database reader - the reader Returns: the last result set
static void | execute(String url, String user, String password, String fileName, Charset charset, boolean continueOnError) Executes the SQL commands in a script file against a database.
static void | execute(String url, String user, String password, String fileName, Charset charset, boolean continueOnError) throws SQLException Executes the SQL commands in a script file against a database. Parameters: url - the database URL user - the user name password - the password fileName - the script file charset - the character set or null for UTF-8 continueOnError - if execution should be continued if an error occurs
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:...)
[-user <user>] | The user name (default: sa)
[-password <pwd>] | The password
[-script <file>] | The script file to run (default: backup.sql)
[-driver <class>] | The JDBC driver class to use (not required in most cases)
[-showResults] | Show the statements and the results of queries
[-checkResults] | Check if the query results match the expected results
[-continueOnError] | Continue even if the script contains errors
[-options ...] | RUNSCRIPT options (embedded H2; -*Results not supported)
Parameters: args - the command line arguments
void | runTool(String... args) Executes the contents of a SQL script file against a database.
void | runTool(String... args) throws SQLException Executes the contents of a SQL script file against a database. This tool is usually used to create a database from script. It can also be used to analyze performance problems by running the tool using Java profiler settings such as:
     java -Xrunhprof:cpu=samples,depth=16 ...
To include local files when using remote databases, use the special syntax:
     @INCLUDE fileName
This syntax is only supported by this tool. Embedded RUNSCRIPT SQL statements will be executed by the database. Parameters: args - the command line arguments