java.sql.ResultSetMetaData
, javax.sql.RowSetMetaData
, java.sql.Wrapper
@Deprecated
public interface WLRowSetMetaData
extends javax.sql.RowSetMetaData
Modifier and Type | Field | Description |
---|---|---|
static int |
VERIFY_AUTO_VERSION_COLUMNS |
Deprecated.
The VERIFY_AUTO_VERSION_COLUMNS option includes the primary key
columns and specified version columns in the WHERE clause.
|
static int |
VERIFY_MODIFIED_COLUMNS |
Deprecated.
The VERIFY_MODIFIED_COLUMNS only verifies the modified columns
during the update.
|
static int |
VERIFY_NONE |
Deprecated.
The VERIFY_NONE option only includes the primary key columns in
the WHERE clause.
|
static int |
VERIFY_READ_COLUMNS |
Deprecated.
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 |
Deprecated.
The VERIFY_SELECTED_COLUMNS only verifies specified columns and
the primary key columns during the update.
|
static int |
VERIFY_VERSION_COLUMNS |
Deprecated.
The VERIFY_VERSION_COLUMNS option includes the primary key
columns and specified version columns in the WHERE clause.
|
Modifier and Type | Method | Description |
---|---|---|
int |
findColumn(java.lang.String n) |
Deprecated.
Returns the column index for the specified column name.
|
boolean |
getBatchDeletes() |
Deprecated.
Returns the current batch delete setting.
|
boolean |
getBatchInserts() |
Deprecated.
Returns the current batch insert setting.
|
boolean |
getBatchUpdates() |
Deprecated.
Returns the current batch update setting.
|
int |
getBatchVerifySize() |
Deprecated.
Returns the current batch verify size.
|
java.lang.String |
getDefaultNamespace() |
Deprecated.
Returns the XML schema's default namespace for this RowSet.
|
boolean |
getGroupDeletes() |
Deprecated.
Returns the current group deletes setting.
|
int |
getGroupDeleteSize() |
Deprecated.
Returns the current group delete size.
|
int |
getOptimisticPolicy() |
Deprecated.
Returns the current optimistic concurrency policy.
|
java.lang.String |
getOptimisticPolicyAsString() |
Deprecated.
Returns the current optimistic policy as a String
|
java.lang.String |
getQualifiedTableName(int i) |
Deprecated.
getQualifiedTableName behaves like getTableName; however, if the
catalog and/or schema name have been set then getQualifiedTableName
returns catalog.schema.column.
|
java.lang.String |
getQualifiedTableName(java.lang.String n) |
Deprecated.
getQualifiedTableName behaves like getTableName; however, if the
catalog and/or schema name have been set then getQualifiedTableName
returns catalog.schema.column.
|
java.lang.String |
getRowName() |
Deprecated.
Returns the name of the Row element in the schema and instance.
|
java.lang.String |
getRowSetName() |
Deprecated.
Returns the name of the Row Set in the schema and instance.
|
boolean |
getVerboseSQL() |
Deprecated.
Returns the current verbose SQL setting
|
java.lang.String |
getWriteColumnName(int i) |
Deprecated.
Returns the write column name for the specified column.
|
java.lang.String |
getWriteColumnName(java.lang.String colName) |
Deprecated.
Returns the write column name for the specified column.
|
java.lang.String |
getWriteTableName() |
Deprecated.
Returns the write table name.
|
java.lang.String |
getXMLSchemaLocation() |
Deprecated.
Returns the schemaLocation attribute which instance documents
will use to refer to this schema document.
|
boolean |
haveSetPKColumns() |
Deprecated.
Indicates whether
setPrimaryKeyColumn has been called on any of the
columns. |
boolean |
isAutoVersionColumn(int i) |
Deprecated.
Indicates whether the column will be used for a
VERIFY_AUTO_VERSION_COLUMNS verification.
|
boolean |
isAutoVersionColumn(java.lang.String colName) |
Deprecated.
Indicates whether the column will be used for a
VERIFY_AUTO_VERSION_COLUMNS verification.
|
boolean |
isPrimaryKeyColumn(int i) |
Deprecated.
Indicates whether the column is a primary key column.
|
boolean |
isPrimaryKeyColumn(java.lang.String colName) |
Deprecated.
Indicates whether the column is a primary key column.
|
boolean |
isReadOnly() |
Deprecated.
Indicates whether the entire RowSet is ReadOnly.
|
boolean |
isReadOnly(java.lang.String colName) |
Deprecated.
Indicates whether the column is marked read-only.
|
boolean |
isSelectedColumn(int i) |
Deprecated.
Indicates whether the column will be used for a
VERIFY_SELECTED_COLUMNS verification.
|
boolean |
isSelectedColumn(java.lang.String colName) |
Deprecated.
Indicates whether the column will be used for a
VERIFY_SELECTED_COLUMNS verification.
|
boolean |
isVersionColumn(int i) |
Deprecated.
Indicates whether the column will be used for a
VERIFY_VERSION_COLUMNS verification.
|
boolean |
isVersionColumn(java.lang.String colName) |
Deprecated.
Indicates whether the column will be used for a
VERIFY_VERSION_COLUMNS verification.
|
void |
loadXMLSchema(XMLInputStream xis) |
Deprecated.
Loads the WLRowSetMetaData from an XML Schema document in the
XMLInputStream.
|
void |
markUpdateProperties(java.lang.String writeTableName,
java.lang.String pkColumn,
java.lang.String rowVersionColumn) |
Deprecated.
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) |
Deprecated.
Sets a column to be a version column.
|
void |
setAutoVersionColumn(java.lang.String colName,
boolean b) |
Deprecated.
Sets a column to be a version column.
|
void |
setBatchDeletes(boolean b) |
Deprecated.
Sets whether DELETE statements should use a JDBC batch statement
or should be issued as individual DELETE statements.
|
void |
setBatchInserts(boolean b) |
Deprecated.
Sets whether INSERT statements should use a JDBC batch statement
or should be issued as individual INSERT statements.
|
void |
setBatchUpdates(boolean b) |
Deprecated.
Sets whether UPDATE statements should use a JDBC batch statement
or should be issued as individual UPDATE statements.
|
void |
setBatchVerifySize(int size) |
Deprecated.
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(java.lang.String namespace) |
Deprecated.
Sets the XML schema's default namespace for this RowSet.
|
void |
setGroupDeletes(boolean b) |
Deprecated.
Sets the RowSet to use group deletes.
|
void |
setGroupDeleteSize(int size) |
Deprecated.
Sets the number of rows sent in an individual delete statement.
|
void |
setOptimisticPolicy(int policy) |
Deprecated.
Sets the optimistic concurrency policy for updates
|
void |
setOptimisticPolicyAsString(java.lang.String policy) |
Deprecated.
Sets the optimistic concurrency policy for updates
|
void |
setPrimaryKeyColumn(int i,
boolean b) |
Deprecated.
Sets the column to be a primary key column.
|
void |
setPrimaryKeyColumn(java.lang.String colName,
boolean b) |
Deprecated.
Sets the column to be a primary key column.
|
void |
setReadOnly(boolean b) |
Deprecated.
Sets the entire RowSet to be ReadOnly.
|
void |
setReadOnly(int i,
boolean b) |
Deprecated.
Sets the column to be a read-only column.
|
void |
setReadOnly(java.lang.String colName,
boolean b) |
Deprecated.
Sets the column to be a read-only column.
|
void |
setRowName(java.lang.String rowName) |
Deprecated.
Sets the name of the Row element in the schema and instance.
|
void |
setRowSetName(java.lang.String rowSetName) |
Deprecated.
Sets the name of the Row Set in the schema and instance.
|
void |
setTableName(java.lang.String tableName) |
Deprecated.
Sets the table name for all columns.
|
void |
setTableName(java.lang.String colName,
java.lang.String tableName) |
Deprecated.
Sets the table name for the specified column.
|
void |
setVerboseSQL(boolean b) |
Deprecated.
Enables/disables printing of the executed SQL statements to
System.out.
|
void |
setVerifySelectedColumn(int i,
boolean b) |
Deprecated.
Sets a column to be verified during the update.
|
void |
setVerifySelectedColumn(java.lang.String colName,
boolean b) |
Deprecated.
Sets a column to be verified during the update.
|
void |
setVersionColumn(int i,
boolean b) |
Deprecated.
Sets a column to be a version column.
|
void |
setVersionColumn(java.lang.String colName,
boolean b) |
Deprecated.
Sets a column to be a version column.
|
void |
setWriteColumnName(int i,
java.lang.String writeColumnName) |
Deprecated.
Sets the write column name for the specified column.
|
void |
setWriteColumnName(java.lang.String colName,
java.lang.String writeColumnName) |
Deprecated.
Sets the write column name for the specified column.
|
void |
setWriteTableName(java.lang.String writeTableName) |
Deprecated.
Sets a table to be the write table.
|
void |
setXMLSchemaLocation(java.lang.String location) |
Deprecated.
Sets the schemaLocation attribute which instance documents will
use to refer to this schema document.
|
void |
writeXMLSchema(XMLOutputStream xos) |
Deprecated.
Writes the WLRowSetMetaData as an XML Schema document to the
specified XMLOutputStream.
|
getCatalogName, getColumnClassName, getColumnCount, getColumnDisplaySize, getColumnLabel, getColumnName, getColumnType, getColumnTypeName, getPrecision, getScale, getSchemaName, getTableName, isAutoIncrement, isCaseSensitive, isCurrency, isDefinitelyWritable, isNullable, isReadOnly, isSearchable, isSigned, isWritable
setAutoIncrement, setCaseSensitive, setCatalogName, setColumnCount, setColumnDisplaySize, setColumnLabel, setColumnName, setColumnType, setColumnTypeName, setCurrency, setNullable, setPrecision, setScale, setSchemaName, setSearchable, setSigned, setTableName
static final int VERIFY_READ_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_first='John' AND e_last='Doe' AND e_salary=10000
static final int VERIFY_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
static final int VERIFY_SELECTED_COLUMNS
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'
static final int VERIFY_NONE
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
static final int VERIFY_AUTO_VERSION_COLUMNS
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
static final int VERIFY_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
int getOptimisticPolicy()
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
java.lang.String getOptimisticPolicyAsString()
void setOptimisticPolicy(int policy) throws java.sql.SQLException
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
.
java.sql.SQLException
- thrown if the policy is not a legal
valuevoid setOptimisticPolicyAsString(java.lang.String policy) throws java.sql.SQLException
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
.
java.sql.SQLException
- thrown if the policy is not a legal
valuevoid setBatchInserts(boolean b)
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.
boolean getBatchInserts()
By default, batch inserts are not enabled.
void setBatchDeletes(boolean b)
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.
boolean getBatchDeletes()
By default, batch deletes are not enabled.
void setBatchUpdates(boolean b)
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.
boolean getBatchUpdates()
By default, batch updates are not enabled.
void setVerboseSQL(boolean b)
boolean getVerboseSQL()
void setGroupDeletes(boolean b)
boolean getGroupDeletes()
void setGroupDeleteSize(int size) throws java.sql.SQLException
java.sql.SQLException
- if the size is <= 0< dd>
=>int getGroupDeleteSize()
void setBatchVerifySize(int size) throws java.sql.SQLException
java.sql.SQLException
- if the size is <= 0< dd>
=>int getBatchVerifySize()
int findColumn(java.lang.String n) throws java.sql.SQLException
java.sql.SQLException
- if the column name is not in the RowSetjava.lang.String getQualifiedTableName(java.lang.String n) throws java.sql.SQLException
java.sql.SQLException
java.lang.String getQualifiedTableName(int i) throws java.sql.SQLException
java.sql.SQLException
void setTableName(java.lang.String tableName) throws java.sql.SQLException
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.
java.sql.SQLException
void setTableName(java.lang.String colName, java.lang.String tableName) throws java.sql.SQLException
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.
java.sql.SQLException
void setPrimaryKeyColumn(int i, boolean b) throws java.sql.SQLException
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.
i
- column numberb
- isPrimaryKeyjava.sql.SQLException
void setPrimaryKeyColumn(java.lang.String colName, boolean b) throws java.sql.SQLException
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.
colName
- column nameb
- isPrimaryKeyjava.sql.SQLException
boolean isPrimaryKeyColumn(int i) throws java.sql.SQLException
i
- column numberjava.sql.SQLException
boolean isPrimaryKeyColumn(java.lang.String colName) throws java.sql.SQLException
colName
- column namejava.sql.SQLException
boolean haveSetPKColumns()
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.
boolean isReadOnly(java.lang.String colName) throws java.sql.SQLException
colName
- column namejava.sql.SQLException
void setReadOnly(int i, boolean b) throws java.sql.SQLException
i
- column numberb
- isReadOnlyjava.sql.SQLException
void setReadOnly(java.lang.String colName, boolean b) throws java.sql.SQLException
colName
- column nameb
- isReadOnlyjava.sql.SQLException
boolean isReadOnly() throws java.sql.SQLException
java.sql.SQLException
void setReadOnly(boolean b) throws java.sql.SQLException
b
- isReadOnlyjava.sql.SQLException
void setVerifySelectedColumn(int i, boolean b) throws java.sql.SQLException
i
- column numberb
- isVerifiedColumnjava.sql.SQLException
boolean isSelectedColumn(int i) throws java.sql.SQLException
java.sql.SQLException
boolean isSelectedColumn(java.lang.String colName) throws java.sql.SQLException
java.sql.SQLException
void setVerifySelectedColumn(java.lang.String colName, boolean b) throws java.sql.SQLException
colName
- column nameb
- isVerifiedColumnjava.sql.SQLException
void setAutoVersionColumn(int i, boolean b) throws java.sql.SQLException
i
- column numberb
- isVersionColumnjava.sql.SQLException
void setAutoVersionColumn(java.lang.String colName, boolean b) throws java.sql.SQLException
colName
- column nameb
- isVersionColumnjava.sql.SQLException
boolean isAutoVersionColumn(java.lang.String colName) throws java.sql.SQLException
java.sql.SQLException
boolean isAutoVersionColumn(int i) throws java.sql.SQLException
java.sql.SQLException
void setVersionColumn(int i, boolean b) throws java.sql.SQLException
i
- column numberb
- isVersionColumnjava.sql.SQLException
void setVersionColumn(java.lang.String colName, boolean b) throws java.sql.SQLException
colName
- column nameb
- isVersionColumnjava.sql.SQLException
boolean isVersionColumn(java.lang.String colName) throws java.sql.SQLException
java.sql.SQLException
boolean isVersionColumn(int i) throws java.sql.SQLException
java.sql.SQLException
void setWriteTableName(java.lang.String writeTableName) throws java.sql.SQLException
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.
writeTableName
- the write table namejava.sql.SQLException
java.lang.String getWriteTableName()
void markUpdateProperties(java.lang.String writeTableName, java.lang.String pkColumn, java.lang.String rowVersionColumn) throws java.sql.SQLException
setTableName(writeTableName); setWriteTableName(writeTableName); setPrimaryKeyColumn(findColumn(pkColumn), true); setOptimisticPolicy(VERIFY_VERSION_COLUMNS); setVersionColumn(findColumn(rowVersionColumn), true);
java.sql.SQLException
java.lang.String getWriteColumnName(int i) throws java.sql.SQLException
i
- column numberjava.sql.SQLException
java.lang.String getWriteColumnName(java.lang.String colName) throws java.sql.SQLException
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.
colName
- column namejava.sql.SQLException
void setWriteColumnName(int i, java.lang.String writeColumnName) throws java.sql.SQLException
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.
i
- column numberwriteColumnName
- write column namejava.sql.SQLException
void setWriteColumnName(java.lang.String colName, java.lang.String writeColumnName) throws java.sql.SQLException
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.
colName
- column namewriteColumnName
- write column namejava.sql.SQLException
void setDefaultNamespace(java.lang.String namespace)
namespace
- default namespacejava.lang.String getDefaultNamespace()
void setRowName(java.lang.String rowName)
rowName
- the row namejava.lang.String getRowName()
The default value is getWriteTableName() + "Row". If the write table name has not been set, it defaults to "TableRow".
void setRowSetName(java.lang.String rowSetName)
rowSetName
- the row set namejava.lang.String getRowSetName()
The default value is getRowName() + "Set"
void writeXMLSchema(XMLOutputStream xos) throws java.io.IOException, java.sql.SQLException
java.io.IOException
java.sql.SQLException
void loadXMLSchema(XMLInputStream xis) throws java.io.IOException, java.sql.SQLException
java.io.IOException
java.sql.SQLException
java.lang.String getXMLSchemaLocation()
The default value is: getDefaultNamespace()+"/" + getRowSetName()+".xsd"
void setXMLSchemaLocation(java.lang.String location)