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	Description
Mono<Void>	beginTransaction()
Mono<Void>	beginTransaction(TransactionDefinition definition)
Mono<Void>	cancelRequest()	Cancel currently running query by sending CancelRequest to a server.
Mono<Void>	close()
Mono<Void>	commitTransaction()
CopyInBuilder	copyIn(String sql)	Obtain a CopyInBuilder to configure a COPY FROM STDIN operation for very fast copying into a database table.
default Mono<Long>	copyIn(String sql, Publisher<io.netty.buffer.ByteBuf> stdin)	Use COPY FROM STDIN for very fast copying into a database table.
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 Details

beginTransaction

Mono<Void> beginTransaction()

Specified by:

beginTransaction in interface Connection

beginTransaction

Mono<Void> beginTransaction(TransactionDefinition definition)

Specified by:

beginTransaction in interface Connection

See Also:

• PostgresTransactionDefinition

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

copyIn

CopyInBuilder copyIn(String sql)

Obtain a CopyInBuilder to configure a COPY FROM STDIN operation for very fast copying into a database table.

Parameters:

sql - the COPY … FROM STDIN sql statement

Returns:

the builder to configure the copy operation.

Since:

1.0

copyIn

default Mono<Long> copyIn(String sql,
 Publisher<io.netty.buffer.ByteBuf> stdin)

Use COPY FROM STDIN for very fast copying into a database table.

Parameters:

sql - the COPY … FROM STDIN sql statement

stdin - the ByteBuf publisher

Returns:

a Mono with the amount of rows inserted

Since:

1.0

See Also:

• CopyInBuilder

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

cancelRequest

Mono<Void> cancelRequest()

Cancel currently running query by sending CancelRequest to a server.

Returns:

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

Since:

0.9

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.

Specified by:

setLockWaitTimeout in interface Connection

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.

Specified by:

setStatementTimeout in interface Connection

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