Sun Adapter for Oracle Applications API

com.stc.connector.oracleadapter
Class OraclePreparedStatementAgent

java.lang.Object
  extended by com.stc.connector.oracleadapter.base.StatementAgentImpl
      extended by com.stc.connector.oracleadapter.base.PreparedStatementAgentImpl
          extended by com.stc.connector.oracleadapter.OraclePreparedStatementAgent
All Implemented Interfaces:
com.stc.connector.appconn.db.PreparedStatementAgent, com.stc.connector.appconn.db.StatementAgent, com.stc.connector.db.SessionEventListener
Direct Known Subclasses:
OracleCallableStatementAgent

public class OraclePreparedStatementAgent
extends PreparedStatementAgentImpl

Agent hosts PreparedStatement interface for Oracle.

Version:
$Revision: 1.1 $
Author:
$Author: npiega $

Constructor Summary
OraclePreparedStatementAgent()
          Default constructor to create an OraclePraparedStatementAgent instance.
OraclePreparedStatementAgent(com.stc.connector.db.Session session)
          Constructor to create an OraclePraparedStatementAgent instance.
OraclePreparedStatementAgent(com.stc.connector.db.Session session, int iScroll, int iConcur)
          Constructor to create an OraclePraparedStatementAgent instance.
OraclePreparedStatementAgent(com.stc.connector.db.Session session, java.lang.String sSql)
          Constructor to create an OraclePraparedStatementAgent instance.
OraclePreparedStatementAgent(com.stc.connector.db.Session session, java.lang.String sSql, int iScroll, int iConcur)
          Constructor to create an OraclePraparedStatementAgent instance.
 
Method Summary
 boolean resultsAvailable()
          Determines whether results (Update Counts and/or Result Sets) are available after an execute.
 void setOracleCursorOrds(int[] cursorOrds)
          Sets the Oracle cursor ordinals.
 
Methods inherited from class com.stc.connector.oracleadapter.base.PreparedStatementAgentImpl
addBatch, clearParameters, curRSetSig, enableResultSetsAndUpdateCounts, enableResultSetsOnly, enableUpdateCountsOnly, execute, executeQuery, executeUpdate, getCurRSetAgent, getPreparedStmt, getQueryString, getRSAgentList, getRSAgentSigs, getUpdateCount, matchResultSetSignature, sessionOpen, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setCurRSetAgent, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setRSAgentList, setRSAgentSigs, setShort, setString, setTime, setTime, setTimestamp, setTimestamp
 
Methods inherited from class com.stc.connector.oracleadapter.base.StatementAgentImpl
cancel, clearBatch, clearWarnings, executeBatch, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetType, getWarnings, isClosed, queryName, resultSetConcurToString, resultSetDirToString, resultSetTypeToString, sessionClose, sessionReset, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, stmtInvoke
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
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
 

Constructor Detail

OraclePreparedStatementAgent

public OraclePreparedStatementAgent()
Default constructor to create an OraclePraparedStatementAgent instance.


OraclePreparedStatementAgent

public OraclePreparedStatementAgent(com.stc.connector.db.Session session)
Constructor to create an OraclePraparedStatementAgent instance.

Parameters:
session - a Session object used to hold connection information.

OraclePreparedStatementAgent

public OraclePreparedStatementAgent(com.stc.connector.db.Session session,
                                    int iScroll,
                                    int iConcur)
Constructor to create an OraclePraparedStatementAgent instance.

Parameters:
session - a Session object used to hold connection information.
iScroll - resultset type; TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE.
iConcur - concurrency type; CONCUR_READ_ONLY, CONCUR_UPDATABLE.

OraclePreparedStatementAgent

public OraclePreparedStatementAgent(com.stc.connector.db.Session session,
                                    java.lang.String sSql)
Constructor to create an OraclePraparedStatementAgent instance.

Parameters:
session - a Session object used to hold connection information.
sSql - a SQL statement for the prepared statement.

OraclePreparedStatementAgent

public OraclePreparedStatementAgent(com.stc.connector.db.Session session,
                                    java.lang.String sSql,
                                    int iScroll,
                                    int iConcur)
Constructor to create an OraclePraparedStatementAgent instance.

Parameters:
session - a Session object used to hold connection information.
sSql - a SQL statement for the prepared statement.
iScroll - resultset type; TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
iConcur - concurrency type; CONCUR_READ_ONLY, CONCUR_UPDATABLE.
Method Detail

resultsAvailable

public boolean resultsAvailable()
                         throws java.sql.SQLException
Determines whether results (Update Counts and/or Result Sets) are available after an execute.

Specified by:
resultsAvailable in interface com.stc.connector.appconn.db.PreparedStatementAgent
Overrides:
resultsAvailable in class PreparedStatementAgentImpl
Returns:
true if Update Counts and/or Result Sets are available.
Throws:
java.sql.SQLException - when SQL problems occur. when SQL problems occur.

setOracleCursorOrds

public void setOracleCursorOrds(int[] cursorOrds)
Sets the Oracle cursor ordinals.

Parameters:
cursorOrds - an arrary of integer ordinals.

Sun Adapter for Oracle Applications API

Copyright © 2008 Sun Microsystems, Inc.