Database

class Database @JvmOverloads constructor(    metadata: DatabaseMetaData,     val defaultCatalog: String? = null,     val defaultSchema: String? = null)

Provides a wrapper around DatabaseMetaData.

Constructors

Link copied to clipboard
fun Database(    metadata: DatabaseMetaData,     defaultCatalog: String? = null,     defaultSchema: String? = null)

Create empty Database

Functions

Link copied to clipboard
fun allProceduresAreCallable(): Boolean

All procedures are callable

Link copied to clipboard
fun allTablesAreSelectable(): Boolean

All tables are selectable

Link copied to clipboard
fun autoCommitFailureClosesAllResultSets(): Boolean

Auto commit failure closes all result sets

Link copied to clipboard
fun dataDefinitionCausesTransactionCommit(): Boolean

Data definition causes transaction commit

Link copied to clipboard
fun dataDefinitionIgnoredInTransactions(): Boolean

Data definition ignored in transactions

Link copied to clipboard
fun deletesAreDetected(resultSetType: ResultSetType): Boolean

Deletes are detected

Link copied to clipboard
fun doesMaxRowSizeIncludeBlobs(): Boolean

Does max row size include blobs

Link copied to clipboard
fun generatedKeyAlwaysReturned(): Boolean

Generated key always returned

Link copied to clipboard
fun getCatalogs(): List<String>

Get list of catalogs

Link copied to clipboard
fun getCatalogSeparator(): String

Get catalog separator

Link copied to clipboard
fun getCatalogTerm(): String

Get catalog term

Link copied to clipboard
fun getClientInfoProperties(): List<ClientInfoProperties>

Get client info properties, converted to ClientInfoProperties

Link copied to clipboard
fun getConnection(): Connection

Get connection

Link copied to clipboard
fun getCrossReference(    parentCatalog: String? = defaultCatalog,     parentSchema: String? = defaultSchema,     parentTable: String,     foreignCatalog: String? = defaultCatalog,     foreignSchema: String? = defaultSchema,     foreignTable: String): List<Key>

Get cross reference, converted to Key

Link copied to clipboard
fun getDatabaseMajorVersion(): Int

Get database major version

Link copied to clipboard
fun getDatabaseMinorVersion(): Int

Get database minor version

Link copied to clipboard
fun getDatabaseProductName(): String

Get database product name

Link copied to clipboard
fun getDatabaseProductVersion(): String

Get database product version

Link copied to clipboard
fun getDefaultTransactionIsolation(): TransactionIsolation

Get default transaction isolation, converted to TransactionIsolation

Link copied to clipboard
fun getDriverMajorVersion(): Int

Get driver major version

Link copied to clipboard
fun getDriverMinorVersion(): Int

Get driver minor version

Link copied to clipboard
fun getDriverName(): String

Get driver name

Link copied to clipboard
fun getDriverVersion(): String

Get driver version

Link copied to clipboard
fun getExtraNameCharacters(): String

Get extra name characters

Link copied to clipboard
fun getFunctions(schema: Schema, namePattern: String? = null): List<Function>

Get functions

fun getFunctions(    catalog: String? = defaultCatalog,     schemaPattern: String? = defaultSchema,     namePattern: String? = null): List<Function>

Gets functions using the catalog, schemaPattern, and namePattern to filter results. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema

Link copied to clipboard
fun getIdentifierQuoteString(): String

Get identifier quote string

Link copied to clipboard
fun getJDBCMajorVersion(): Int

Get JDBC major version

Link copied to clipboard
fun getJDBCMinorVersion(): Int

Get JDBC minor version

Link copied to clipboard
fun getMaxBinaryLiteralLength(): Int

Get max binary literal length

Link copied to clipboard
fun getMaxCatalogNameLength(): Int

Get max catalog name length

Link copied to clipboard
fun getMaxCharLiteralLength(): Int

Get max char literal length

Link copied to clipboard
fun getMaxColumnNameLength(): Int

Get max column name length

Link copied to clipboard
fun getMaxColumnsInGroupBy(): Int

Get max columns in group by

Link copied to clipboard
fun getMaxColumnsInIndex(): Int

Get max columns in index

Link copied to clipboard
fun getMaxColumnsInOrderBy(): Int

Get max columns in order by

Link copied to clipboard
fun getMaxColumnsInSelect(): Int

Get max columns in select

Link copied to clipboard
fun getMaxColumnsInTable(): Int

Get max columns in table

Link copied to clipboard
fun getMaxConnections(): Int

Get max connections

Link copied to clipboard
fun getMaxCursorNameLength(): Int

Get max cursor name length

Link copied to clipboard
fun getMaxIndexLength(): Int

Get max index length

Link copied to clipboard
fun getMaxLogicalLobSize(): Long

