Overview | Package | Class | Use | Tree | Deprecated | Index | Help
|  | BEA Systems, Inc.
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## BEA WebLogic Server 9.0 API Reference

## weblogic.jdbc.rowset
Interface WLRowSetMetaData

All Superinterfaces:
  ResultSetMetaData, RowSetMetaData

public interface WLRowSetMetaData
extends RowSetMetaData

WLRowSetMetaData extends the `javax.sql.RowSetMetaData` interface with extended meta-data methods.

The RowSet uses Optimistic concurrency control to maintain consistency between the time the data is read and when it is updated most likely in a separate transaction.

The descriptions of the optimistic concurrency policy options (such as VERIFY_READ_COLUMNS, VERIFY_MODIFIED_COLUMNS, etc.) use this simple table to demonstrate the behavior of each. The examples assume the RowSet contains all columns from this database table. Some options also use an additional e_version column.

     create table employees(
       e_id integer primary key,
       e_first varchar(25),
       e_last varchar(25),
       e_salary integer
     );

     Assume that this table has a single row:
     e_id = 1
     e_first = "John"
     e_last = "Doe"
     e_salary = 10000

  Copyright © 2005 BEA Systems, Inc. All Rights Reserved.

Field Summary
`static int` | `VERIFY_AUTO_VERSION_COLUMNS` The VERIFY_AUTO_VERSION_COLUMNS option includes the primary key columns and specified version columns in the WHERE clause.
`static int` | `VERIFY_MODIFIED_COLUMNS` The VERIFY_MODIFIED_COLUMNS only verifies the modified columns during the update.
`static int` | `VERIFY_NONE` The VERIFY_NONE option only includes the primary key columns in the WHERE clause.
`static int` | `VERIFY_READ_COLUMNS` The VERIFY_READ_COLUMNS optimistic concurrency policy includes all values read into the WLCachedRowSet in the where clause when changes are written back to the database.
`static int` | `VERIFY_SELECTED_COLUMNS` The VERIFY_SELECTED_COLUMNS only verifies specified columns and the primary key columns during the update.
`static int` | `VERIFY_VERSION_COLUMNS` The VERIFY_VERSION_COLUMNS option includes the primary key columns and specified version columns in the WHERE clause.

Fields inherited from interface java.sql.ResultSetMetaData
`columnNoNulls, columnNullable, columnNullableUnknown`

