gov.va.vinci.leo.tools.db

Class JdbcScriptRunner

java.lang.Object

gov.va.vinci.leo.tools.db.JdbcScriptRunner

public class JdbcScriptRunner
extends Object

Tool to run database scripts

Constructor Summary

Constructors

Constructor and Description
JdbcScriptRunner(Connection connection, boolean autoCommit, boolean stopOnError) Default constructor

Method Summary

Modifier and Type	Method and Description
boolean	isConsoleOut() If true then results will be written to the console.
void	runScript(Reader reader) Runs an SQL script (read in using the Reader parameter)
JdbcScriptRunner	setConsoleOut(boolean consoleOut) Set the console output flag.
JdbcScriptRunner	setDelimiter(String delimiter, boolean fullLineDelimiter)
JdbcScriptRunner	setErrorLogWriter(PrintWriter errorLogWriter) Setter for errorLogWriter property
JdbcScriptRunner	setLogWriter(PrintWriter logWriter) Setter for logWriter property

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcScriptRunner

public JdbcScriptRunner(Connection connection,
                        boolean autoCommit,
                        boolean stopOnError)

Default constructor

Method Detail

setDelimiter

public JdbcScriptRunner setDelimiter(String delimiter,
                                     boolean fullLineDelimiter)

setLogWriter

public JdbcScriptRunner setLogWriter(PrintWriter logWriter)

Setter for logWriter property

Parameters:

logWriter - - the new value of the logWriter property

setErrorLogWriter

public JdbcScriptRunner setErrorLogWriter(PrintWriter errorLogWriter)

Setter for errorLogWriter property

Parameters:

errorLogWriter - - the new value of the errorLogWriter property

isConsoleOut

public boolean isConsoleOut()

If true then results will be written to the console.

Returns:

true if console output is true

setConsoleOut

public JdbcScriptRunner setConsoleOut(boolean consoleOut)

Set the console output flag. If true then echo results to the console. Defaults to false.

Parameters:

consoleOut - true if results should be echoed to the console

Returns:

reference to this JdbcScriptRunner object

runScript

public void runScript(Reader reader)
               throws IOException,
                      SQLException

Runs an SQL script (read in using the Reader parameter)

Parameters:

reader - - the source of the script

Throws:

IOException

SQLException