|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
com.stc.connector.oracleappsadapter.OracleappsPreparedStatementAgent | +--com.stc.connector.oracleappsadapter.OracleappsCallableStatementAgent
Agent hosts an OracleappsCallableStatement.
Constructor Summary | |
protected |
OracleappsCallableStatementAgent()
Default constructor. |
|
OracleappsCallableStatementAgent(Session session,
int iScroll,
int iConcur)
OracleappsCallableStatementAgent constructor. |
|
OracleappsCallableStatementAgent(Session session,
java.lang.String sCommand)
OracleappsCallableStatementAgent constructor. |
|
OracleappsCallableStatementAgent(Session session,
java.lang.String sCommand,
int iScroll,
int iConcur)
OracleappsCallableStatementAgent constructor. |
Method Summary | |
void |
clearParameters()
If using the Oracleapps native driver, that supports clob, all temporary clobs are freed when the value of all parameters are cleared. |
protected void |
createResultSets()
Instantiates the ResultSet nodes added to this Procedure by matching the ResultSet object's signature at runtime. |
boolean |
execute()
Executes the Procedure & sets the ResultSets of this procedure if any matches the OTD definition. |
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 with time zone from 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. |
boolean |
getMoreResults()
Moves the current resultset to next and returns true if the next resultset is available. |
boolean |
getMoreResults(int current)
Moves the current resultset to next and returns true if the next resultset is available. |
java.lang.Object |
getObject(int index)
Gets value of the indexed parameter as an instance of Object. |
java.lang.Object |
getObject(int index,
java.util.Map map)
Gets the value of the indexed parameter as an instance of 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. |
ResultSetAgent |
getResultSet()
Gets the current ResultSet. |
int[] |
getResultSetParamsPosition()
gets those parameter positions of a Procedure that are of type ResultSet. |
protected com.stc.otd.runtime.OtdMeta[] |
getResultSetsMeta()
Gets the meta info about the ResultSets added to this Procedure. |
protected OracleappsCallableStatementResultSet[] |
getResultSetsObjects()
Gets the ResultSets added to this Procedure. |
protected java.lang.Class[] |
getResultSetTypes()
Gets the Class info about the ResultSets added to this Procedure. |
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 with time zone from 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 with time zone from calendar. |
boolean |
matchResultSets(java.sql.ResultSet rs,
com.stc.otd.runtime.OtdMeta otdMeta)
Matches a ResultSet and OtdMeta based on their signatures. |
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. |
protected abstract void |
registerOutParameters()
Registers all output parameters of the prepared call. |
boolean |
resultsAvailable()
Determines whether next resultset is available after an execute. |
void |
sessionClosed(SessionEvent evt)
If using an Oracleapps native driver, that supports clob, all temporary clobs are freed when the session is closed. |
void |
sessionOpen(SessionEvent evt)
Processes a SessionOpen event. |
void |
setClob(int index,
java.lang.Object obj)
Sets the Clob value of the indexed parameter. |
void |
setResultSetParamsPosition(int[] newResultSetParamsPosition)
marks those parameters of a Procedure that are of type ResultSet. |
protected void |
setResultSetsMeta(com.stc.otd.runtime.OtdMeta[] resultSetsMeta)
Sets the meta info about the ResultSets that were added to this Procedure. |
protected void |
setResultSetsObjects(OracleappsCallableStatementResultSet[] newResultSetsObjects)
Sets the ResultSets added to this Procedure. |
protected void |
setResultSetTypes(java.lang.Class[] resultSetTypes)
Sets the Class info about the ResultSets added to this Procedure. |
boolean |
wasNull()
Checks whether or not the last OUT parameter read had the SQL NULL value. |
Methods inherited from class com.stc.connector.oracleappsadapter.OracleappsPreparedStatementAgent |
setOracleappsCursorOrds |
Constructor Detail |
protected OracleappsCallableStatementAgent()
public OracleappsCallableStatementAgent(Session session, int iScroll, int iConcur)
session
- a Session object used to hold connection information.iScroll
- resultset type; TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVEiConcur
- concurrency type; CONCUR_READ_ONLY, CONCUR_UPDATABLE
public OracleappsCallableStatementAgent(Session session, java.lang.String sCommand)
session
- a Session object used to hold connection information.sCommand
- a SQL statement for invoking a stored procedure.
public OracleappsCallableStatementAgent(Session session, java.lang.String sCommand, int iScroll, int iConcur)
session
- a Session object used to hold connection information.sCommand
- a SQL statement for invoking a stored procedure.iScroll
- resultset type; TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVEiConcur
- concurrency type; CONCUR_READ_ONLY, CONCUR_UPDATABLE
Method Detail |
public void clearParameters() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when there are problems in cleaning the parameters.protected void createResultSets()
void
- None.
public boolean execute() throws java.sql.SQLException
void
- None.
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 boolean getMoreResults() throws java.sql.SQLException
public boolean getMoreResults(int current) throws java.sql.SQLException
current
- one of the following Statement constants indicating what should happen to current ResultSet objects obtained using the method getResultSetCLOSE_CURRENT_RESULT, KEEP_CURRENT_RESULT, or CLOSE_ALL_RESULTS .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 ResultSetAgent getResultSet() throws java.sql.SQLException
void
- None.
public int[] getResultSetParamsPosition()
protected com.stc.otd.runtime.OtdMeta[] getResultSetsMeta()
void
- None.
protected OracleappsCallableStatementResultSet[] getResultSetsObjects()
void
- None.
protected java.lang.Class[] getResultSetTypes()
void
- None.
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 boolean matchResultSets(java.sql.ResultSet rs, com.stc.otd.runtime.OtdMeta otdMeta)
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.protected abstract void registerOutParameters() throws java.sql.SQLException
java.sql.SQLException
- which contains information about errors in accessing the database.public boolean resultsAvailable() throws java.sql.SQLException
resultsAvailable
in class OracleappsPreparedStatementAgent
true
if any Result Sets is available.java.sql.SQLException
- when SQL problems occur. when SQL problems occur.
public void sessionClosed(SessionEvent evt)
evt
- a SessionEvent instance.void
- None.
public void sessionOpen(SessionEvent evt)
evt
- a Session event which signals the connection is open.void
- None.
public void setClob(int index, java.lang.Object obj) throws java.sql.SQLException
index
- index of the parameterobj
- the object value the parameter will be set withvoid
- None.java.sql.SQLException
- when there are problems in setting the CLOB value.public void setResultSetParamsPosition(int[] newResultSetParamsPosition)
protected void setResultSetsMeta(com.stc.otd.runtime.OtdMeta[] resultSetsMeta)
void
- None.
protected void setResultSetsObjects(OracleappsCallableStatementResultSet[] newResultSetsObjects)
void
- None.
protected void setResultSetTypes(java.lang.Class[] resultSetTypes)
void
- None.
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.