OdbcDatabaseMetaData

classin packageklyn.databases.sql.odbc

public class OdbcDatabaseMetaData implements DatabaseMetaData:

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