Get max logical lob size

Link copied to clipboard
fun getMaxProcedureNameLength(): Int

Get max procedure name length

Link copied to clipboard
fun getMaxRowSize(): Int

Get max row size

Link copied to clipboard
fun getMaxSchemaNameLength(): Int

Get max schema name length

Link copied to clipboard
fun getMaxStatementLength(): Int

Get max statement length

Link copied to clipboard
fun getMaxStatements(): Int

Get max statements

Link copied to clipboard
fun getMaxTableNameLength(): Int

Get max table name length

Link copied to clipboard
fun getMaxTablesInSelect(): Int

Get max tables in select

Link copied to clipboard
fun getMaxUserNameLength(): Int

Get max username length

Link copied to clipboard
fun getNumericFunctions(): List<String>

Get numeric function names

Link copied to clipboard
fun getProcedures(schema: Schema, namePattern: String? = null): List<Procedure>

Get procedures

fun getProcedures(    catalog: String? = defaultCatalog,     schemaPattern: String? = defaultSchema,     namePattern: String? = null): List<Procedure>

Get procedures. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema

Link copied to clipboard
fun getProcedureTerm(): String

Get procedure term

Link copied to clipboard
fun getResultSetHoldability(): ResultSetHoldability

Get result set holdability

Link copied to clipboard
fun getRowIdLifetime(): RowIdLifetime

Get row id lifetime

Link copied to clipboard
fun getSchemas(): List<Schema>

Get schemas

Link copied to clipboard
fun getSchemaTerm(): String

Get schema term

Link copied to clipboard
fun getSearchStringEscape(): String

Get search string escape

Link copied to clipboard
fun getSQLKeywords(): List<String>

Get SQL keywords

Link copied to clipboard
fun getSQLStateType(): SQLStateType

Get SQL state type

Link copied to clipboard
fun getStringFunctions(): List<String>

Get string function names

Link copied to clipboard
fun getSuperTables(schema: Schema, tableNamePattern: String? = null): List<Table>

Get super tables

fun getSuperTables(    catalog: String? = defaultCatalog,     schemaPattern: String? = defaultSchema,     tableNamePattern: String? = null): List<Table>

Get super tables. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema

Link copied to clipboard
fun getSuperTypes(schema: Schema, typeNamePattern: String? = null): List<SuperType>

Get super types

fun getSuperTypes(    catalog: String? = defaultCatalog,     schemaPattern: String? = defaultSchema,     typeNamePattern: String? = null): List<SuperType>

Get super types. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema

Link copied to clipboard
fun getSystemFunctions(): List<String>

Get system function names

Link copied to clipboard
fun getTables(    schema: Schema,     tableNamePattern: String? = null,     types: Array<String>? = null): List<Table>

Get tables

fun getTables(    catalog: String? = defaultCatalog,     schemaPattern: String? = defaultSchema,     tableNamePattern: String? = null,     types: Array<String>? = null): List<Table>

Get tables. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema

Link copied to clipboard
fun getTableTypes(): List<String>

Get table types

Link copied to clipboard
fun getTimeDateFunctions(): List<String>

Get time date function names

Link copied to clipboard
fun getTypeInfo(): List<TypeInfo>

Get type info

Link copied to clipboard
fun getURL(): String

Get URL for database connection

Link copied to clipboard
fun getUserDefinedTypes(    schema: Schema,     namePattern: String? = null,     types: Array<JDBCType>? = null): List<UserDefinedType>

Get user defined types

fun getUserDefinedTypes(    catalog: String? = defaultCatalog,     schemaPattern: String? = defaultSchema,     namePattern: String? = null,     types: Array<JDBCType>? = null): List<UserDefinedType>

Get user defined types. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema

Link copied to clipboard
fun getUserName(): String

Get username

Link copied to clipboard
fun insertsAreDetected(resultSetType: ResultSetType): Boolean

Inserts are detected

Link copied to clipboard
fun isCatalogAtStart(): Boolean

Is catalog at start

Link copied to clipboard
fun isReadOnly(): Boolean

Is read only

Link copied to clipboard
fun locatorsUpdateCopy(): Boolean

Locators update copy

Link copied to clipboard
fun nullPlusNonNullIsNull(): Boolean

Null plus non null is null

Link copied to clipboard
fun nullsAreSortedAtEnd(): Boolean

Nulls are sorted at end

Link copied to clipboard
fun nullsAreSortedAtStart(): Boolean

Nulls are sorted at start

Link copied to clipboard
fun nullsAreSortedHigh(): Boolean

Nulls are sorted high

Link copied to clipboard
fun nullsAreSortedLow(): Boolean

Nulls are sorted low

