Java Doc for CachedRowSetX.java in  » IDE-Netbeans » visualweb.api.designer » com » sun » sql » rowset » Java Source Code / Java DocumentationJava Source Code and Java Documentation

1.0 Overview

A com.sun.sql.rowset.CachedRowSetX object differs from a CachedRowSet object in the following ways:

• An isExecuted() method will return true if the com.sun.sql.rowset.CachedRowSetX is in a state where navigation and getters and setters can be called on rows returned from the database (i.e., returns true if execute or populate has been called.
• The following "advanced" properties have been added. These properties are useful in the case of incomplete or incorrect information being supplied by JDBC drivers.
  Note: In most cases, these advanced properties do not need to be set (i.e., they can be left set to their default null value (or false in the case of printStatements). For the cases where the advanced properties must be used, it is helpful to set the printStatements property to true first. In that way, one can then determine what advanced properties must be set. By setting the catalog and schema for the table to be upadted and by explicitly setting cataloag, table, schema and column names for each column, one can explicitly set what columns will participate in inserts, updates and deletes. Futher control can be gained by setting the updatableColumns and insertableColumns properties. Note: if updatableColumns is set and insertableColumns is not set, it is assumed that updateableColumns applies to both updates and inserts.
  • catalogName: the name of the catalog that contains the table referred to by tableName
  • schemaName: the name of the schema that contains the table referred to by tableName
  • columnCatalogNames: an array of String , one for each column, which contains the name of catalog of the corresponding column (each element can also be null
  • columnSchemaNames: an array of String , one for each column, which contains the name of the schema of the corresponding column (each element can also be null
  • columnTableNames: an array of String , one for each column, which contains the name of the table of the corresponding column (each element can also be null
  • columnNames: an array of String , one for each column, which contains the name of the corresponding column (each element can also be null
  • insertableColumns: an array of boolean, one for each column, which contains true if the corresponding column can be inserted, else it contains false/code>
  • updatableColumns: an array of boolean, one for each column, which contains true if the corresponding column can be updated, else it contains false/code>
  • printStatements: a boolean{/code> that when true will result in internally generated INSERT, UPDATE, and DELETE SQL statements being written to System.out. This output is useful in determining why inserts,updates and/or deletes are falling and in deciding what advanced properties to set in order to address the problems.
• PropertyChangeListener support
  The following are bound properties:
  • command
  • dataSourceName
  • maxRows
  • password
  • type
  • url
  • username
• support to use the com.sun.sql.rowset.CachedRowSetX after calling close on it.
• by default, a com.sun.sql.rowset.CachedRowSetX 's properties are set to:
  • command: null
  • escapeProcessing: true
  • keyColumns: null
  (ignored)
  • maxFieldSize: 0
  • maxRows: 0
  • password: null
  • readOnly: true (ignored)
  • showDeleted: false
  • typeMap: null
  • url: null
  • username: null
• the readOnly property is currently not used
• it is well defined how property changes affect the state of a com.sun.sql.rowset.CachedRowSetX
  • autoCommit: nothing is invalidated
  • command: release() is called
  • concurrency: nohting is invalidated
  • escapeProcessing: nothing is invalidated
  • maxFieldSize: nothing is invalidated
  • maxRows: nothing is invalidated
  • password: nothing is invalidated
  • readOnly: nothing is invalidated
  • showDeleted: nothing is invalidated
  • transactionIsolation: nothing is invalidated
  • type: nothing is invalidated
  • typeMap: nothing is invalidated
  • url: release() is called
  • username: release() is called
• calling close will never throw a SQLException

a String object giving the name of the catalog that containsthe table referred to by tableName

Note: This method is called by com.sun.sql.rowset.internal.CachedRowSetXWriter.

Note, the column is zero based whereas most jdbc calls are one based.

a String object or null
throws:
  NullPointerException - if columnCatalogNames was never set.
throws:
  ArrayIndexOutOfBoundsException - if index is >=columnCatalogName.length

Note, the column is zero based whereas most jdbc calls are one based.

a String object or null
throws:
  NullPointerException - if columnNames was never set.
throws:
  ArrayIndexOutOfBoundsException - if index is >=columnName.length

Note, the column is zero based whereas most jdbc calls are one based.

a String object or null
throws:
  NullPointerException - if columnSchemaNames was never set.
throws:
  ArrayIndexOutOfBoundsException - if index is >=columnSchemaName.length

Note, the column is zero based whereas most jdbc calls are one based.

a String object or null
throws:
  NullPointerException - if columnTableNames was never set.
throws:
  ArrayIndexOutOfBoundsException - if index is >=columnTableName.length

a String object giving the name of the catalog that containsthe table referred to by tableName

Note: This method is called by com.sun.sql.rowset.internal.CachedRowSetXWriter.

The implementation of this com.sun.sql.rowset.CachedRowSetX object may obtain the the name internally from the com.sun.sql.rowset.RowSetMetaDataXImpl object.

Note: This method is called by com.sun.sql.rowset.internal.CachedRowSetXWriter .

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.

The implementation of this com.sun.sql.rowset.CachedRowSetX object may obtain the the name internally from the com.sun.sql.rowset.RowSetMetaDataXImpl object.
Parameters:
  schemaName - a String object identifying the schema of the tablefrom which this com.sun.sql.rowset.CachedRowSetX object was derived; can benull or an empty String
See Also:   javax.sql.RowSetMetaData.setSchemaName
See Also:   javax.sql.RowSetWriter

Note, the column is zero based whereas most jdbc calls are one based.

Note, the column is zero based whereas most jdbc calls are one based.