|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Agent hosts CallableStatement interface
Method Summary | |
void |
clearParameters()
If using the Oracleapps native driver, which supports clob, all temporary clobs are freed when clearing the value of all parameters. |
java.sql.Array |
getArray(int index)
Gets the Array value of the indexed parameter. |
java.math.BigDecimal |
getBigDecimal(int index)
Gets the decimal value of the indexed parameter. |
java.sql.Blob |
getBlob(int index)
Gets the Blob value of the indexed parameter. |
boolean |
getBoolean(int index)
Gets the boolean value of the indexed parameter. |
byte |
getByte(int index)
Gets the byte value of the indexed parameter. |
byte[] |
getBytes(int index)
Gets the byte array value of the indexed parameter. |
java.sql.Clob |
getClob(int index)
Gets the Clob value of the indexed parameter. |
java.sql.Date |
getDate(int index)
Gets the date value of the indexed parameter. |
java.sql.Date |
getDate(int index,
java.util.Calendar calendar)
Gets the date value of the indexed parameter, including time zone, from the calendar. |
double |
getDouble(int index)
Gets the double value of the indexed parameter. |
float |
getFloat(int index)
Gets the float value of the indexed parameter. |
int |
getInt(int index)
Gets the integer value of the indexed parameter. |
long |
getLong(int index)
Gets the long value of the indexed parameter. |
java.lang.Object |
getObject(int index)
Gets the value of the indexed parameter as an instance of the Object. |
java.lang.Object |
getObject(int index,
java.util.Map map)
Gets the value of the indexed parameter as an instance of the Object and uses map for the customer mapping of the parameter value. |
java.sql.Ref |
getRef(int index)
Gets the Ref value of the indexed parameter. |
short |
getShort(int index)
Gets the short value of the indexed parameter. |
java.lang.String |
getString(int index)
Gets the string value of the indexed parameter. |
java.sql.Time |
getTime(int index)
Gets the time value of the indexed parameter. |
java.sql.Time |
getTime(int index,
java.util.Calendar calendar)
Gets time value of the indexed parameter, including time zone, from the calendar. |
java.sql.Timestamp |
getTimestamp(int index)
Gets the timestamp value of the indexed parameter. |
java.sql.Timestamp |
getTimestamp(int index,
java.util.Calendar calendar)
Gets the timestamp value of the indexed parameter including time zone from the calendar. |
void |
registerOutParameter(int index,
int iType)
Registers the indexed OUT parameter with specified type. |
void |
registerOutParameter(int index,
int iType,
int iScale)
Registers the indexed OUT parameter with specified type and scale. |
void |
registerOutParameter(int index,
int iType,
java.lang.String sType)
Registers the indexed OUT parameter with specified user-named type or REF type. |
void |
setClob(int index,
java.lang.Object obj)
Sets the Clob value of the indexed parameter. |
boolean |
wasNull()
Checks whether or not the last OUT parameter read had the SQL NULL value. |
Methods inherited from interface com.stc.connector.appconn.db.PreparedStatementAgent |
addBatch, enableResultSetsAndUpdateCounts, enableResultSetsOnly, enableUpdateCountsOnly, execute, executeQuery, executeUpdate, getPreparedStmt, getRSAgentList, getRSAgentSigs, getUpdateCount, matchResultSetSignature, resultsAvailable, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setRSAgentList, setRSAgentSigs, setShort, setString, setTime, setTime, setTimestamp, setTimestamp |
Methods inherited from interface com.stc.connector.appconn.db.StatementAgent |
cancel, clearBatch, clearWarnings, executeBatch, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetType, getWarnings, isClosed, queryName, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, stmtInvoke |
Method Detail |
public void clearParameters() throws java.sql.SQLException
clearParameters
in interface PreparedStatementAgent
void
- None.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Array getArray(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.math.BigDecimal getBigDecimal(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Blob getBlob(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public boolean getBoolean(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public byte getByte(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public byte[] getBytes(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Clob getClob(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Date getDate(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Date getDate(int index, java.util.Calendar calendar) throws java.sql.SQLException
index
- the position of the parameter.calendar
- the Calendar object to use to construct the Date object.java.sql.SQLException
- which contains information about errors in accessing the database.public double getDouble(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public float getFloat(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public int getInt(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public long getLong(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.lang.Object getObject(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.lang.Object getObject(int index, java.util.Map map) throws java.sql.SQLException
index
- the position of the parameter.map
- contains the mapping from SQL type names for user-defined types to class.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Ref getRef(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public short getShort(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.lang.String getString(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Time getTime(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Time getTime(int index, java.util.Calendar calendar) throws java.sql.SQLException
index
- the position of the parameter.calendar
- the Calendar object to use to construct the Time object.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Timestamp getTimestamp(int index) throws java.sql.SQLException
index
- the position of the parameter.java.sql.SQLException
- which contains information about errors in accessing the database.public java.sql.Timestamp getTimestamp(int index, java.util.Calendar calendar) throws java.sql.SQLException
index
- the position of the parameter.calendar
- the Calendar object to use to construct the Timestamp object.java.sql.SQLException
- which contains information about errors in accessing the database.public void registerOutParameter(int index, int iType) throws java.sql.SQLException
index
- the position of the parameter.iType
- the JDBC type code defined by java.sql.Types.void
- None.java.sql.SQLException
- which contains information about errors in accessing the database.public void registerOutParameter(int index, int iType, int iScale) throws java.sql.SQLException
index
- the position of the parameter.iType
- the JDBC type code defined by java.sql.Types.iScale
- the desired number of digits to the right of the decimal point. It must be >= 0.void
- None.java.sql.SQLException
- which contains information about errors in accessing the database.public void registerOutParameter(int index, int iType, java.lang.String sType) throws java.sql.SQLException
index
- the position of the parameter.iType
- the JDBC type code defined by java.sql.Types.sType
- the fully-qualified SQL name of the user-named type.void
- None.java.sql.SQLException
- which contains information about errors in accessing the database.public void setClob(int index, java.lang.Object obj) throws java.sql.SQLException
index
- index of the parameter.obj
- the object value the parameter will be set withvoid
- None.java.sql.SQLException
- which contains information about errors in accessing the database.public boolean wasNull() throws java.sql.SQLException
java.sql.SQLException
- which contains information about errors in accessing the database.
|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Copyright 2004 by SeeBeyond Technology Corporation. All Rights Reserved.