Link copied to clipboard
fun othersDeletesAreVisible(resultSetType: ResultSetType): Boolean

Others deletes are visible

Link copied to clipboard
fun othersInsertsAreVisible(resultSetType: ResultSetType): Boolean

Others inserts are visible

Link copied to clipboard
fun othersUpdatesAreVisible(resultSetType: ResultSetType): Boolean

Others updates are visible

Link copied to clipboard
fun ownDeletesAreVisible(resultSetType: ResultSetType): Boolean

Own deletes are visible

Link copied to clipboard
fun ownInsertsAreVisible(resultSetType: ResultSetType): Boolean

Own inserts are visible

Link copied to clipboard
fun ownUpdatesAreVisible(resultSetType: ResultSetType): Boolean

Own updates are visible

Link copied to clipboard
fun storesLowerCaseIdentifiers(): Boolean

Stores lower case identifiers

Link copied to clipboard
fun storesLowerCaseQuotedIdentifiers(): Boolean

Stores lower case quoted identifiers

Link copied to clipboard
fun storesMixedCaseIdentifiers(): Boolean

Stores mixed case identifiers

Link copied to clipboard
fun storesMixedCaseQuotedIdentifiers(): Boolean

Stores mixed case quoted identifiers

Link copied to clipboard
fun storesUpperCaseIdentifiers(): Boolean

Stores upper case identifiers

Link copied to clipboard
fun storesUpperCaseQuotedIdentifiers(): Boolean

Stores upper case quoted identifiers

Link copied to clipboard
fun supportsAlterTableWithAddColumn(): Boolean

Supports alter table with add column

Link copied to clipboard
fun supportsAlterTableWithDropColumn(): Boolean

Supports alter table with drop column

Link copied to clipboard
fun supportsANSI92EntryLevelSQL(): Boolean

Supports a n s i92entry level s q l

Link copied to clipboard
fun supportsANSI92FullSQL(): Boolean

Supports a n s i92full s q l

Link copied to clipboard
fun supportsANSI92IntermediateSQL(): Boolean

Supports a n s i92intermediate s q l

Link copied to clipboard
fun supportsBatchUpdates(): Boolean

Supports batch updates

Link copied to clipboard
fun supportsCatalogsInDataManipulation(): Boolean

Supports catalogs in data manipulation

Link copied to clipboard
fun supportsCatalogsInIndexDefinitions(): Boolean

Supports catalogs in index definitions

Link copied to clipboard
fun supportsCatalogsInPrivilegeDefinitions(): Boolean

Supports catalogs in privilege definitions

Link copied to clipboard
fun supportsCatalogsInProcedureCalls(): Boolean

Supports catalogs in procedure calls

Link copied to clipboard
fun supportsCatalogsInTableDefinitions(): Boolean

Supports catalogs in table definitions

Link copied to clipboard
fun supportsColumnAliasing(): Boolean

Supports column aliasing

Link copied to clipboard
fun supportsConvert(): Boolean
fun supportsConvert(fromType: JDBCType, toType: JDBCType): Boolean

Supports convert

Link copied to clipboard
fun supportsCoreSQLGrammar(): Boolean

Supports core s q l grammar

Link copied to clipboard
fun supportsCorrelatedSubqueries(): Boolean

Supports correlated subqueries

Supports data definition and data manipulation transactions

Link copied to clipboard
fun supportsDataManipulationTransactionsOnly(): Boolean

Supports data manipulation transactions only

Link copied to clipboard
fun supportsDifferentTableCorrelationNames(): Boolean

Supports different table correlation names

Link copied to clipboard
fun supportsExpressionsInOrderBy(): Boolean

Supports expressions in order by

Link copied to clipboard
fun supportsExtendedSQLGrammar(): Boolean

Supports extended s q l grammar

Link copied to clipboard
fun supportsFullOuterJoins(): Boolean

Supports full outer joins

Link copied to clipboard
fun supportsGetGeneratedKeys(): Boolean

Supports get generated keys

Link copied to clipboard
fun supportsGroupBy(): Boolean

Supports group by

Link copied to clipboard
fun supportsGroupByBeyondSelect(): Boolean

Supports group by beyond select

Link copied to clipboard
fun supportsGroupByUnrelated(): Boolean

Supports group by unrelated

Link copied to clipboard
fun supportsIntegrityEnhancementFacility(): Boolean

Supports integrity enhancement facility

Link copied to clipboard
fun supportsLikeEscapeClause(): Boolean

Supports like escape clause

Link copied to clipboard
fun supportsLimitedOuterJoins(): Boolean

Supports limited outer joins

Link copied to clipboard
fun supportsMinimumSQLGrammar(): Boolean

Supports minimum s q l grammar

Link copied to clipboard
fun supportsMixedCaseIdentifiers(): Boolean

