MariaDbConnection

classin packageklyn.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. Each connection starts with the MariaDB session timezone set to the server's local timezone (SYSTEM).

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 SortedMap<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.

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.

Inherited Methods

methodInherited Methods from AutoClosable: close