oracle.ifs.admin.actions

Class SQLScriptAction

java.lang.Object

oracle.ifs.utils.action.AbstractAction

oracle.ifs.admin.actions.SQLScriptAction

All Implemented Interfaces:

Action, IfsParameters

Direct Known Subclasses:

CreateDefaultFilterIndexAction, CreateFastFilterIndexAction, InstallLykeAction, UpdateTextIndexAction

public class SQLScriptAction
extends AbstractAction
implements IfsParameters

A SQLScriptAction is an upgrade action for executing SQL scripts.

Version:

1.0.0

Author:

Sudhanshu Garg

(Unpublished)

Field Summary

Fields

Modifier and Type	Field and Description
static String	NOLOG
static String	SQL_ARGUMENTS
static String	SQL_SCRIPT

Fields inherited from class oracle.ifs.utils.action.AbstractAction

CONTINUE_ON_ERROR, m_defaultOptions, m_options

Fields inherited from interface oracle.ifs.utils.common.IfsParameters

APPEND_LOG, DATABASE_TYPE, DATABASE_URL, DB_USER_NAME, DB_USER_PASSWORD, DOMAIN_TYPE, ENABLE_SSL_SUPPORT, FOR_SCHEMA_UPGRADE, IFS_DOMAIN_DISPLAY_NAME, IFS_DOMAIN_NAME, IFS_SCHEMA_NAME, IFS_SCHEMA_PASSWORD, IFS_SERVICE_NAME, IFS_USER_NAME, IFS_USER_PASSWORD, INCLUDE_PATH, INITIAL_CONTEXT_FACTORY, LDAP_URL_DAS_LOOKUP, LDAP_USER_NAME, LDAP_USER_PASSWORD, OUTPUT_FILE, PARAMETER_FILE, REGISTRY, SCHEMA_VERSION_KEY, SECURITY_PROTOCOL_NAME, SERVICE_CONFIGURATION_NAME

Constructor Summary

Constructors

Constructor and Description
SQLScriptAction() Creates a new SQLScriptAction without specifying a SQL script or parameters for the SQL script.

Method Summary

Modifier and Type	Method and Description
void	execute(Connection con, String connectString)
void	failed(Throwable error) Does nothing.
void	perform() Performs this Action.
void	setSQLArguments(String args) Sets the arguments to pass to the SQL script.
void	setSQLScript(String sql) Sets the the SQL script to execute.
void	stop() Does nothing.

Methods inherited from class oracle.ifs.utils.action.AbstractAction

getDescription, getName, getValue, isContinueOnError, isPostgres, putValue, setDefaultOptions, setDescription, setName, setOptions

Methods inherited from class java.lang.Object

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

Field Detail

SQL_SCRIPT

public static final String SQL_SCRIPT

See Also:

Constant Field Values

SQL_ARGUMENTS

public static final String SQL_ARGUMENTS

See Also:

Constant Field Values

NOLOG

public static final String NOLOG

See Also:

Constant Field Values

Constructor Detail

SQLScriptAction

public SQLScriptAction()

Creates a new SQLScriptAction without specifying a SQL script or parameters for the SQL script.

Method Detail

setSQLScript

public void setSQLScript(String sql)

Sets the the SQL script to execute.

Parameters:

sql - the path of the SQL script to execute.

setSQLArguments

public void setSQLArguments(String args)

Sets the arguments to pass to the SQL script.

Parameters:

args - a String with pipe (|) separated arguments to pass to the SQL script, or null if no arguments are required.

perform

public void perform()
             throws ActionFailedException

Description copied from interface: Action

Performs this Action.

Specified by:

perform in interface Action

Throws:

ActionFailedException - if the action could not be performed.

execute

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

Throws:

SQLException

ActionFailedException

stop

public void stop()

Does nothing.

Specified by:

stop in interface Action

failed

public void failed(Throwable error)

Does nothing.

Specified by:

failed in interface Action

Parameters:

error - the error that occurred.