PostgreSQLConnection
classin packageklyn.databases.sql.postgresql
public class PostgreSQLConnection implements Connection:
PostgreSQLConnection
All Implemented Interfaces: Connection

PostgreSQL connection implementation.

Properties
Modifier and Type Member Description
public readonly property autoCommit
autoCommit as Boolean:
No summary.
public readonly 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 holdability
holdability as ResultSetHoldability:
No summary.
public readonly property networkTimeoutMillis
networkTimeoutMillis as Int:
No summary.
public readonly property readOnly
readOnly as Boolean:
No summary.
public readonly property schema
schema as String:
No summary.
public readonly property transactionIsolation
transactionIsolation as TransactionIsolation:
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 close
close() as Void throws SQLException:
Performs a database connection operation.
public commit
commit() as Void throws SQLException:
Performs a database connection operation.
public isConnected
isConnected() as Boolean:
No summary.
public nativeConnection
nativeConnection() as Object:
No summary.
public static open
open(url as String, properties as Map<String, String> = null, sslContext as SSLContext = null) as PostgreSQLConnection throws SQLException:
Opens a PostgreSQL connection.
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