public class RunScript
extends org.h2.util.Tool
Constructor and Description |
---|
RunScript() |
Modifier and Type | Method and Description |
---|---|
static java.sql.ResultSet |
execute(java.sql.Connection conn,
java.io.Reader reader)
Executes the SQL commands read from the reader against a database.
|
static void |
execute(java.lang.String url,
java.lang.String user,
java.lang.String password,
java.lang.String fileName,
java.nio.charset.Charset charset,
boolean continueOnError)
Executes the SQL commands in a script file against a database.
|
static void |
main(java.lang.String... args)
Options are case sensitive.
|
void |
runTool(java.lang.String... args)
Executes the contents of a SQL script file against a database.
|
public static void main(java.lang.String... args) throws java.sql.SQLException
[-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) |
args
- the command line argumentsjava.sql.SQLException
- on failurepublic void runTool(java.lang.String... args) throws java.sql.SQLException
java -Xrunhprof:cpu=samples,depth=16 ...To include local files when using remote databases, use the special syntax:
@INCLUDE fileNameThis syntax is only supported by this tool. Embedded RUNSCRIPT SQL statements will be executed by the database.
runTool
in class org.h2.util.Tool
args
- the command line argumentsjava.sql.SQLException
- on failurepublic static java.sql.ResultSet execute(java.sql.Connection conn, java.io.Reader reader) throws java.sql.SQLException
conn
- the connection to a databasereader
- the readerjava.sql.SQLException
- on failurepublic static void execute(java.lang.String url, java.lang.String user, java.lang.String password, java.lang.String fileName, java.nio.charset.Charset charset, boolean continueOnError) throws java.sql.SQLException
url
- the database URLuser
- the user namepassword
- the passwordfileName
- the script filecharset
- the character set or null for UTF-8continueOnError
- if execution should be continued if an error
occursjava.sql.SQLException
- on failure