ifs.fnd.sf.storage

Class FndOracleStatement

java.lang.Object

ifs.fnd.sf.storage.FndStatement

ifs.fnd.sf.storage.FndStandardStatement

ifs.fnd.sf.storage.FndOracleStatement

All Implemented Interfaces:

FndSqlData, ifs.fnd.sf.admin.FndAbortableProcess

Direct Known Subclasses:

FndOracleStatementForOracle

public abstract class FndOracleStatement
extends FndStandardStatement

Framework internal class: Oracle database statement. This class contains code that depends on Oracle JDBC driver.

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

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	FndOracleStatement(FndConnection fndConnection) Creates a new instance of FndOracleStatement.

Method Summary

Methods

Modifier and Type	Method and Description
protected int	getBufferSize(java.sql.Blob blob) Get the optimal buffer size to use when reading Blob.
protected int	getBufferSize(java.sql.Clob clob) Get the optimal buffer size to use when reading Clob.
protected int	toJavaSqlType(FndSqlType type) Convert a FndSqlType to it's corresponding Java SQL type.
protected void	updateBlob(int colNr, byte[] value) Update a BLOB
void	updateBlob(int colNr, FndInputStreamManager inputMgr) Update a BLOB from an InputStream.
protected void	updateClob(int colNr, java.lang.String value) Update a CLOB.

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

checkError, reportSqlError, spoolPlSqlTrace

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

abort, addAttribute, bindArguments, checkResult, clearColumnDefines, clearParameters, clearParameters, close, closeRefCursorStatement, debugNull, defineColumn, defineColumn, defineColumnType, defineColumnType, defineInOutParameter, defineInParameter, defineInParameter, defineOutParameter, defineParameter, defineRefCursorVariable, defineTypes, execute, executeQuery, executeQuery, executeUpdate, formatSize, getBigDecimal, getBinary, getBinary, getBlob, getBoolean, getClob, getCursor, getDate, getDouble, getFndConnection, getInt, getLong, getLongRaw, getLongText, getMessage, getOutBigDecimal, getOutBoolean, getOutDate, getOutDouble, getOutInt, getOutLong, getOutLongRaw, getOutString, getOutTime, getOutTimestamp, getRefCursor, getResult, getSqlText, getString, getText, getTime, getTimestamp, nativeSql, nativeSql, parameterWasNull, prepare, prepare, prepare, prepare, prepareCall, prepareCall, prepareStatement, prepareStatement, recreateLogger, registerOutParameter, resultWasNull, setDouble, setFetchSize, setMaxRows, setTimestamp, supportsDefineColumnType, transformRefCursorCall

Methods inherited from class java.lang.Object

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

Constructor Detail

FndOracleStatement

protected FndOracleStatement(FndConnection fndConnection)

Creates a new instance of FndOracleStatement.

Method Detail

updateBlob

protected void updateBlob(int colNr,
              byte[] value)
                   throws IfsException

Update a BLOB

Overrides:

updateBlob in class FndStandardStatement

Throws:

IfsException

updateBlob

public void updateBlob(int colNr,
              FndInputStreamManager inputMgr)
                throws IfsException

Update a BLOB from an InputStream.

Overrides:

updateBlob in class FndStandardStatement

Throws:

IfsException

updateClob

protected void updateClob(int colNr,
              java.lang.String value)
                   throws IfsException

Update a CLOB.

Overrides:

updateClob in class FndStandardStatement

Throws:

IfsException

getBufferSize

protected int getBufferSize(java.sql.Blob blob)

Get the optimal buffer size to use when reading Blob.

Overrides:

getBufferSize in class FndStatement

Parameters:

blob - Blob to get buffer size for,

Returns:

Optimal buffer size.

getBufferSize

protected int getBufferSize(java.sql.Clob clob)

Get the optimal buffer size to use when reading Clob.

Overrides:

getBufferSize in class FndStatement

Parameters:

clob - Clob to get buffer size for.

Returns:

Optimal buffer size.

toJavaSqlType

protected int toJavaSqlType(FndSqlType type)
                     throws SystemException

Convert a FndSqlType to it's corresponding Java SQL type. This method maps FndSqlType.TIMESTAMP to Oracle specific type DATE and FndSqlType.REF_CURSOR to OracleTypes.CURSOR. All other types are converted by calling super.toJavaSqlType().

Overrides:

toJavaSqlType in class FndStatement

Parameters:

type - Source FndSqlType

Returns:

Java SQL type

Throws:

SystemException