io.r2dbc.postgresql.api

Interface PostgresqlConnection

All Superinterfaces:

Closeable, Connection

public interface PostgresqlConnection
extends Connection

A Connection for connecting to a PostgreSQL database.

Method Summary

Modifier and Type	Method and Description
Mono<Void>	beginTransaction()
Mono<Void>	close()
Mono<Void>	commitTransaction()
PostgresqlBatch	createBatch()
Mono<Void>	createSavepoint(String name)
PostgresqlStatement	createStatement(String sql)
PostgresqlConnectionMetadata	getMetadata()
Flux<Notification>	getNotifications() Return a Flux of Notification received from LISTEN registrations.
IsolationLevel	getTransactionIsolationLevel()
boolean	isAutoCommit()
Mono<Void>	releaseSavepoint(String name)
Mono<Void>	rollbackTransaction()
Mono<Void>	rollbackTransactionToSavepoint(String name)
Mono<Void>	setAutoCommit(boolean autoCommit)
Mono<Void>	setLockWaitTimeout(Duration lockTimeout) Sets Lock Acquisition Timeout through SET LOCK_TIMEOUT.
Mono<Void>	setStatementTimeout(Duration statementTimeout) Sets Statement Timeout through SET STATEMENT_TIMEOUT.
Mono<Void>	setTransactionIsolationLevel(IsolationLevel isolationLevel)
String	toString()
Mono<Boolean>	validate(ValidationDepth depth)

Method Detail

beginTransaction

Mono<Void> beginTransaction()

Specified by:

beginTransaction in interface Connection

close

Mono<Void> close()

Specified by:

close in interface Closeable

Specified by:

close in interface Connection

commitTransaction

Mono<Void> commitTransaction()

Specified by:

commitTransaction in interface Connection

createBatch

PostgresqlBatch createBatch()

Specified by:

createBatch in interface Connection

createSavepoint

Mono<Void> createSavepoint(String name)

Specified by:

createSavepoint in interface Connection

createStatement

PostgresqlStatement createStatement(String sql)

Specified by:

createStatement in interface Connection

getNotifications

Flux<Notification> getNotifications()

Return a Flux of Notification received from LISTEN registrations. The stream is a hot stream producing messages as they are received. Notifications received by this connection are published as they are received. When the client gets closed, the subscription completes normally. Otherwise (transport connection disconnected unintentionally) with an error.

Returns:

a hot Flux of Notifications

getMetadata

PostgresqlConnectionMetadata getMetadata()

Specified by:

getMetadata in interface Connection

getTransactionIsolationLevel

IsolationLevel getTransactionIsolationLevel()

Specified by:

getTransactionIsolationLevel in interface Connection

isAutoCommit

boolean isAutoCommit()

Specified by:

isAutoCommit in interface Connection

releaseSavepoint

Mono<Void> releaseSavepoint(String name)

Specified by:

releaseSavepoint in interface Connection

rollbackTransaction

Mono<Void> rollbackTransaction()

Specified by:

rollbackTransaction in interface Connection

rollbackTransactionToSavepoint

Mono<Void> rollbackTransactionToSavepoint(String name)

Specified by:

rollbackTransactionToSavepoint in interface Connection

setAutoCommit

Mono<Void> setAutoCommit(boolean autoCommit)

Specified by:

setAutoCommit in interface Connection

setLockWaitTimeout

Mono<Void> setLockWaitTimeout(Duration lockTimeout)

Sets Lock Acquisition Timeout through SET LOCK_TIMEOUT.

Returns:

a Mono that indicates that a lockTimeout frame was delivered to the backend

Since:

0.8.9

setStatementTimeout

Mono<Void> setStatementTimeout(Duration statementTimeout)

Sets Statement Timeout through SET STATEMENT_TIMEOUT.

Returns:

a Mono that indicates that a statementTimeout frame was delivered to the backend

Since:

0.8.9

setTransactionIsolationLevel

Mono<Void> setTransactionIsolationLevel(IsolationLevel isolationLevel)

Specified by:

setTransactionIsolationLevel in interface Connection

toString

String toString()

Overrides:

toString in class Object

validate

Mono<Boolean> validate(ValidationDepth depth)

Specified by:

validate in interface Connection