Class SqlScriptExecutor

java.lang.Object

net.sf.jailer.util.SqlScriptExecutor

public class SqlScriptExecutor
extends Object

Reads in and executes SQL-scripts.

Author:

Ralf Wisser

Field Summary

Fields

Modifier and Type	Field	Description
static final String	FINISHED_MULTILINE_COMMENT	Comment prefix for last line of a multi-line comment.
static final String	UNFINISHED_MULTILINE_COMMENT	Comment prefix for multi-line comments.

Constructor Summary

Constructors

Constructor	Description
SqlScriptExecutor(Session session, int threads)	Constructor.
SqlScriptExecutor(Session session, int threads, boolean logStatements)	Constructor.

Method Summary

Modifier and Type	Method	Description
Pair<Integer,Long>	executeScript(String scriptFileName)	Reads in and executes a SQL-script.
Pair<Integer,Long>	executeScript(String scriptFileName, boolean transactional)	Reads in and executes a SQL-script.
static Pair<Integer,Long>	getLastStatementCount()	Gets the statement and row count from the last script execution.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

UNFINISHED_MULTILINE_COMMENT

public static final String UNFINISHED_MULTILINE_COMMENT

Comment prefix for multi-line comments.

See Also:

• Constant Field Values

FINISHED_MULTILINE_COMMENT

public static final String FINISHED_MULTILINE_COMMENT

Comment prefix for last line of a multi-line comment.

See Also:

• Constant Field Values

Constructor Details

SqlScriptExecutor

public SqlScriptExecutor(Session session,
 int threads,
 boolean logStatements)

Constructor.

Parameters:

session - for execution of statements

threads - number of threads to use

logStatements - log statements?

SqlScriptExecutor

public SqlScriptExecutor(Session session,
 int threads)

Constructor.

Parameters:

session - for execution of statements

threads - number of threads to use

Method Details

executeScript

public Pair<Integer,Long> executeScript(String scriptFileName,
 boolean transactional)
                                 throws IOException,
SQLException

Reads in and executes a SQL-script.

Parameters:

scriptFileName - the name of the script-file

transactional - true to execute the script within a transaction

Returns:

Pair(statementCount, rowCount)

Throws:

IOException

SQLException

executeScript

public Pair<Integer,Long> executeScript(String scriptFileName)
                                 throws IOException,
SQLException

Reads in and executes a SQL-script.

Parameters:

scriptFileName - the name of the script-file

Returns:

Pair(statementCount, rowCount)

Throws:

IOException

SQLException

getLastStatementCount

public static Pair<Integer,Long> getLastStatementCount()

Gets the statement and row count from the last script execution.

Returns:

Pair(statementCount, rowCount) from the last script execution, or (0, 0) if no script has been executed