com.stc.connector.db2connectadapter
Class Db2ConnectPreparedStatementAgent

java.lang.Object
  com.stc.connector.db2connectadapter.base.StatementAgentImpl
      com.stc.connector.db2connectadapter.base.PreparedStatementAgentImpl
          com.stc.connector.db2connectadapter.Db2ConnectPreparedStatementAgent

All Implemented Interfaces:

com.stc.connector.appconn.db.PreparedStatementAgent, com.stc.connector.appconn.db.StatementAgent, com.stc.connector.db.SessionEventListener

Direct Known Subclasses:

Db2ConnectCallableStatementAgent

public class Db2ConnectPreparedStatementAgent
extends PreparedStatementAgentImpl

Agent hosts PreparedStatement interface for Db2.

Version:

$Revision: 1.3 $

Author:

$Author: cmbuild $

Field Summary

Fields inherited from class com.stc.connector.db2connectadapter.base.PreparedStatementAgentImpl

askGetMoreResults, askGetResultSet, bUseResultsAvailable, curRSetAgent, curRSetSig, nParam, nUpdateCount, retResultSet, retUpdateCount, sCommand

Fields inherited from class com.stc.connector.db2connectadapter.base.StatementAgentImpl

concurrencyType, listener, resultSetConcurMap, resultsetDirection, resultSetDirMap, resultsetType, resultSetTypeMap, session, sqlException, statement, statementClassName

Constructor Summary

Db2ConnectPreparedStatementAgent()
Default constructor to create an Db2PraparedStatementAgent instance.

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

Db2ConnectPreparedStatementAgent(com.stc.connector.db.Session session, int iScroll, int iConcur)
Constructor to create an Db2PraparedStatementAgent instance.

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

Db2ConnectPreparedStatementAgent(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	setDb2ConnectCursorOrds(int[] cursorOrds) Sets the Db2 cursor ordinals.

Methods inherited from class com.stc.connector.db2connectadapter.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.db2connectadapter.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

Db2ConnectPreparedStatementAgent

public Db2ConnectPreparedStatementAgent()

Default constructor to create an Db2PraparedStatementAgent instance.

Db2ConnectPreparedStatementAgent

public Db2ConnectPreparedStatementAgent(com.stc.connector.db.Session session)

Constructor to create an Db2PraparedStatementAgent instance.

Parameters:

session - a Session object used to hold connection information.

Db2ConnectPreparedStatementAgent

public Db2ConnectPreparedStatementAgent(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.

Db2ConnectPreparedStatementAgent

public Db2ConnectPreparedStatementAgent(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.

Db2ConnectPreparedStatementAgent

public Db2ConnectPreparedStatementAgent(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.

setDb2ConnectCursorOrds

public void setDb2ConnectCursorOrds(int[] cursorOrds)

Sets the Db2 cursor ordinals.

Parameters:

cursorOrds - an arrary of integer ordinals.