oracle.apps.fnd.applseed.rt.loader.handler.data
Class SDJDBCDataHandler

java.lang.Object
  oracle.apps.fnd.applseed.rt.loader.core.SDDataHandler
      oracle.apps.fnd.applseed.rt.loader.handler.data.SDJDBCDataHandler

public class SDJDBCDataHandler
extends SDDataHandler

Since:

Drop 8 Build 5

Version:

$Header: atgpf/applseed/src/java/oracle/apps/fnd/applseed/rt/loader/handler/data/SDJDBCDataHandler.java /st_atgpf_pt-11.1.1.6.4/1 2012/09/23 19:13:16 ksedlund Exp $

Author:

sjanarth

Field Summary

protected java.util.Map<java.lang.String,oracle.apps.fnd.applseed.rt.loader.handler.data.SDJDBCDataHandler.StmtCacheObj>	selStmtCache
protected java.util.Map<java.lang.String,oracle.apps.fnd.applseed.rt.loader.handler.data.SDJDBCDataHandler.StmtCacheObj>	updStmtCache
protected static java.lang.String	VO_ANCESTOR_OF_EXCLUSIVE
protected static java.lang.String	VO_ANCESTOR_OF_EXCLUSIVE_OLD
protected static java.lang.String	VO_PROPERTY_KEY_COLS
protected static java.lang.String	VO_PROPERTY_SELECT_BINDS
protected static java.lang.String	VO_PROPERTY_SELECT_SQL
protected static java.lang.String	VO_PROPERTY_UPDATE_BINDS
protected static java.lang.String	VO_PROPERTY_UPDATE_SQL
protected static java.lang.String	VO_PROPERTY_UPDATE_SQL_TYPES
protected static java.lang.String	VO_PROPERTY_UPDATEABLE_TABLES
protected static java.lang.String	VO_UPD_BIND_NOCUST
protected java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>>	voProps

Fields inherited from class oracle.apps.fnd.applseed.rt.loader.core.SDDataHandler

driverNode, fileProps, LOGGER, MAX_ORA1_RETRIES, theMTSHandler, theParams, theRowCounter, updateCallback, warnings

Constructor Summary

SDJDBCDataHandler()

Method Summary

protected void	clearStatementCaches()
void	commitTrans(SDDataEntity topEntity) Overrides the base handler commitTrans to perform update callback method if necessary.
protected java.lang.String	getAdjustedSelectStmt(java.lang.String sql, SDDataEntity de)
protected java.lang.String	getAdjustedUpdateStmt(java.lang.String sql)
protected long	getRowCount(SDDataEntity de, java.util.Map<java.lang.String,java.lang.Object> rowValues) Issue prepared SQL select statement to find row count, and to fill in translatable row values if running incremental load.
protected void	incrementDE(SDDataEntity de, int pass)
void	initialize(oracle.jbo.ApplicationModule am, SDLoaderParams lps, java.util.Map<java.lang.String,java.lang.String> props, java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>> props2, SDRowCounter rc)
protected long	loadEntity(SDDataEntity de)
void	loadEntitySingle(SDDataEntity de)
void	performCleanup()
protected void	prepareStatements(SDDataEntity de) Prepare the JDBC select/update SQL statements for the given data entity.
void	resetAllState()

Methods inherited from class oracle.apps.fnd.applseed.rt.loader.core.SDDataHandler

addEntityCommitCache, checkCFV, clearEntityCommitCache, commitTrans, formatMsg, foundImmutableData, foundMutableData, getDriverNode, getTransaction, getWarnings, handleDMLConstraintException, handleDMLConstraintException, handleGenericException, handleGenericException, handleJboException, handleJboException, initialize, isTopEntity, loadEntityGroup, loadEntityMain, loadEntityTopLevel, rollbackTrans, setEnterpriseContext, showCommitProgress, showFailedRow, showProgress, showProgress2, showWarning

Methods inherited from class java.lang.Object

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

Field Detail

VO_PROPERTY_UPDATE_SQL

protected static final java.lang.String VO_PROPERTY_UPDATE_SQL

See Also:

Constant Field Values

VO_PROPERTY_SELECT_SQL

protected static final java.lang.String VO_PROPERTY_SELECT_SQL

See Also:

Constant Field Values

