ifs.fnd.sf.storage

Class FndOracleStatementForOracle

java.lang.Object

ifs.fnd.sf.storage.FndStatement

ifs.fnd.sf.storage.FndStandardStatement

ifs.fnd.sf.storage.FndOracleStatement

ifs.fnd.sf.storage.FndOracleStatementForOracle

All Implemented Interfaces:

FndSqlData, ifs.fnd.sf.admin.FndAbortableProcess, java.lang.AutoCloseable

public class FndOracleStatementForOracle
extends FndOracleStatement

Framework internal class: Oracle database statement that contains a reference to OracleStatement. This class delegates Oracle specific calls directly to the private instance of OracleStatement. It is the default subclass of FndStatement used in Oracle AS and in standalone framework.

This is a framework internal class! Backward compatibility is not guaranteed.

Field Summary

Fields inherited from class ifs.fnd.sf.storage.FndStatement

c, callable, DEFAULT_BUFFER_SIZE, log, parameters, result, stmt, utcCalendar

Constructor Summary

Constructors

Constructor and Description
FndOracleStatementForOracle(FndConnection fndConnection) Creates a new instance of FndOracleStatementForOracle.

Method Summary

Modifier and Type	Method and Description
protected java.sql.Blob	getBlob(int colNr) Get Blob locator.
protected java.sql.Clob	getClob(int colNr) Get Clob locator.
protected oracle.jdbc.OracleStatement	getWrappedStatement() Gets the wrapped instance of OracleStatement in a container-specific way.
protected void	setTimestamp(int colNr, java.sql.Timestamp value) Bind Timestamp parameter as Oracle DATE type.

Methods inherited from class ifs.fnd.sf.storage.FndOracleStatement

toJavaSqlType, updateBlob, updateBlob, updateClob

Methods inherited from class ifs.fnd.sf.storage.FndStandardStatement

checkError, reportSqlError, spoolPlSqlTrace

Methods inherited from class ifs.fnd.sf.storage.FndStatement

abort, bindArguments, checkResult, clearFetchedSize, clearParameters, clearParameters, close, closeRefCursorStatement, debugNull, defineInOutParameter, defineInParameter, defineInParameter, defineOutParameter, defineParameter, defineRefCursorVariable, execute, execute, executeQuery, executeQuery, executeUpdate, formatSize, getBigDecimal, getBinary, getBinary, getBoolean, getBufferSize, getBufferSize, getCursor, getDate, getDouble, getFetchedSize, getFndConnection, getFndCursor, getFndResult, getInt, getLong, getLongRaw, getLongText, getLongTextImpl, getMessage, getOutBigDecimal, getOutBoolean, getOutDate, getOutDouble, getOutInt, getOutLong, getOutLongRaw, getOutString, getOutTime, getOutTimestamp, getRefCursor, getResult, getSqlText, getString, getText, getTime, getTimestamp, isShortClobParameter, nativeSql, nativeSql, parameterWasNull, prepare, prepare, prepare, prepare, prepareCall, prepareCall, prepareStatement, prepareStatement, recreateLogger, registerOutParameter, resultWasNull, setDouble, setFetchSize, setMaxRows, setRecursive, setSpoolPlsqlTrace, supportsDefineColumnType

Methods inherited from class java.lang.Object

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

Constructor Detail

FndOracleStatementForOracle

public FndOracleStatementForOracle(FndConnection fndConnection)

Creates a new instance of FndOracleStatementForOracle.

Parameters:

fndConnection -

Method Detail

getWrappedStatement

protected oracle.jdbc.OracleStatement getWrappedStatement()

Gets the wrapped instance of OracleStatement in a container-specific way.

Returns:

the instance of OracleStatement wrapped by this FndStatement

getBlob

protected java.sql.Blob getBlob(int colNr)
                         throws IfsException

Get Blob locator.

Overrides:

getBlob in class FndStatement

Parameters:

colNr - Column number in statement

Returns:

BLOB locator

Throws:

IfsException

getClob

protected java.sql.Clob getClob(int colNr)
                         throws IfsException

Get Clob locator.

Overrides:

getClob in class FndStatement

Parameters:

colNr - Column number in statement.

Returns:

CLOB locator

Throws:

IfsException

setTimestamp

protected void setTimestamp(int colNr,
                            java.sql.Timestamp value)
                     throws IfsException

Bind Timestamp parameter as Oracle DATE type. JDBC driver maps JDBC type TIMESTAMP to Oracle type TIMESTAMP, which contains more information than Oracle DATE type (TIMESTAMP includes nanoseconds and DATE does not). As a result queries using JDBC timestamp bind-variables don't use indexes on DATE columns. This method workarounds this problem by calling setDATE on OraclePreparedStatement.

Specified by:

setTimestamp in class FndStatement

Parameters:

colNr - column number.

value - parameter value.

Throws:

IfsException