ifs.fnd.sf.storage

Class FndStandardStatement

java.lang.Object

ifs.fnd.sf.storage.FndStatement

ifs.fnd.sf.storage.FndStandardStatement

All Implemented Interfaces:

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

Direct Known Subclasses:

FndOracleStatement

public abstract class FndStandardStatement
extends FndStatement

Framework internal class: Standard database statement.

Note! This class does not depend on Oracle JDBC driver. Such code should be placed in FndOracleStatement.

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

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

Method Summary

Modifier and Type	Method and Description
protected void	checkError(java.sql.SQLException e) Check if the original error should be rethrown as some other kind of error.
protected void	reportSqlError(java.sql.SQLException error) Spool information about an SQL error to debug or standard output.
protected void	spoolPlSqlTrace() Spool trace from PlSql call to the database logger.
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.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, getBlob, getBoolean, getBufferSize, getBufferSize, getClob, 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, setTimestamp, supportsDefineColumnType, toJavaSqlType

Methods inherited from class java.lang.Object

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

Constructor Detail

FndStandardStatement

protected FndStandardStatement(FndConnection fndConnection)

Creates a new instance of FndStandardStatement

Parameters:

fndConnection -

Method Detail

checkError

protected void checkError(java.sql.SQLException e)
                   throws IfsException

Check if the original error should be rethrown as some other kind of error. In case a ValidationException or a DatabaseException is thrown, application code should add extra information to the thrown exception.

Specified by:

checkError in class FndStatement

Parameters:

e - Original exception thrown from database

Throws:

IfsException - May re-throw the exception.

updateBlob

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

Update a BLOB

Parameters:

colNr -

value -

Throws:

IfsException

updateBlob

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

Update a BLOB from an InputStream.

Parameters:

colNr -

inputMgr -

Throws:

IfsException

updateClob

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

Update a CLOB

Parameters:

colNr -

value -

Throws:

IfsException

spoolPlSqlTrace

protected final void spoolPlSqlTrace()
                              throws IfsException

Spool trace from PlSql call to the database logger. This method will be called after every execute of a stored procedure on a V3 instance. (Using Client_SYS.Get_Trace)

Overrides:

spoolPlSqlTrace in class FndStatement

Throws:

IfsException

reportSqlError

protected final void reportSqlError(java.sql.SQLException error)

Spool information about an SQL error to debug or standard output.

Specified by:

reportSqlError in class FndStatement

Parameters:

error - error to be reported