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 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 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
Clears the warning associated with this connection.
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 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
No summary.
public isValid
isValid(timeoutSeconds as Int = 0) as Boolean
No summary.
public nativeConnection
nativeConnection() as Object
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 PostgreSQLConnection throws SQLException
Opens a PostgreSQL connection.
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