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.

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	indexes `indexes(catalog as String = "", schema as String = "", tableName as String = "", unique as Boolean = false) as ResultSet throws SQLException`	Returns portable ODBC index 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.