oracle.javatools.db.execute

Class PlSqlWrapper.PlSqlRunnable

java.lang.Object

oracle.javatools.db.execute.PlSqlWrapper.PlSqlRunnable

All Implemented Interfaces:

QueryWrapper.QueryRunnable

Enclosing class:

PlSqlWrapper

public abstract static class PlSqlWrapper.PlSqlRunnable
extends java.lang.Object
implements QueryWrapper.QueryRunnable

Runnable passed to the PlSqlWrapper to process the ResultSet and/or CallableStatement during execution. The processing is done via a separate class so that any work done on the database is managed appropriately (i.e. not on the event thread), and it also allows the wrapper framework to correctly close the Statement and ResultSet when done.

See Also:

PlSqlWrapper.executePlSql(PlSqlRunnable)

Constructor Summary

Constructors

Constructor and Description
PlSqlRunnable()

Method Summary

Modifier and Type	Method and Description
void	prepareCall(java.sql.CallableStatement cs) Called once the statement has been created, but before execution so that any output parameters can be registered.
void	processCall(java.sql.CallableStatement cs)
void	processResultSet(java.sql.ResultSet rs) Iterate through the result set as appropriate.

Methods inherited from class java.lang.Object

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

Constructor Detail

PlSqlRunnable

public PlSqlRunnable()

Method Detail

prepareCall

public void prepareCall(java.sql.CallableStatement cs)
                 throws java.sql.SQLException,
                        DBException

Called once the statement has been created, but before execution so that any output parameters can be registered. Input parameters are processed automatically assuming they were passed to the PlSqlWrapper constructor.

Parameters:

cs -

Throws:

java.sql.SQLException

DBException

processCall

public void processCall(java.sql.CallableStatement cs)
                 throws java.sql.SQLException,
                        DBException

Throws:

java.sql.SQLException

DBException

processResultSet

public void processResultSet(java.sql.ResultSet rs)
                      throws DBException

Description copied from interface: QueryWrapper.QueryRunnable

Iterate through the result set as appropriate. Use the wrapper's throwDBException method(s) to process any exceptions encountered during processing.

Specified by:

processResultSet in interface QueryWrapper.QueryRunnable

Parameters:

rs - the results of the query being m_run

Throws:

DBException - for any db (or processing) error