Method Summary
`int` | `findColumn(String n)` Returns the column index for the specified column name.
`boolean` | `getBatchDeletes()` Returns the current batch delete setting.
`boolean` | `getBatchInserts()` Returns the current batch insert setting.
`boolean` | `getBatchUpdates()` Returns the current batch update setting.
`int` | `getBatchVerifySize()` Returns the current batch verify size.
`String` | `getDefaultNamespace()` Returns the XML schema's default namespace for this RowSet.
`boolean` | `getGroupDeletes()` Returns the current group deletes setting.
`int` | `getGroupDeleteSize()` Returns the current group delete size.
`int` | `getOptimisticPolicy()` Returns the current optimistic concurrency policy.
`String` | `getOptimisticPolicyAsString()` Returns the current optimistic policy as a String
`String` | `getQualifiedTableName(int i)` getQualifiedTableName behaves like getTableName; however, if the catalog and/or schema name have been set then getQualifiedTableName returns catalog.schema.column.
`String` | `getQualifiedTableName(String n)` getQualifiedTableName behaves like getTableName; however, if the catalog and/or schema name have been set then getQualifiedTableName returns catalog.schema.column.
`String` | `getRowName()` Returns the name of the Row element in the schema and instance.
`String` | `getRowSetName()` Returns the name of the Row Set in the schema and instance.
`boolean` | `getVerboseSQL()` Returns the current verbose SQL setting
`String` | `getWriteColumnName(int i)` Returns the write column name for the specified column.
`String` | `getWriteColumnName(String colName)` Returns the write column name for the specified column.
`String` | `getWriteTableName()` Returns the write table name.
`String` | `getXMLSchemaLocation()` Returns the schemaLocation attribute which instance documents will use to refer to this schema document.
`boolean` | `haveSetPKColumns()` Indicates whether `setPrimaryKeyColumn` has been called on any of the columns.
`boolean` | `isAutoVersionColumn(int i)` Indicates whether the column will be used for a VERIFY_AUTO_VERSION_COLUMNS verification.
`boolean` | `isAutoVersionColumn(String colName)` Indicates whether the column will be used for a VERIFY_AUTO_VERSION_COLUMNS verification.
`boolean` | `isPrimaryKeyColumn(int i)` Indicates whether the column is a primary key column.
`boolean` | `isPrimaryKeyColumn(String colName)` Indicates whether the column is a primary key column.
`boolean` | `isReadOnly()` Indicates whether the entire RowSet is ReadOnly.
`boolean` | `isReadOnly(String colName)` Indicates whether the column is marked read-only.
`boolean` | `isSelectedColumn(int i)` Indicates whether the column will be used for a VERIFY_SELECTED_COLUMNS verification.
`boolean` | `isSelectedColumn(String colName)` Indicates whether the column will be used for a VERIFY_SELECTED_COLUMNS verification.
`boolean` | `isVersionColumn(int i)` Indicates whether the column will be used for a VERIFY_VERSION_COLUMNS verification.
`boolean` | `isVersionColumn(String colName)` Indicates whether the column will be used for a VERIFY_VERSION_COLUMNS verification.
`void` | `loadXMLSchema(XMLInputStream xis)` Loads the WLRowSetMetaData from an XML Schema document in the XMLInputStream.
`void` | `markUpdateProperties(String writeTableName, String pkColumn, String rowVersionColumn)` markUpdateProperties is a convenience method for indicating the writeTableName, a single primary key column, and a row version column.
`void` | `setAutoVersionColumn(int i, boolean b)` Sets a column to be a version column.
`void` | `setAutoVersionColumn(String colName, boolean b)` Sets a column to be a version column.
`void` | `setBatchDeletes(boolean b)` Sets whether DELETE statements should use a JDBC batch statement or should be issued as individual DELETE statements.
`void` | `setBatchInserts(boolean b)` Sets whether INSERT statements should use a JDBC batch statement or should be issued as individual INSERT statements.
`void` | `setBatchUpdates(boolean b)` Sets whether UPDATE statements should use a JDBC batch statement or should be issued as individual UPDATE statements.
`void` | `setBatchVerifySize(int size)` When batched updates and enabled and the database/driver do not return the updated row counts from batched statements, an extra select query is issued prior to the batched updates to ensure there is no optimistic conflict.
`void` | `setDefaultNamespace(String namespace)` Sets the XML schema's default namespace for this RowSet.
`void` | `setGroupDeletes(boolean b)` Sets the RowSet to use group deletes.
`void` | `setGroupDeleteSize(int size)` Sets the number of rows sent in an individual delete statement.
`void` | `setOptimisticPolicy(int policy)` Sets the optimistic concurrency policy for updates
`void` | `setOptimisticPolicyAsString(String policy)` Sets the optimistic concurrency policy for updates
`void` | `setPrimaryKeyColumn(int i, boolean b)` Sets the column to be a primary key column.
`void` | `setPrimaryKeyColumn(String colName, boolean b)` Sets the column to be a primary key column.
`void` | `setReadOnly(boolean b)` Sets the entire RowSet to be ReadOnly.
`void` | `setReadOnly(int i, boolean b)` Sets the column to be a read-only column.
`void` | `setReadOnly(String colName, boolean b)` Sets the column to be a read-only column.
`void` | `setRowName(String rowName)` Sets the name of the Row element in the schema and instance.
`void` | `setRowSetName(String rowSetName)` Sets the name of the Row Set in the schema and instance.
`void` | `setTableName(String tableName)` Sets the table name for all columns.
`void` | `setTableName(String colName, String tableName)` Sets the table name for the specified column.
`void` | `setVerboseSQL(boolean b)` Enables/disables printing of the executed SQL statements to System.out.
`void` | `setVerifySelectedColumn(int i, boolean b)` Sets a column to be verified during the update.
`void` | `setVerifySelectedColumn(String colName, boolean b)` Sets a column to be verified during the update.
`void` | `setVersionColumn(int i, boolean b)` Sets a column to be a version column.
`void` | `setVersionColumn(String colName, boolean b)` Sets a column to be a version column.
`void` | `setWriteColumnName(int i, String writeColumnName)` Sets the write column name for the specified column.
`void` | `setWriteColumnName(String colName, String writeColumnName)` Sets the write column name for the specified column.
`void` | `setWriteTableName(String writeTableName)` Sets a table to be the write table.
`void` | `setXMLSchemaLocation(String location)` Sets the schemaLocation attribute which instance documents will use to refer to this schema document.
`void` | `writeXMLSchema(XMLOutputStream xos)` Writes the WLRowSetMetaData as an XML Schema document to the specified XMLOutputStream.

