MariaDbConnection
class in package klyn.databases.sql.mariadb

    public class MariaDbConnection implements Connection:

MariaDbConnection
All Implemented Interfaces: Connection

MariaDB SQL connection implementation.

The current driver focuses on establishing and maintaining MariaDB connections in pure Klyn. Query execution classes are being built incrementally on top of this transport layer.

    import klyn.databases.sql.mariadb

    # cnx = MariaDbConnection.open("mariadb://localhost:3306/app?user=app&password=secret")
    # print(cnx.isConnected())

Properties

Modifier and Type | Member | Description
--- | --- | ---
public property | autoCommit `autoCommit as Boolean:` | No summary.
public property | catalog `catalog as String:` | No summary.
public readonly property | clientInfo `clientInfo as Map<String, String>:` | No summary.
public readonly property | closed `closed as Boolean:` | No summary.
public readonly property | connected `connected as Boolean:` | No summary.
public property | holdability `holdability as ResultSetHoldability:` | No summary.
public readonly property | metadata `metadata as DatabaseMetaData:` | No summary.
public property | networkTimeoutMillis `networkTimeoutMillis as Int:` | No summary.
public property | readOnly `readOnly as Boolean:` | No summary.
public property | schema `schema as String:` | No summary.
public readonly property | serverVersion `serverVersion as String:` | No summary.
public readonly property | sslContext `sslContext as SSLContext:` | No summary.
public property | transactionIsolation `transactionIsolation as TransactionIsolation:` | No summary.
public readonly property | url `url as String:` | No summary.
public readonly property | userName `userName as String:` | No summary.
public readonly property | warning `warning as SQLWarning:` | No summary.

Properties inherited from Connection: autoCommit, catalog, clientInfo, closed, connected, holdability, metadata, networkTimeoutMillis, readOnly, schema, sslContext, transactionIsolation, url, userName, warning
Methods

Modifier and Type | Member | Description
--- | --- | ---
public | callable `callable(sql as String, resultSetType as ResultSetType = ResultSetType.FORWARD_ONLY, concurrency as ResultSetConcurrency = ResultSetConcurrency.READ_ONLY, holdability as ResultSetHoldability = ResultSetHoldability.CLOSE_CURSORS_AT_COMMIT) as CallableStatement throws SQLException:` | No summary.
public | clearWarnings `clearWarnings() as Void:` | No summary.
public override | close `close() as Void:` | No summary.
public | commit `commit() as Void throws SQLException:` | Performs a database connection operation.
public static | connect `connect(url as String, userName as String = "", password as String = "") as MariaDbConnection throws SQLException:` | No summary.
public | createStatement `createStatement(resultSetType as ResultSetType = ResultSetType.FORWARD_ONLY, concurrency as ResultSetConcurrency = ResultSetConcurrency.READ_ONLY, holdability as ResultSetHoldability = ResultSetHoldability.CLOSE_CURSORS_AT_COMMIT) as Statement throws SQLException:` | No summary.
public | isConnected `isConnected() as Boolean:` | Returns true when the connection has a live socket and is not closed.
public | isValid `isValid(timeoutSeconds as Int = 0) as Boolean:` | No summary.
public | nativeSql `nativeSql(sql as String) as String:` | No summary.
public static | open `open(url as String, properties as Map<String, String> = null, sslContext as SSLContext = null) as MariaDbConnection throws SQLException:` | Opens a MariaDB connection from a URL and optional properties.
public | prepareCall `prepareCall(sql as String, resultSetType as ResultSetType = ResultSetType.FORWARD_ONLY, concurrency as ResultSetConcurrency = ResultSetConcurrency.READ_ONLY, holdability as ResultSetHoldability = ResultSetHoldability.CLOSE_CURSORS_AT_COMMIT) as CallableStatement throws SQLException:` | No summary.
public | prepareStatement `prepareStatement(sql as String, resultSetType as ResultSetType = ResultSetType.FORWARD_ONLY, concurrency as ResultSetConcurrency = ResultSetConcurrency.READ_ONLY, holdability as ResultSetHoldability = ResultSetHoldability.CLOSE_CURSORS_AT_COMMIT) as PreparedStatement throws SQLException:` | No summary.
public | prepared `prepared(sql as String, resultSetType as ResultSetType = ResultSetType.FORWARD_ONLY, concurrency as ResultSetConcurrency = ResultSetConcurrency.READ_ONLY, holdability as ResultSetHoldability = ResultSetHoldability.CLOSE_CURSORS_AT_COMMIT) as PreparedStatement throws SQLException:` | No summary.
public | releaseSavepoint `releaseSavepoint(savepoint as Savepoint) as Void throws SQLException:` | Performs a database connection operation.
public | rollback `rollback(savepoint as Savepoint = null) as Void throws SQLException:` | Performs a database connection operation.
public | savepoint `savepoint(name as String = "") as Savepoint throws SQLException:` | Performs a database connection operation.
public | statement `statement(resultSetType as ResultSetType = ResultSetType.FORWARD_ONLY, concurrency as ResultSetConcurrency = ResultSetConcurrency.READ_ONLY, holdability as ResultSetHoldability = ResultSetHoldability.CLOSE_CURSORS_AT_COMMIT) as Statement throws SQLException:` | No summary.

Methods inherited from Connection: callable, clearWarnings, commit, createStatement, isValid, nativeSql, prepareCall, prepareStatement, prepared, releaseSavepoint, rollback, savepoint, statement
Methods inherited from AutoClosable: close