Package org.h2.tools
Class RunScript
- java.lang.Object
-
- org.h2.util.Tool
-
- org.h2.tools.RunScript
-
public class RunScript extends org.h2.util.Tool
Runs a SQL script against a database.
-
-
Constructor Summary
Constructors Constructor Description RunScript()
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description 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 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
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.
-
-
-
Method Detail
-
main
public static void main(java.lang.String... args) throws java.sql.SQLException
Options are case sensitive.Supported options [-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
- on failure
-
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 classorg.h2.util.Tool
- Parameters:
args
- the command line arguments- Throws:
java.sql.SQLException
- on failure
-
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
- on failure
-
execute
public 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
Executes the SQL commands in a script file against a database.- Parameters:
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 occurs- Throws:
java.sql.SQLException
- on failure
-
-