Methods inherited from interface javax.sql.RowSetMetaData
`setAutoIncrement, setCaseSensitive, setCatalogName, setColumnCount, setColumnDisplaySize, setColumnLabel, setColumnName, setColumnType, setColumnTypeName, setCurrency, setNullable, setPrecision, setScale, setSchemaName, setSearchable, setSigned, setTableName`

Methods inherited from interface java.sql.ResultSetMetaData
`getCatalogName, getColumnClassName, getColumnCount, getColumnDisplaySize, getColumnLabel, getColumnName, getColumnType, getColumnTypeName, getPrecision, getScale, getSchemaName, getTableName, isAutoIncrement, isCaseSensitive, isCurrency, isDefinitelyWritable, isNullable, isReadOnly, isSearchable, isSigned, isWritable`

Field Detail

### VERIFY_AUTO_VERSION_COLUMNS

    public static final int VERIFY_AUTO_VERSION_COLUMNS

  The VERIFY_AUTO_VERSION_COLUMNS option includes the primary key columns and specified version columns in the WHERE clause. It checks during acceptChanges that the version columns have not changed since the rowset was populated. The WLRowSetMetaData.setAutoVersionColumn method must be called to indicate the version columns. The version columns must be integers.

  The VERIFY_AUTO_VERSION_COLUMNS automatically updates the version columns to the next increasing value

  UPDATE SET e_salary=20000, e_version=2 WHERE e_id=1 AND e_version=1

  See Also:
    `setOptimisticPolicy(int)`, `setOptimisticPolicyAsString(java.lang.String)`, Constant Field Values

### VERIFY_MODIFIED_COLUMNS

    public static final int VERIFY_MODIFIED_COLUMNS

  The VERIFY_MODIFIED_COLUMNS only verifies the modified columns during the update. The update statement's WHERE clause will include the primary key columns and the modified columns.

  For instance, if the RowSet attempts to update John Doe's salary to 20000, it will issue:

  UPDATE SET e_salary=20000 WHERE e_id=1 AND e_salary=10000

  See Also:
    `setOptimisticPolicy(int)`, `setOptimisticPolicyAsString(java.lang.String)`, Constant Field Values

### VERIFY_NONE

    public static final int VERIFY_NONE

  The VERIFY_NONE option only includes the primary key columns in the WHERE clause. It does not perform any data verification.

  For instance, if the RowSet attempts to update John Doe's salary to 20000, it will issue:

  UPDATE SET e_salary=20000 WHERE e_id=1

  See Also:
    `setOptimisticPolicy(int)`, `setOptimisticPolicyAsString(java.lang.String)`, Constant Field Values

### VERIFY_READ_COLUMNS

    public static final int VERIFY_READ_COLUMNS

  The VERIFY_READ_COLUMNS optimistic concurrency policy includes all values read into the WLCachedRowSet in the where clause when changes are written back to the database. This is the default policy. This is the default policy. With this option, the where clause in the update or delete statement includes all of the values which were read into the WLCachedRowSet. The update or delete will only succeed if the underlying data has not changed since being read from the database.

  For instance, if the RowSet attempts to update John Doe's salary to 20000, it will issue:

  UPDATE SET e_salary=20000 WHERE e_id=1 AND e_first='John' AND e_last='Doe' AND e_salary=10000

  See Also:
    Constant Field Values

