net.sf.jailer.util

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 and Description
static String	FINISHED_MULTILINE_COMMENT Comment prefix for last line of a multi-line comment.
static String	UNFINISHED_MULTILINE_COMMENT Comment prefix for multi-line comments.

Constructor Summary

Constructors

Constructor and Description
SqlScriptExecutor(Session session, int threads) Constructor.

Method Summary

Methods

Modifier and Type	Method and 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()

Methods inherited from class java.lang.Object

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

Field Detail

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 Detail

SqlScriptExecutor

public SqlScriptExecutor(Session session,
                 int threads)

Constructor.

Parameters:

session - for execution of statements

threads - number of threads to use

Method Detail

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

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()