VO_PROPERTY_KEY_COLS

protected static final java.lang.String VO_PROPERTY_KEY_COLS

See Also:

Constant Field Values

VO_PROPERTY_UPDATE_BINDS

protected static final java.lang.String VO_PROPERTY_UPDATE_BINDS

See Also:

Constant Field Values

VO_PROPERTY_UPDATE_SQL_TYPES

protected static final java.lang.String VO_PROPERTY_UPDATE_SQL_TYPES

See Also:

Constant Field Values

VO_PROPERTY_SELECT_BINDS

protected static final java.lang.String VO_PROPERTY_SELECT_BINDS

See Also:

Constant Field Values

VO_UPD_BIND_NOCUST

protected static final java.lang.String VO_UPD_BIND_NOCUST

See Also:

Constant Field Values

VO_ANCESTOR_OF_EXCLUSIVE_OLD

protected static final java.lang.String VO_ANCESTOR_OF_EXCLUSIVE_OLD

See Also:

Constant Field Values

VO_ANCESTOR_OF_EXCLUSIVE

protected static final java.lang.String VO_ANCESTOR_OF_EXCLUSIVE

See Also:

Constant Field Values

VO_PROPERTY_UPDATEABLE_TABLES

protected static final java.lang.String VO_PROPERTY_UPDATEABLE_TABLES

See Also:

Constant Field Values

voProps

protected java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>> voProps

updStmtCache

protected java.util.Map<java.lang.String,oracle.apps.fnd.applseed.rt.loader.handler.data.SDJDBCDataHandler.StmtCacheObj> updStmtCache

selStmtCache

protected java.util.Map<java.lang.String,oracle.apps.fnd.applseed.rt.loader.handler.data.SDJDBCDataHandler.StmtCacheObj> selStmtCache

Constructor Detail

SDJDBCDataHandler

public SDJDBCDataHandler()

Method Detail

initialize

public void initialize(oracle.jbo.ApplicationModule am,
                       SDLoaderParams lps,
                       java.util.Map<java.lang.String,java.lang.String> props,
                       java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>> props2,
                       SDRowCounter rc)
                throws SDDriverInitException,
                       SDMultiTenancyInitException

Overrides:

initialize in class SDDataHandler

Throws:

SDDriverInitException

SDMultiTenancyInitException

prepareStatements

protected void prepareStatements(SDDataEntity de)

Prepare the JDBC select/update SQL statements for the given data entity. Performed once per data entity on first row load. SQL prepared either from the static statements in the xlf file metadata, or generated on the fly if not present.

Parameters:

de -

getAdjustedUpdateStmt

protected java.lang.String getAdjustedUpdateStmt(java.lang.String sql)

getAdjustedSelectStmt

protected java.lang.String getAdjustedSelectStmt(java.lang.String sql,
                                                 SDDataEntity de)

clearStatementCaches

protected void clearStatementCaches()

commitTrans

public void commitTrans(SDDataEntity topEntity)
                 throws SDLoaderException

Overrides the base handler commitTrans to perform update callback method if necessary.

Overrides:

commitTrans in class SDDataHandler

Parameters:

topEntity - SDDataEntity may be null

Throws:

SDLoaderException

loadEntitySingle

public void loadEntitySingle(SDDataEntity de)
                      throws SDLoaderException

Specified by:

loadEntitySingle in class SDDataHandler

Throws:

SDLoaderException

loadEntity

protected long loadEntity(SDDataEntity de)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

incrementDE

protected void incrementDE(SDDataEntity de,
                           int pass)

getRowCount

protected long getRowCount(SDDataEntity de,
                           java.util.Map<java.lang.String,java.lang.Object> rowValues)
                    throws java.sql.SQLException

Issue prepared SQL select statement to find row count, and to fill in translatable row values if running incremental load.

Parameters:

de - SDDataEntity

rowValues - Map attr->value to be filled in with translatable column data

Returns:

long number of rows, 0 = not found, >1 too many rows match pk

Throws:

java.sql.SQLException

performCleanup

public void performCleanup()

Specified by:

performCleanup in class SDDataHandler

resetAllState

public void resetAllState()
                   throws SDLoaderException

Overrides:

resetAllState in class SDDataHandler

Throws:

SDLoaderException