com.stc.connector.sqlserveradapter
Class SqlserverPreparedStatementAgent

java.lang.Object
  com.stc.connector.sqlserveradapter.base.StatementAgentImpl
      com.stc.connector.sqlserveradapter.base.PreparedStatementAgentImpl
          com.stc.connector.sqlserveradapter.SqlserverPreparedStatementAgent

All Implemented Interfaces:

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

Direct Known Subclasses:

SqlserverCallableStatementAgent

public class SqlserverPreparedStatementAgent
extends PreparedStatementAgentImpl

Agent hosts PreparedStatement interface for Sqlserver.

Version:

$Revision: 1.5 $

Author:

$Author: cmbuild $

Field Summary

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

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

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

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

Constructor Summary

SqlserverPreparedStatementAgent()
Default constructor to create an SqlserverPraparedStatementAgent instance.

SqlserverPreparedStatementAgent(com.stc.connector.db.Session session)
Constructor to create an SqlserverPraparedStatementAgent instance.

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

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

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

Method Summary

void	setSqlserverCursorOrds(int[] cursorOrds) Sets the SQL Server cursor ordinals.

Methods inherited from class com.stc.connector.sqlserveradapter.base.PreparedStatementAgentImpl

addBatch, clearParameters, curRSetSig, enableResultSetsAndUpdateCounts, enableResultSetsOnly, enableUpdateCountsOnly, execute, executeQuery, executeUpdate, getCurRSetAgent, getPreparedStmt, getRSAgentList, getRSAgentSigs, getUpdateCount, matchResultSetSignature, resultsAvailable, 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.sqlserveradapter.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

SqlserverPreparedStatementAgent

public SqlserverPreparedStatementAgent()

Default constructor to create an SqlserverPraparedStatementAgent instance.

SqlserverPreparedStatementAgent

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

Constructor to create an SqlserverPraparedStatementAgent instance.

Parameters:

session - a Session object used to hold connection information.

SqlserverPreparedStatementAgent

public SqlserverPreparedStatementAgent(com.stc.connector.db.Session session,
                                       int iScroll,
                                       int iConcur)

Constructor to create an SqlserverPraparedStatementAgent 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.

SqlserverPreparedStatementAgent

public SqlserverPreparedStatementAgent(com.stc.connector.db.Session session,
                                       java.lang.String sSql)

Constructor to create an SqlserverPraparedStatementAgent instance.

Parameters:

session - a Session object used to hold connection information.

sSql - a SQL statement for the prepared statement.

SqlserverPreparedStatementAgent

public SqlserverPreparedStatementAgent(com.stc.connector.db.Session session,
                                       java.lang.String sSql,
                                       int iScroll,
                                       int iConcur)

Constructor to create an SqlserverPraparedStatementAgent 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

setSqlserverCursorOrds

public void setSqlserverCursorOrds(int[] cursorOrds)

Sets the SQL Server cursor ordinals.

Parameters:

cursorOrds - an arrary of integer ordinals.