### VERIFY_SELECTED_COLUMNS

    public static final int VERIFY_SELECTED_COLUMNS

  The VERIFY_SELECTED_COLUMNS only verifies specified columns and the primary key columns during the update. The user must have called setVerifySelectedColumn and WLRowSetMetaData.setPrimaryKeyColumn to mark the appropriate columns before calling `acceptChanges`.

  This method is used when the application wants complete control to customize which columns are verified.

  For instance, if the RowSet attempts to update John Doe's salary to 20000 and setVerifySelectedColumn("e_first") has been called, it will issue:

  UPDATE SET e_salary=20000 WHERE e_id=1 AND e_first='John'

  See Also:
    `setOptimisticPolicy(int)`, `setOptimisticPolicyAsString(java.lang.String)`, Constant Field Values

### VERIFY_VERSION_COLUMNS

    public static final int VERIFY_VERSION_COLUMNS

  The VERIFY_VERSION_COLUMNS option includes the primary key columns and specified version columns in the WHERE clause. It checks during acceptChanges that the version columns have not changed since the rowset was populated. The WLRowSetMetaData.setVersionColumn method must be called to indicate the version columns.

  The database must handle updating the version column to a new value. Some databases provide support for a version type that will automatically be updated, but it is also possible to write a database trigger to update the version column.

  UPDATE SET e_salary=20000 WHERE e_id=1 AND e_version=1

  See Also:
    `setOptimisticPolicy(int)`, `setOptimisticPolicyAsString(java.lang.String)`, Constant Field Values

Method Detail

### findColumn

    public int findColumn(String n)
                   throws SQLException

  Returns the column index for the specified column name.

  Returns:
    the column index for the specified column name
  Throws:
    `SQLException` - if the column name is not in the RowSet

### getBatchDeletes

    public boolean getBatchDeletes()

  Returns the current batch delete setting.

  By default, batch deletes are not enabled.

  Returns:
    the current batch delete setting

### getBatchInserts

    public boolean getBatchInserts()

  Returns the current batch insert setting.

  By default, batch inserts are not enabled.

  Returns:
    the current batch insert setting

### getBatchUpdates

    public boolean getBatchUpdates()

  Returns the current batch update setting.

  By default, batch updates are not enabled.

  Returns:
    the current batch update setting

### getBatchVerifySize

    public int getBatchVerifySize()

  Returns the current batch verify size.

  Returns:
    the current batch verify size

### getDefaultNamespace

    public String getDefaultNamespace()

  Returns the XML schema's default namespace for this RowSet. The default value is http://www.openuri.org

  Returns:
    default namespace

### getGroupDeletes

    public boolean getGroupDeletes()

  Returns the current group deletes setting. By default, group deletes are enabled.

  Returns:
    the current group deletes setting

### getGroupDeleteSize

    public int getGroupDeleteSize()

  Returns the current group delete size.

  Returns:
    the current group delete size

### getOptimisticPolicy

    public int getOptimisticPolicy()

  Returns the current optimistic concurrency policy.

  Possible values are:

  1 = VERIFY_READ_COLUMNS (the default)
  2 = VERIFY_MODIFIED_COLUMNS
  3 = VERIFY_SELECTED_COLUMNS
  4 = VERIFY_NONE
  5 = VERIFY_AUTO_VERSION_COLUMNS
  6 = VERIFY_VERSION_COLUMNS

  Returns:
    current optimistic policy

### getOptimisticPolicyAsString

    public String getOptimisticPolicyAsString()

  Returns the current optimistic policy as a String

### getQualifiedTableName

    public String getQualifiedTableName(int i)
                                 throws SQLException

  getQualifiedTableName behaves like getTableName; however, if the catalog and/or schema name have been set then getQualifiedTableName returns catalog.schema.column. For instance, if the schema name was "test" and the table name "products", getTableName would return "products", but getQualifiedTableName returns "test.products"

  Returns:
    fully qualified table name
  Throws:
    `SQLException`

### getQualifiedTableName

    public String getQualifiedTableName(String n)
                                 throws SQLException

  getQualifiedTableName behaves like getTableName; however, if the catalog and/or schema name have been set then getQualifiedTableName returns catalog.schema.column. For instance, if the schema name was "test" and the table name "products", getTableName would return "products", but getQualifiedTableName returns "test.products"

  Returns:
    fully qualified table name
  Throws:
    `SQLException`

