OctaviusSession

Specifies whether the session operates in auto-commit mode. If true, each individual statement is treated as a separate transaction.

Provides an API for performing PostgreSQL COPY operations.

Provides an API for managing PostgreSQL Large Objects.

The network timeout (in milliseconds) for operations executed on this session.

Handles asynchronous PostgreSQL notifications (LISTEN / NOTIFY mechanism).

Indicates whether this session is currently in read-only mode.

Provides a high-level API for executing operations within transaction scopes (e.g., required, nested). Automatically manages commits and rollbacks based on block execution outcomes.

The transaction isolation level for this session.

The current transaction state of this session (Idle, In Transaction, or Failed).

Manages PostgreSQL types and their OIDs, providing functionality for registration and resolution.

Manually aborts the connection, forcing the underlying connection pool (like HikariCP) to evict it instead of returning it to the pool.

Attempts to cancel the currently executing query on this session.

Ends the session, undoing the per-session state it left on its connection and giving that connection up - back to the pool it was borrowed from, or closed outright.

Commits the current transaction, persisting all changes made within it.

Creates a query with named parameters (e.g., @name, @id) which will be translated into positional parameters under the hood.

Creates a native query from the provided SQL string using standard PostgreSQL positional parameters (e.g. $1, $2).

Retrieves the current search_path configured for this session.

Checks if this session is still valid and the underlying connection is alive.

Releases the specified savepoint from the current transaction.

Reloads the database types and updates internal OID mappings.

Rolls back the current transaction, discarding all changes made within it.

Rolls back the transaction to the state at the time the given savepoint was created.

Creates an unnamed savepoint within the current transaction and returns it.

Creates a named savepoint within the current transaction and returns it.