8.6.85 getVersionColumns(String catalog, String schema, String table)
- Organization of this subsection
(1) Function
This method acquires information about the table columns that are updated automatically when rows in the table are modified.
(2) Format
public synchronized ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException
(3) Arguments
- String catalog
-
Specifies a catalog name. This argument is ignored, if specified.
- String schema
-
Specifies a schema name. This value is case sensitive.
- String table
-
Specifies a table name. This value is case sensitive.
(4) Return value
This method always returns a ResultSet object that contains no retrieval result rows. The following table shows the format of the ResultSet object that is returned.
|
Column No. |
Type |
Column name |
Description |
|---|---|---|---|
|
1 |
short |
SCOPE |
Not used |
|
2 |
String |
COLUMN_NAME |
Column name |
|
3 |
int |
DATA_TYPE |
SQL type |
|
4 |
String |
TYPE_NAME |
Type name |
|
5 |
int |
COLUMN_SIZE |
Precision |
|
6 |
int |
BUFFER_LENGTH |
Length of column value (in bytes) |
|
7 |
short |
DECIMAL_DIGITS |
Decimal places |
|
8 |
short |
PSEUDO_COLUMN |
Whether this is a pseudo column |
(5) Exceptions
If this Connection object is closed before this method is executed, the JDBC driver throws an SQLException.