### getRowName

    public String getRowName()

  Returns the name of the Row element in the schema and instance.

  The default value is getWriteTableName() + "Row". If the write table name has not been set, it defaults to "TableRow".

  Returns:
    the name of the Row element in the schema and instance

### getRowSetName

    public String getRowSetName()

  Returns the name of the Row Set in the schema and instance.

  The default value is getRowName() + "Set"

  Returns:
    the name of the Row Set in the schema and instance

### getVerboseSQL

    public boolean getVerboseSQL()

  Returns the current verbose SQL setting

  Returns:
    the current verbose SQL setting

### getWriteColumnName

    public String getWriteColumnName(int i)
                              throws SQLException

  Returns the write column name for the specified column. The write column name is the column name used in update statements. By default the write column name is the same as the column name. The write column name may be set to a different value with setWriteColumnName. This is commonly done when queries like SELECT colName as alias ... are done. In this case, the rowset only sees the column alias and needs the writeColumnName to be set to the actual column name for updates to be successful.

  Parameters:
    `i` - column number
  Returns:
    writeColumnName
  Throws:
    `SQLException`

### getWriteColumnName

    public String getWriteColumnName(String colName)
                              throws SQLException

  Returns the write column name for the specified column. The write column name is the column name used in update statements.

  By default the write column name is the same as the column name.

  The write column name may be set to a different value with setWriteColumnName. This is commonly done when queries like SELECT colName as alias ... are done. In this case, the rowset only sees the column alias and needs the writeColumnName to be set to the actual column name for updates to be successful.

  Parameters:
    `colName` - column name
  Returns:
    writeColumnName
  Throws:
    `SQLException`

### getWriteTableName

    public String getWriteTableName()

  Returns the write table name. By default, the write table name is null and all tables in the rowset are writable.

  Returns:
    the write table name

### getXMLSchemaLocation

    public String getXMLSchemaLocation()

  Returns the schemaLocation attribute which instance documents will use to refer to this schema document.

  The default value is: getDefaultNamespace()+"/" + getRowSetName()+".xsd"

### haveSetPKColumns

    public boolean haveSetPKColumns()

  Indicates whether `setPrimaryKeyColumn` has been called on any of the columns.

  This is generally useful for a RowSetWriter implementation which requires the user to set primary key columns to determine whether this has occurred.

  Returns:
    if setPrimaryKeyColumn has been called

### isAutoVersionColumn

    public boolean isAutoVersionColumn(int i)
                                throws SQLException

  Indicates whether the column will be used for a VERIFY_AUTO_VERSION_COLUMNS verification.

  Returns:
    true if setAutoVersionColumn(i, true) has been called.
  Throws:
    `SQLException`

### isAutoVersionColumn

    public boolean isAutoVersionColumn(String colName)
                                throws SQLException

  Indicates whether the column will be used for a VERIFY_AUTO_VERSION_COLUMNS verification.

  Returns:
    true if setAutoVersionColumn(colName, true) has been called.
  Throws:
    `SQLException`

### isPrimaryKeyColumn

    public boolean isPrimaryKeyColumn(int i)
                               throws SQLException

  Indicates whether the column is a primary key column.

  Parameters:
    `i` - column number
  Returns:
    isPrimaryKeyColumn
  Throws:
    `SQLException`

### isPrimaryKeyColumn

    public boolean isPrimaryKeyColumn(String colName)
                               throws SQLException

  Indicates whether the column is a primary key column.

  Parameters:
    `colName` - column name
  Returns:
    isPrimaryKeyColumn
  Throws:
    `SQLException`

### isReadOnly

    public boolean isReadOnly()
                       throws SQLException

  Indicates whether the entire RowSet is ReadOnly.

  Returns:
    isReadOnly
  Throws:
    `SQLException`

### isReadOnly

    public boolean isReadOnly(String colName)
                       throws SQLException

  Indicates whether the column is marked read-only.

  Parameters:
    `colName` - column name
  Returns:
    isReadOnly
  Throws:
    `SQLException`

### isSelectedColumn

    public boolean isSelectedColumn(int i)
                             throws SQLException

  Indicates whether the column will be used for a VERIFY_SELECTED_COLUMNS verification.

  Returns:
    true if setVerifySelectedColumn(i, true) has been called.
  Throws:
    `SQLException`

