PostgreSQLCallableStatement

classin packageklyn.databases.sql.postgresql

public class PostgreSQLCallableStatement extends PostgreSQLPreparedStatement implements CallableStatement:

PostgreSQLPreparedStatement

└ PostgreSQLCallableStatement

All Implemented Interfaces: CallableStatement

PostgreSQL callable statement.

Properties

Modifier and Type	Member	Description
public readonly property	outParameters `outParameters as Map<Int, Int>:`	No summary.
public readonly property	outValues `outValues as Map<Int, Object>:`	No summary.

Properties inherited from PostgreSQLPreparedStatement: parameterInfo, parameterMetadata, parameters, sql

Properties inherited from CallableStatement: outParameters, outValues

Properties inherited from PreparedStatement: parameterInfo, parameterMetadata, parameters, sql

Properties inherited from Statement: batchSize, closeOnCompletion, closed, concurrency, connection, cursorName, escapeProcessing, fetchDirection, fetchSize, generatedKeys, holdability, largeMaxRows, maxFieldSize, maxRows, poolable, queryTimeoutSeconds, resultSetType, warning

Constructors

Modifier and Type	Member	Description
public	PostgreSQLCallableStatement `PostgreSQLCallableStatement(connection as PostgreSQLConnection, sql as String):`	No summary.

Methods

Modifier and Type	Member	Description
public override	addBatch `addBatch(sql as String) as Void throws SQLException:`	Configures or executes a SQL statement.
public override	execute `execute() as Boolean throws SQLException:`	Configures or executes a SQL statement.
public override	execute `execute(sql as String) as Boolean throws SQLException:`	Configures or executes a SQL statement.
public override	executeQuery `executeQuery(sql as String) as ResultSet throws SQLException:`	Configures or executes a SQL statement.
public override	executeUpdate `executeUpdate(sql as String) as Int throws SQLException:`	Configures or executes a SQL statement.
public	getBoolean `getBoolean(index as Int) as Boolean throws SQLException:`	Configures or executes a SQL statement.
public	getDouble `getDouble(index as Int) as Double throws SQLException:`	Configures or executes a SQL statement.
public	getInt `getInt(index as Int) as Int throws SQLException:`	Configures or executes a SQL statement.
public	getLong `getLong(index as Int) as Long throws SQLException:`	Configures or executes a SQL statement.
public	getObject `getObject(index as Int) as Object throws SQLException:`	Configures or executes a SQL statement.
public	getString `getString(index as Int) as String throws SQLException:`	Configures or executes a SQL statement.
public	out `out(index as Int, sqlType as Int, scale as Int = 0) as CallableStatement throws SQLException:`	Configures or executes a SQL statement.
public override	query `query() as ResultSet throws SQLException:`	Configures or executes a SQL statement.
public	registerOutParameter `registerOutParameter(index as Int, sqlType as Int, scale as Int = 0) as CallableStatement throws SQLException:`	Configures or executes a SQL statement.
public override	update `update() as Long throws SQLException:`	Configures or executes a SQL statement.
public	wasNull `wasNull() as Boolean throws SQLException:`	Configures or executes a SQL statement.

Methods inherited from PostgreSQLPreparedStatement: addBatch, addBatch, clearParameters, execute, execute, executeQuery, executeUpdate, query, set, setBoolean, setDouble, setInt, setLong, setNull, setString, update

Methods inherited from CallableStatement: getBoolean, getDouble, getInt, getLong, getObject, getString, out, registerOutParameter, wasNull

Methods inherited from PreparedStatement: clearParameters, execute, query, set, setBoolean, setDouble, setInt, setLong, setNull, setString, update

Methods inherited from Statement: addBatch, clearBatch, clearWarnings, execute, executeBatch, executeQuery, executeUpdate, getResultSet

Methods inherited from AutoClosable: close