oracle.ifs.admin.sql

Class RunSQLScript

java.lang.Object

oracle.ifs.admin.sql.RunSQLScript

public class RunSQLScript
extends Object

Provides a simple way to run SQL scripts.

Version:

1.1.5

Author:

Luis Saenz

(Unpublished)

Modified:

sgarg 02/24/2002 Changed stopOnErrors argument to false as that is what the default behavior should be, lsaenz 08/17/2000 Changed stopOnErrors argument to true., lsaenz 08/11/2000 Updated comments., lsaenz 07/06/2000 Added constructor with no log., lsaenz 12/02/1999 Made default values for sqlFile and sqlLogFile == "" instead of null., lsaenz 11/17/1999 Made class extend DatabaseAction., lsaenz 11/16/1999 Created.

Field Summary

Fields

Modifier and Type	Field and Description
protected String	sqlFile The SQL file to execute.
protected String	sqlLogFile The log file to record SQL statements that have been executed.
protected Hashtable	symbols The symbols that need to be replaced in the SQL file.

Constructor Summary

Constructors

Constructor and Description
RunSQLScript() Creates a new RunSQLScript.
RunSQLScript(String file) Creates a new RunSQLScript.
RunSQLScript(String file, String log) Creates a new RunSQLScript class.
RunSQLScript(String file, String log, Hashtable symbols) Creates a new RunSQLScript given a Hashtable with symbol to value mappings for the symbols that need to be replaced in the SQL script.

Method Summary

Modifier and Type	Method and Description
void	execute(Connection con)
void	execute(Connection con, String connectString) Runs a SQL script.
void	setSQLFile(String file)
void	setSQLLogFile(String log)
void	setSymbols(Hashtable symbols)

Methods inherited from class java.lang.Object

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

Field Detail

sqlFile

protected String sqlFile

The SQL file to execute.

(Unpublished)

sqlLogFile

protected String sqlLogFile

The log file to record SQL statements that have been executed.

(Unpublished)

symbols

protected Hashtable symbols

The symbols that need to be replaced in the SQL file.

(Unpublished)

Constructor Detail

RunSQLScript

public RunSQLScript()

Creates a new RunSQLScript.

(Unpublished)

RunSQLScript

public RunSQLScript(String file)

Creates a new RunSQLScript.

Parameters:

file - the SQL file to execute.

(Unpublished)

RunSQLScript

public RunSQLScript(String file,
                    String log)

Creates a new RunSQLScript class.

Parameters:

file - the SQL file to execute.

log - the log file to use.

(Unpublished)

RunSQLScript

public RunSQLScript(String file,
                    String log,
                    Hashtable symbols)

Creates a new RunSQLScript given a Hashtable with symbol to value mappings for the symbols that need to be replaced in the SQL script.

Parameters:

file - the SQL file to execute.

log - the log file to use.

symbols - the symbols (mapped to values) to replace.

(Unpublished)

Method Detail

setSQLFile

public void setSQLFile(String file)

setSQLLogFile

public void setSQLLogFile(String log)

setSymbols

public void setSymbols(Hashtable symbols)

execute

public void execute(Connection con,
                    String connectString)
             throws SQLException,
                    SQLProcessorException,
                    IOException

Runs a SQL script.
Note: the Connection is closed after running the script.

Parameters:

con - the JDBC Connection to use.

Throws:

SQLException - if a SQL command fails.

SQLProcessorException - if processing the script fails.

IOException - if an IO error occurs.

(Unpublished)

execute

public void execute(Connection con)
             throws SQLException,
                    SQLProcessorException,
                    IOException

Throws:

SQLException

SQLProcessorException

IOException