Sun Adapter for DB2 Universal Database

com.stc.connector.db2adapter
Class Db2PreparedStatementAgent

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

public class Db2PreparedStatementAgent
extends PreparedStatementAgentImpl

Agent hosts PreparedStatement interface for Db2.

Version:
$Revision: 1.5 $
Author:
$Author: cmbuild $

Field Summary
 
Fields inherited from class com.stc.connector.db2adapter.base.PreparedStatementAgentImpl
askGetMoreResults, askGetResultSet, bUseResultsAvailable, curRSetAgent, curRSetSig, nParam, nUpdateCount, retResultSet, retUpdateCount, sCommand
 
Fields inherited from class com.stc.connector.db2adapter.base.StatementAgentImpl
concurrencyType, listener, resultSetConcurMap, resultsetDirection, resultSetDirMap, resultsetType, resultSetTypeMap, session, sqlException, statement, statementClassName
 
Constructor Summary
Db2PreparedStatementAgent()
          Default constructor to create an Db2PraparedStatementAgent instance.
Db2PreparedStatementAgent(com.stc.connector.db.Session session)
          Constructor to create an Db2PraparedStatementAgent instance.
Db2PreparedStatementAgent(com.stc.connector.db.Session session, int iScroll, int iConcur)
          Constructor to create an Db2PraparedStatementAgent instance.
Db2PreparedStatementAgent(com.stc.connector.db.Session session, java.lang.String sSql)
          Constructor to create an Db2PraparedStatementAgent instance.
Db2PreparedStatementAgent(com.stc.connector.db.Session session, java.lang.String sSql, int iScroll, int iConcur)
          Constructor to create an Db2PraparedStatementAgent instance.
 
Method Summary
 boolean resultsAvailable()
          Determines whether results (Update Counts and/or Result Sets) are available after an execute.
 void setDb2CursorOrds(int[] cursorOrds)
          Sets the Db2 cursor ordinals.
 
Methods inherited from class com.stc.connector.db2adapter.base.PreparedStatementAgentImpl
addBatch, clearParameters, curRSetSig, enableResultSetsAndUpdateCounts, enableResultSetsOnly, enableUpdateCountsOnly, execute, executeQuery, executeUpdate, getCurRSetAgent, getPreparedStmt, 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.db2adapter.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
clone, equals, finalize, 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

Db2PreparedStatementAgent

public Db2PreparedStatementAgent()
Default constructor to create an Db2PraparedStatementAgent instance.


Db2PreparedStatementAgent

public Db2PreparedStatementAgent(com.stc.connector.db.Session session)
Constructor to create an Db2PraparedStatementAgent instance.

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

Db2PreparedStatementAgent

public Db2PreparedStatementAgent(com.stc.connector.db.Session session,
                                 int iScroll,
                                 int iConcur)
Constructor to create an Db2PraparedStatementAgent 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.

Db2PreparedStatementAgent

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

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

Db2PreparedStatementAgent

public Db2PreparedStatementAgent(com.stc.connector.db.Session session,
                                 java.lang.String sSql,
                                 int iScroll,
                                 int iConcur)
Constructor to create an Db2PraparedStatementAgent 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.

setDb2CursorOrds

public void setDb2CursorOrds(int[] cursorOrds)
Sets the Db2 cursor ordinals.

Parameters:
cursorOrds - an arrary of integer ordinals.

Sun Adapter for DB2 Universal Database