Field Detail

• onInsertRow

  protected boolean onInsertRow

  Indicates currently inserting.

• insertRow

  protected ParamInfo[] insertRow

  Buffer row used for inserts.

• updateRow

  protected ParamInfo[] updateRow

  The "update" row.

• rowUpdated

  protected boolean rowUpdated

  Indicates that row has been updated.

• rowDeleted

  protected boolean rowDeleted

  Indicates that row has been deleted.

• tempResultSet

  protected final boolean tempResultSet

  True if this is a local temporary result set.

• cursorTds

  protected final TdsCore cursorTds

  Cursor TdsCore object.

• updateTds

  protected final TdsCore updateTds

  Updates TdsCore object used for positioned updates.

• isSybase

  protected boolean isSybase

  Flag to indicate Sybase.

• sizeChanged

  protected boolean sizeChanged

  Fetch size has been changed.

• sql

  protected java.lang.String sql

  Original SQL statement.

• procName

  protected final java.lang.String procName

  Original procedure name.

• procedureParams

  protected final ParamInfo[] procedureParams

  Original parameters.

• isKeyed

  protected boolean isKeyed

  Table is keyed.

• tableName

  protected java.lang.String tableName

  First table name in select.

• connection

  protected JtdsConnection connection

  The parent connection object

Constructor Detail

• CachedResultSet

  CachedResultSet​(JtdsStatement statement,
                  java.lang.String sql,
                  java.lang.String procName,
                  ParamInfo[] procedureParams,
                  int resultSetType,
                  int concurrency)
           throws java.sql.SQLException

  Constructs a new cached result set.

  This result set will either be cached in memory or, if the cursor name is set, can be a forward only server side cursor. This latter form of cursor can also support positioned updates.

  Parameters:

  statement - the parent statement object

  sql - the SQL statement used to build the result set

  procName - an optional stored procedure name

  procedureParams - parameters for prepared statements

  resultSetType - the result set type eg scrollable

  concurrency - the result set concurrency eg updateable

  Throws:

  java.sql.SQLException - if an error occurs

• CachedResultSet

  CachedResultSet​(JtdsStatement statement,
                  java.lang.String[] colName,
                  int[] colType)
           throws java.sql.SQLException

  Constructs a cached result set based on locally generated data.

  Parameters:

  statement - the parent statement object

  colName - array of column names

  colType - array of corresponding data types

  Throws:

  java.sql.SQLException - if an error occurs

• CachedResultSet

  CachedResultSet​(JtdsResultSet rs,
                  boolean load)
           throws java.sql.SQLException

  Creates a cached result set with the same columns (and optionally data) as an existing result set.

  Parameters:

  rs - the result set to copy

  load - load data from the supplied result set

  Throws:

  java.sql.SQLException - if an error occurs

• CachedResultSet

  CachedResultSet​(JtdsStatement statement,
                  ColInfo[] columns,
                  java.lang.Object[] data)
           throws java.sql.SQLException

  Creates a cached result set containing one row.

  Parameters:

  statement - the parent statement object

  columns - the column descriptor array

  data - the row data

  Throws:

  java.sql.SQLException - if an error occurs

Method Detail

• addRow

  void addRow​(java.lang.Object[] data)

  Warning! Ensure the provided data matches the column layout of this ResultSet. All kind of weird behavior and errors could be expected otherwise.

  Parameters:

  data - data of the row to add

• setConcurrency

  void setConcurrency​(int concurrency)

  Modify the concurrency of the result set.

  Use to make result set read only once loaded.

  Parameters:

  concurrency - the concurrency value eg ResultSet.CONCUR_READ_ONLY

• cursorCreate

  private void cursorCreate()
                     throws java.sql.SQLException

  Creates a new scrollable result set in memory or a named server cursor.

  Throws:

  java.sql.SQLException - if an error occurs

• isCursorUpdateable

  boolean isCursorUpdateable()
                      throws java.sql.SQLException

  Analyses the tables in the result set and determines if the primary key columns needed to make it updateable exist.

  Sybase (and SQL 6.5) will automatically include any additional key and timestamp columns as hidden fields even if the user does not reference them in the select statement.

  If the table is unkeyed but there is an identity column then this is promoted to a key.

  Alternatively we can update, provided all the columns in the table row have been selected, by regarding all of them as keys.

  SQL Server 7+ does not return the correct primary key meta data for temporary tables so the driver has to query the catalog to locate any keys.

  Returns:

  true if there is one table and it is keyed

  Throws:

  java.sql.SQLException