SqlServerConnection

classin packageklyn.databases.sql.sqlserver

public class SqlServerConnection implements Connection:

SqlServerConnection

All Implemented Interfaces: Connection

Microsoft SQL Server connection implementation.

Uses TDS (Tabular Data Stream) protocol for all communication.

import klyn.databases.sql.sqlserver

# cnx = SqlServerConnection.open("sqlserver://localhost:1433/app?user=sa&password=Secret123")
# print(cnx.connected)

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	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 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	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	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 SqlServerConnection throws SQLException:`	Opens a SQL Server 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