### isSelectedColumn

    public boolean isSelectedColumn(String colName)
                             throws SQLException

  Indicates whether the column will be used for a VERIFY_SELECTED_COLUMNS verification.

  Returns:
    true if setVerifySelectedColumn(colName, true) has been called.
  Throws:
    `SQLException`

### isVersionColumn

    public boolean isVersionColumn(int i)
                            throws SQLException

  Indicates whether the column will be used for a VERIFY_VERSION_COLUMNS verification.

  Returns:
    true if setVersionColumn(i, true) has been called.
  Throws:
    `SQLException`

### isVersionColumn

    public boolean isVersionColumn(String colName)
                            throws SQLException

  Indicates whether the column will be used for a VERIFY_VERSION_COLUMNS verification.

  Returns:
    true if setVersionColumn(colName, true) has been called.
  Throws:
    `SQLException`

### loadXMLSchema

    public void loadXMLSchema(XMLInputStream xis)
                       throws IOException,
                              SQLException

  Loads the WLRowSetMetaData from an XML Schema document in the XMLInputStream.

  Throws:
    `IOException`
    `SQLException`

### markUpdateProperties

    public void markUpdateProperties(String writeTableName,
                                     String pkColumn,
                                     String rowVersionColumn)
                              throws SQLException

  markUpdateProperties is a convenience method for indicating the writeTableName, a single primary key column, and a row version column. It is equivalent to doing:

       setTableName(writeTableName);
       setWriteTableName(writeTableName);
       setPrimaryKeyColumn(findColumn(pkColumn), true);
       setOptimisticPolicy(VERIFY_VERSION_COLUMNS);
       setVersionColumn(findColumn(rowVersionColumn), true);

  Throws:
    `SQLException`

### setAutoVersionColumn

    public void setAutoVersionColumn(int i,
                                     boolean b)
                              throws SQLException

  Sets a column to be a version column. This method is only used when the VERIFY_AUTO_VERSION_COLUMNS optimistic policy is being used.

  Parameters:
    `i` - column number
    `b` - isVersionColumn
  Throws:
    `SQLException`

### setAutoVersionColumn

    public void setAutoVersionColumn(String colName,
                                     boolean b)
                              throws SQLException

  Sets a column to be a version column. This method is only used when the VERIFY_AUTO_VERSION_COLUMNS optimistic policy is being used.

  Parameters:
    `colName` - column name
    `b` - isVersionColumn
  Throws:
    `SQLException`

### setBatchDeletes

    public void setBatchDeletes(boolean b)

  Sets whether DELETE statements should use a JDBC batch statement or should be issued as individual DELETE statements. Using batch deletes leads to better performance when multiple deletes are done in a single RowSet.

  Batch deletes require a JDBC 2.0 or later driver that supports the java.sql.PreparedStatement.addBatch method

  By default, batch deletes are not enabled.

### setBatchInserts

    public void setBatchInserts(boolean b)

  Sets whether INSERT statements should use a JDBC batch statement or should be issued as individual INSERT statements. Using batch inserts leads to better performance when multiple inserts are done in a single RowSet.

  Batch inserts require a JDBC 2.0 or later driver that supports the java.sql.PreparedStatement.addBatch method

  By default, batch inserts are not enabled.

### setBatchUpdates

    public void setBatchUpdates(boolean b)

  Sets whether UPDATE statements should use a JDBC batch statement or should be issued as individual UPDATE statements. Using batch updates leads to better performance when multiple updates with the same SQL but different parameters are done in a single acceptChanges call

  Batch updates require a JDBC 2.0 or later driver that supports the java.sql.PreparedStatement.addBatch method

  By default, batch updates are not enabled.

### setBatchVerifySize

    public void setBatchVerifySize(int size)
                            throws SQLException

  When batched updates and enabled and the database/driver do not return the updated row counts from batched statements, an extra select query is issued prior to the batched updates to ensure there is no optimistic conflict. This parameter determines the number of rows included in each select statement. This parameter is only used when batched updates are used with an Oracle database. The default value is 50.

  Throws:
    `SQLException` - if the size is <= 0

### setDefaultNamespace

    public void setDefaultNamespace(String namespace)

  Sets the XML schema's default namespace for this RowSet.