Supports mixed case identifiers

Link copied to clipboard
fun supportsMixedCaseQuotedIdentifiers(): Boolean

Supports mixed case quoted identifiers

Link copied to clipboard
fun supportsMultipleOpenResults(): Boolean

Supports multiple open results

Link copied to clipboard
fun supportsMultipleResultSets(): Boolean

Supports multiple result sets

Link copied to clipboard
fun supportsMultipleTransactions(): Boolean

Supports multiple transactions

Link copied to clipboard
fun supportsNamedParameters(): Boolean

Supports named parameters

Link copied to clipboard
fun supportsNonNullableColumns(): Boolean

Supports non nullable columns

Link copied to clipboard
fun supportsOpenCursorsAcrossCommit(): Boolean

Supports open cursors across commit

Link copied to clipboard
fun supportsOpenCursorsAcrossRollback(): Boolean

Supports open cursors across rollback

Link copied to clipboard
fun supportsOpenStatementsAcrossCommit(): Boolean

Supports open statements across commit

Link copied to clipboard
fun supportsOpenStatementsAcrossRollback(): Boolean

Supports open statements across rollback

Link copied to clipboard
fun supportsOrderByUnrelated(): Boolean

Supports order by unrelated

Link copied to clipboard
fun supportsOuterJoins(): Boolean

Supports outer joins

Link copied to clipboard
fun supportsPositionedDelete(): Boolean

Supports positioned delete

Link copied to clipboard
fun supportsPositionedUpdate(): Boolean

Supports positioned update

Link copied to clipboard
fun supportsRefCursors(): Boolean

Supports ref cursors

Link copied to clipboard
fun supportsResultSetConcurrency(resultSetType: ResultSetType, resultSetConcurrency: ResultSetConcurrency): Boolean

Supports result set concurrency

Link copied to clipboard
fun supportsResultSetHoldability(resultSetHoldability: ResultSetHoldability): Boolean

Supports result set holdability

Link copied to clipboard
fun supportsResultSetType(resultSetType: ResultSetType): Boolean

Supports result set type

Link copied to clipboard
fun supportsSavepoints(): Boolean

Supports savepoints

Link copied to clipboard
fun supportsSchemasInDataManipulation(): Boolean

Supports schemas in data manipulation

Link copied to clipboard
fun supportsSchemasInIndexDefinitions(): Boolean

Supports schemas in index definitions

Link copied to clipboard
fun supportsSchemasInPrivilegeDefinitions(): Boolean

Supports schemas in privilege definitions

Link copied to clipboard
fun supportsSchemasInProcedureCalls(): Boolean

Supports schemas in procedure calls

Link copied to clipboard
fun supportsSchemasInTableDefinitions(): Boolean

Supports schemas in table definitions

Link copied to clipboard
fun supportsSelectForUpdate(): Boolean

Supports select for update

Link copied to clipboard
fun supportsSharding(): Boolean

Supports sharding

Link copied to clipboard
fun supportsStatementPooling(): Boolean

Supports statement pooling

Link copied to clipboard
fun supportsStoredFunctionsUsingCallSyntax(): Boolean

Supports stored functions using call syntax

Link copied to clipboard
fun supportsStoredProcedures(): Boolean

Supports stored procedures

Link copied to clipboard
fun supportsSubqueriesInComparisons(): Boolean

Supports subqueries in comparisons

Link copied to clipboard
fun supportsSubqueriesInExists(): Boolean

Supports subqueries in exists

Link copied to clipboard
fun supportsSubqueriesInIns(): Boolean

Supports subqueries in ins

Link copied to clipboard
fun supportsSubqueriesInQuantifieds(): Boolean

Supports subqueries in quantifieds

Link copied to clipboard
fun supportsTableCorrelationNames(): Boolean

Supports table correlation names

Link copied to clipboard
fun supportsTransactionIsolationLevel(transactionIsolation: TransactionIsolation): Boolean

Supports transaction isolation level

Link copied to clipboard
fun supportsTransactions(): Boolean

Supports transactions

Link copied to clipboard
fun supportsUnion(): Boolean

Supports union

Link copied to clipboard
fun supportsUnionAll(): Boolean

Supports union all

Link copied to clipboard
fun updatesAreDetected(resultSetType: ResultSetType): Boolean

Updates are detected

Link copied to clipboard
fun usesLocalFilePerTable(): Boolean

Uses local file per table

Link copied to clipboard
fun usesLocalFiles(): Boolean

Uses local files

Properties

Link copied to clipboard
val defaultCatalog: String? = null

a default catalog filter used in methods where a catalog can be specified

Link copied to clipboard
val defaultSchema: String? = null

a default schema filter used in methods where a schema can be specified