DatabaseMetaDataWrapper40public class DatabaseMetaDataWrapper40 extends com.sun.gjc.spi.base.DatabaseMetaDataWrapper Wrapper class for DatabaseMetaData for JDBC 4.0
|
| Constructors Summary |
|---|
public DatabaseMetaDataWrapper40(Connection con, DatabaseMetaData metaData)Creates a new instance of DatabaseMetaDataWrapper40 for JDBC 4.0
super(con, metaData);
|
| Methods Summary |
|---|
| public boolean | autoCommitFailureClosesAllResultSets()Retrieves whether a SQLException while autoCommit is true inidcates
that all open ResultSets are closed, even ones that are holdable. When a SQLException occurs while
autocommit is true, it is vendor specific whether the JDBC driver responds with a commit operation, a
rollback operation, or by doing neither a commit nor a rollback. A potential result of this difference
is in whether or not holdable ResultSets are closed.
return databaseMetaData.autoCommitFailureClosesAllResultSets();
| | public java.sql.ResultSet | getClientInfoProperties()Retrieves a list of the client info properties
that the driver supports. The result set contains the following columns
- NAME String=> The name of the client info property
- MAX_LEN int=> The maximum length of the value for the property
- DEFAULT_VALUE String=> The default value of the property
- DESCRIPTION String=> A description of the property. This will typically
contain information as to where this property is
stored in the database.
The ResultSet is sorted by the NAME column
return databaseMetaData.getClientInfoProperties();
| | public java.sql.ResultSet | getFunctionColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String columnNamePattern)Retrieves a description of the given catalog's system or user
function parameters and return type.
Only descriptions matching the schema, function and
parameter name criteria are returned. They are ordered by
FUNCTION_CAT, FUNCTION_SCHEM,
FUNCTION_NAME and
SPECIFIC_ NAME. Within this, the return value,
if any, is first. Next are the parameter descriptions in call
order. The column descriptions follow in column number order.
Each row in the ResultSet
is a parameter description, column description or
return type description with the following fields:
- FUNCTION_CAT String => function catalog (may be
null)
- FUNCTION_SCHEM String => function schema (may be
null)
- FUNCTION_NAME String => function name. This is the name
used to invoke the function
- COLUMN_NAME String => column/parameter name
- COLUMN_TYPE Short => kind of column/parameter:
- functionColumnUnknown - nobody knows
- functionColumnIn - IN parameter
- functionColumnInOut - INOUT parameter
- functionColumnOut - OUT parameter
- functionColumnReturn - function return value
- functionColumnResult - Indicates that the parameter or column
is a column in the
ResultSet
- DATA_TYPE int => SQL type from java.sql.Types
- TYPE_NAME String => SQL type name, for a UDT type the
type name is fully qualified
- PRECISION int => precision
- LENGTH int => length in bytes of data
- SCALE short => scale - null is returned for data types where
SCALE is not applicable.
- RADIX short => radix
- NULLABLE short => can it contain NULL.
- functionNoNulls - does not allow NULL values
- functionNullable - allows NULL values
- functionNullableUnknown - nullability unknown
- REMARKS String => comment describing column/parameter
- CHAR_OCTET_LENGTH int => the maximum length of binary
and character based parameters or columns. For any other datatype the returned value
is a NULL
- ORDINAL_POSITION int => the ordinal position, starting
from 1, for the input and output parameters. A value of 0
is returned if this row describes the function's return value.
For result set columns, it is the
ordinal position of the column in the result set starting from 1.
- IS_NULLABLE String => ISO rules are used to determine
the nullability for a parameter or column.
- YES --- if the parameter or column can include NULLs
- NO --- if the parameter or column cannot include NULLs
- empty string --- if the nullability for the
parameter or column is unknown
- SPECIFIC_NAME String => the name which uniquely identifies
this function within its schema. This is a user specified, or DBMS
generated, name that may be different then the
FUNCTION_NAME
for example with overload functions
The PRECISION column represents the specified column size for the given
parameter or column.
For numeric data, this is the maximum precision. For character data, this is the length in characters.
For datetime datatypes, this is the length in characters of the String representation (assuming the
maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype,
this is the length in bytes. Null is returned for data types where the
column size is not applicable.
return databaseMetaData.getFunctionColumns(catalog, schemaPattern, functionNamePattern, columnNamePattern);
| | public java.sql.ResultSet | getFunctions(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern)Retrieves a description of the system and user functions available
in the given catalog.
Only system and user function descriptions matching the schema and
function name criteria are returned. They are ordered by
FUNCTION_CAT, FUNCTION_SCHEM,
FUNCTION_NAME and
SPECIFIC_ NAME.
Each function description has the the following columns:
- FUNCTION_CAT String => function catalog (may be
null)
- FUNCTION_SCHEM String => function schema (may be
null)
- FUNCTION_NAME String => function name. This is the name
used to invoke the function
- REMARKS String => explanatory comment on the function
- FUNCTION_TYPE short => kind of function:
- functionResultUnknown - Cannot determine if a return value
or table will be returned
- functionNoTable- Does not return a table
- functionReturnsTable - Returns a table
- SPECIFIC_NAME String => the name which uniquely identifies
this function within its schema. This is a user specified, or DBMS
generated, name that may be different then the
FUNCTION_NAME
for example with overload functions
A user may not have permission to execute any of the functions that are
returned by getFunctions
return databaseMetaData.getFunctions(catalog, schemaPattern, functionNamePattern);
| | public java.sql.RowIdLifetime | getRowIdLifetime()Indicates whether or not this data source supports the SQL ROWID type,
and if so the lifetime for which a RowId object remains valid.
The returned int values have the following relationship:
ROWID_UNSUPPORTED < ROWID_VALID_OTHER < ROWID_VALID_TRANSACTION
< ROWID_VALID_SESSION < ROWID_VALID_FOREVER
so conditional logic such as
if (metadata.getRowIdLifetime() > DatabaseMetaData.ROWID_VALID_TRANSACTION)
can be used. Valid Forever means valid across all Sessions, and valid for
a Session means valid across all its contained Transactions.
return databaseMetaData.getRowIdLifetime();
| | public java.sql.ResultSet | getSchemas(java.lang.String catalog, java.lang.String schemaPattern)Retrieves the schema names available in this database. The results
are ordered by TABLE_CATALOG and
TABLE_SCHEM.
The schema columns are:
- TABLE_SCHEM String => schema name
- TABLE_CATALOG String => catalog name (may be
null)
return databaseMetaData.getSchemas(catalog, schemaPattern);
| | public boolean | isWrapperFor(java.lang.Class iface)Returns true if this either implements the interface argument or is directly or indirectly a wrapper
for an object that does. Returns false otherwise. If this implements the interface then return true,
else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped
object. If this does not implement the interface and is not a wrapper, return false.
This method should be implemented as a low-cost operation compared to unwrap so that
callers can use this method to avoid expensive unwrap calls that may fail. If this method
returns true then calling unwrap with the same argument should succeed.
boolean result ;
if (iface.isInstance(this)) {
result = true;
}else{
result = databaseMetaData.isWrapperFor(iface);
}
return result;
| | public boolean | supportsStoredFunctionsUsingCallSyntax()Retrieves whether this database supports invoking user-defined or vendor functions
using the stored procedure escape syntax.
return databaseMetaData.supportsStoredFunctionsUsingCallSyntax();
| | public T | unwrap(java.lang.Class iface)Returns an object that implements the given interface to allow access to
non-standard methods, or standard methods not exposed by the proxy.
If the receiver implements the interface then the result is the receiver
or a proxy for the receiver. If the receiver is a wrapper
and the wrapped object implements the interface then the result is the
wrapped object or a proxy for the wrapped object. Otherwise return the
the result of calling unwrap recursively on the wrapped object
or a proxy for that result. If the receiver is not a
wrapper and does not implement the interface, then an SQLException is thrown.
T result ;
if (iface.isInstance(this)) {
result = iface.cast(this);
} else {
result = databaseMetaData.unwrap(iface);
}
return result;
|
|