### setGroupDeletes

    public void setGroupDeletes(boolean b)

  Sets the RowSet to use group deletes. With group deletes, the rowset issues SQL statements where the WHERE clause includes several deleted rows. For instance, the rowset would normally issue: DELETE FROM employees WHERE id = 1; DELETE FROM employees WHERE id = 2; When group deletes are enabled, it will issue: DELETE FROM employees WHERE id = 1 OR id = 2;

### setGroupDeleteSize

    public void setGroupDeleteSize(int size)
                            throws SQLException

  Sets the number of rows sent in an individual delete statement. Tuning this larger produces less database round-trips but larger SQL statements. The default value is 50.

  Throws:
    `SQLException` - if the size is <= 0

### setOptimisticPolicy

    public void setOptimisticPolicy(int policy)
                             throws SQLException

  Sets the optimistic concurrency policy for updates

  Possible values are:

  1 = VERIFY_READ_COLUMNS (the default)
  2 = VERIFY_MODIFIED_COLUMNS
  3 = VERIFY_SELECTED_COLUMNS
  4 = VERIFY_NONE
  5 = VERIFY_AUTO_VERSION_COLUMNS
  6 = VERIFY_VERSION_COLUMNS

  setOptimisticPolicy must be called before calling `acceptChanges`.

  Throws:
    `SQLException` - thrown if the policy is not a legal value

### setOptimisticPolicyAsString

    public void setOptimisticPolicyAsString(String policy)
                                     throws SQLException

  Sets the optimistic concurrency policy for updates

  Possible values are:

  VERIFY_READ_COLUMNS (the default)

  VERIFY_MODIFIED_COLUMNS

  VERIFY_SELECTED_COLUMNS

  VERIFY_NONE

  VERIFY_AUTO_VERSION_COLUMNS

  VERIFY_VERSION_COLUMNS

  setOptimisticPolicy must be called before calling `acceptChanges`.

  Throws:
    `SQLException` - thrown if the policy is not a legal value

### setPrimaryKeyColumn

    public void setPrimaryKeyColumn(int i,
                                    boolean b)
                             throws SQLException

  Sets the column to be a primary key column.

  Marking a column to be a primary key automatically marks it as read-only. To update a primary key column, it is necessary to explicitly call setReadOnly(col, false) after setPrimaryKeyColumn.

  Parameters:
    `i` - column number
    `b` - isPrimaryKey
  Throws:
    `SQLException`

### setPrimaryKeyColumn

    public void setPrimaryKeyColumn(String colName,
                                    boolean b)
                             throws SQLException

  Sets the column to be a primary key column.

  Marking a column to be a primary key automatically marks it as read-only. To update a primary key column, it is necessary to explicitly call setReadOnly(col, false) after setPrimaryKeyColumn.

  Parameters:
    `colName` - column name
    `b` - isPrimaryKey
  Throws:
    `SQLException`

### setReadOnly

    public void setReadOnly(boolean b)
                     throws SQLException

  Sets the entire RowSet to be ReadOnly.

  Parameters:
    `b` - isReadOnly
  Throws:
    `SQLException`

### setReadOnly

    public void setReadOnly(int i,
                            boolean b)
                     throws SQLException

  Sets the column to be a read-only column.

  Parameters:
    `i` - column number
    `b` - isReadOnly
  Throws:
    `SQLException`

### setReadOnly

    public void setReadOnly(String colName,
                            boolean b)
                     throws SQLException

  Sets the column to be a read-only column.

  Parameters:
    `colName` - column name
    `b` - isReadOnly
  Throws:
    `SQLException`

### setRowName

    public void setRowName(String rowName)

  Sets the name of the Row element in the schema and instance.

### setRowSetName

    public void setRowSetName(String rowSetName)

  Sets the name of the Row Set in the schema and instance.

### setTableName

    public void setTableName(String tableName)
                      throws SQLException

  Sets the table name for all columns. This method should be called after data has been read into the RowSet.

  The RowSet implementation will attempt to infer table names when it is populated with data. However, many JDBC drivers do not implement `java.sql.ResultSetMetaData.getTable`, so it is usually required to call setTableName before writing the RowSet's data.

  Throws:
    `SQLException`

