OdbcDatabaseMetaData
class in package klyn.databases.sql.odbc

    public class OdbcDatabaseMetaData implements DatabaseMetaData:

OdbcDatabaseMetaData
All Implemented Interfaces: DatabaseMetaData

Database metadata exposed by an ODBC connection.

    import klyn.databases.sql

    # cnx = DriverManager.connect("odbc://app")
    # metadata = cnx.metadata
    # tables = metadata.tables(tablePattern="users")

Properties

Modifier and Type | Member | Description
--- | --- | ---
public readonly property | connection `connection as Connection:` | Owning connection.
public readonly property | driverName `driverName as String:` | ODBC driver name.
public readonly property | driverVersion `driverVersion as String:` | ODBC driver version.
public readonly property | productName `productName as String:` | Database product name reported by the ODBC driver.
public readonly property | productVersion `productVersion as String:` | Database product version reported by the ODBC driver.
public readonly property | readOnly `readOnly as Boolean:` | True when the connection is read-only.
public readonly property | supportsBatchUpdates `supportsBatchUpdates as Boolean:` | ODBC statement batches are executed sequentially by the Klyn driver.
public readonly property | supportsNamedParameters `supportsNamedParameters as Boolean:` | Named parameters are not part of the portable ODBC path.
public readonly property | supportsPreparedStatements `supportsPreparedStatements as Boolean:` | ODBC prepared statements are supported.
public readonly property | supportsSavepoints `supportsSavepoints as Boolean:` | Savepoints are sent as SQL statements to the database.
public readonly property | supportsStoredProcedures `supportsStoredProcedures as Boolean:` | Stored procedure calls are delegated to the ODBC driver.
public readonly property | supportsTransactions `supportsTransactions as Boolean:` | ODBC supports transaction operations when the target driver does.
public readonly property | url `url as String:` | Effective connection URL.
public readonly property | userName `userName as String:` | Effective user name.

Properties inherited from DatabaseMetaData: connection, driverName, driverVersion, productName, productVersion, readOnly, supportsBatchUpdates, supportsNamedParameters, supportsPreparedStatements, supportsSavepoints, supportsStoredProcedures, supportsTransactions, url, userName
Methods

Modifier and Type | Member | Description
--- | --- | ---
public | catalogs `catalogs() as ResultSet throws SQLException:` | Returns catalog metadata.
public | columns `columns(catalog as String = "", schemaPattern as String = "", tablePattern as String = "%", columnPattern as String = "%") as ResultSet throws SQLException:` | Returns column metadata.
public | exportedKeys `exportedKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException:` | Returns exported-key metadata.
public | functions `functions(catalog as String = "", schemaPattern as String = "", functionPattern as String = "%") as ResultSet throws SQLException:` | Returns function metadata when the ODBC driver exposes it.
public | importedKeys `importedKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException:` | Returns imported-key metadata.
public | primaryKeys `primaryKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException:` | Returns primary-key metadata.
public | procedures `procedures(catalog as String = "", schemaPattern as String = "", procedurePattern as String = "%") as ResultSet throws SQLException:` | Returns stored-procedure metadata.
public | schemas `schemas() as ResultSet throws SQLException:` | Returns schema metadata.
public | tableTypes `tableTypes() as ResultSet throws SQLException:` | Returns supported table types.
public | tables `tables(catalog as String = "", schemaPattern as String = "", tablePattern as String = "%", types as ArrayList<String> = null) as ResultSet throws SQLException:` | Returns table metadata.
public | typeInfo `typeInfo() as ResultSet throws SQLException:` | Returns supported SQL type metadata.

Methods inherited from DatabaseMetaData: catalogs, columns, exportedKeys, functions, importedKeys, primaryKeys, procedures, schemas, tableTypes, tables, typeInfo