org.h2.tools
Class RunScript
java.lang.Object
org.h2.util.Tool
org.h2.tools.RunScript
public class RunScript
- extends Tool
Runs a SQL script against a database.
- H2.resource:
| Fields inherited from class org.h2.util.Tool |
out |
|
Method Summary |
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.lang.String charsetName,
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. |
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
RunScript
public RunScript()
main
public static void main(java.lang.String... args)
throws java.sql.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
- Throws:
java.sql.SQLException- H2.resource:
runTool
public void runTool(java.lang.String... args)
throws java.sql.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.
- Specified by:
runTool in class Tool
- Parameters:
args - the command line arguments
- Throws:
java.sql.SQLException
execute
public static java.sql.ResultSet execute(java.sql.Connection conn,
java.io.Reader reader)
throws java.sql.SQLException
- Executes the SQL commands read from the reader against a database.
- Parameters:
conn - the connection to a databasereader - the reader
- Returns:
- the last result set
- Throws:
java.sql.SQLException
execute
public static void execute(java.lang.String url,
java.lang.String user,
java.lang.String password,
java.lang.String fileName,
java.lang.String charsetName,
boolean continueOnError)
throws java.sql.SQLException
- Executes the SQL commands in a script file against a database.
- Parameters:
url - the database URLuser - the user namepassword - the passwordfileName - the script filecharsetName - the character set name or null for UTF-8continueOnError - if execution should be continued if an error occurs
- Throws:
java.sql.SQLException