### setTableName

    public void setTableName(String colName,
                             String tableName)
                      throws SQLException

  Sets the table name for the specified column. This method should be called after data has been read into the RowSet.

  The RowSet implementation will attempt to infer table names when it is populated with data. However, many JDBC drivers do not implement `java.sql.ResultSetMetaData.getTable` so it is usually required to call setTableName before writing the RowSet's data.

  Throws:
    `SQLException`

### setVerboseSQL

    public void setVerboseSQL(boolean b)

  Enables/disables printing of the executed SQL statements to System.out. By default, verbose sql is off.

### setVerifySelectedColumn

    public void setVerifySelectedColumn(int i,
                                        boolean b)
                                 throws SQLException

  Sets a column to be verified during the update. This method is only used when the VERIFY_SELECTED_COLUMNS optimistic policy is being used.

  Parameters:
    `i` - column number
    `b` - isVerifiedColumn
  Throws:
    `SQLException`

### setVerifySelectedColumn

    public void setVerifySelectedColumn(String colName,
                                        boolean b)
                                 throws SQLException

  Sets a column to be verified during the update. This method is only used when the VERIFY_SELECTED_COLUMNS optimistic policy is being used.

  Parameters:
    `colName` - column name
    `b` - isVerifiedColumn
  Throws:
    `SQLException`

### setVersionColumn

    public void setVersionColumn(int i,
                                 boolean b)
                          throws SQLException

  Sets a column to be a version column. This method is only used when the VERIFY_VERSION_COLUMNS optimistic policy is being used.

  Parameters:
    `i` - column number
    `b` - isVersionColumn
  Throws:
    `SQLException`

### setVersionColumn

    public void setVersionColumn(String colName,
                                 boolean b)
                          throws SQLException

  Sets a column to be a version column. This method is only used when the VERIFY_VERSION_COLUMNS optimistic policy is being used.

  Parameters:
    `colName` - column name
    `b` - isVersionColumn
  Throws:
    `SQLException`

### setWriteColumnName

    public void setWriteColumnName(int i,
                                   String writeColumnName)
                            throws SQLException

  Sets the write column name for the specified column. The write column name is the column name used in update statements.

  By default the write column name is the same as the column name.

  The write column name may be set to a different value with setWriteColumnName. This is commonly done when queries like SELECT colName as alias ... are done. In this case, the rowset only sees the column alias and needs the writeColumnName to be set to the actual column name for updates to be successful.

  Parameters:
    `i` - column number
    `writeColumnName` - write column name
  Throws:
    `SQLException`

### setWriteColumnName

    public void setWriteColumnName(String colName,
                                   String writeColumnName)
                            throws SQLException

  Sets the write column name for the specified column. The write column name is the column name used in update statements.

  By default the write column name is the same as the column name.

  The write column name may be set to a different value with setWriteColumnName. This is commonly done when queries like SELECT colName as alias ... are done. In this case, the rowset only sees the column alias and needs the writeColumnName to be set to the actual column name for updates to be successful.

  Parameters:
    `colName` - column name
    `writeColumnName` - write column name
  Throws:
    `SQLException`

### setWriteTableName

    public void setWriteTableName(String writeTableName)
                           throws SQLException

  Sets a table to be the write table.

  The write table is the only table that can be updated or deleted.

  This is typically used when a RowSet is populated via a join from multiple tables, but the rowset should only update one table.

  Any column which is not from the write table is marked as read-only.

  For instance, a rowset might include a join of orders and customers. The write table could be set to orders. If deleteRow were called, it would delete the order row, but not delete the customer row.

  Parameters:
    `writeTableName` - the write table name
  Throws:
    `SQLException`

### setXMLSchemaLocation

    public void setXMLSchemaLocation(String location)

  Sets the schemaLocation attribute which instance documents will use to refer to this schema document.

### writeXMLSchema

    public void writeXMLSchema(XMLOutputStream xos)
                        throws IOException,
                               SQLException

  Writes the WLRowSetMetaData as an XML Schema document to the specified XMLOutputStream.

  Throws:
    `IOException`
    `SQLException`

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
| Documentation is available at http://e-docs.bea.com/wls/docs90 Copyright 2005 BEA Systems Inc.
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD