org.postgresql

Interface PGStatement

public interface PGStatement

This interface defines the public PostgreSQL extensions to java.sql.Statement. All Statements constructed by the PostgreSQL driver implement PGStatement.

Field Summary

Fields

Modifier and Type	Field and Description
static long	DATE_NEGATIVE_INFINITY
static long	DATE_NEGATIVE_SMALLER_INFINITY
static long	DATE_POSITIVE_INFINITY
static long	DATE_POSITIVE_SMALLER_INFINITY

Method Summary

Methods

Modifier and Type	Method and Description
long	getLastOID() Returns the Last inserted/updated oid.
int	getPrepareThreshold() Gets the server-side prepare reuse threshold in use for this statement.
boolean	isUseServerPrepare() Checks if this statement will be executed as a server-prepared statement.
void	setPrepareThreshold(int threshold) Sets the reuse threshold for using server-prepared statements.
void	setUseServerPrepare(boolean flag) Deprecated. As of build 302, replaced by setPrepareThreshold(int)

Field Detail

DATE_POSITIVE_INFINITY

static final long DATE_POSITIVE_INFINITY

See Also:

Constant Field Values

DATE_NEGATIVE_INFINITY

static final long DATE_NEGATIVE_INFINITY

See Also:

Constant Field Values

DATE_POSITIVE_SMALLER_INFINITY

static final long DATE_POSITIVE_SMALLER_INFINITY

See Also:

Constant Field Values

DATE_NEGATIVE_SMALLER_INFINITY

static final long DATE_NEGATIVE_SMALLER_INFINITY

See Also:

Constant Field Values

Method Detail

getLastOID

long getLastOID()
                throws java.sql.SQLException

Returns the Last inserted/updated oid.

Returns:

OID of last insert

Throws:

java.sql.SQLException

Since:

7.3

setUseServerPrepare

void setUseServerPrepare(boolean flag)
                         throws java.sql.SQLException

Deprecated. As of build 302, replaced by setPrepareThreshold(int)

Turn on the use of prepared statements in the server (server side prepared statements are unrelated to jdbc PreparedStatements) As of build 302, this method is equivalent to setPrepareThreshold(1).

Throws:

java.sql.SQLException

Since:

7.3

isUseServerPrepare

boolean isUseServerPrepare()

Checks if this statement will be executed as a server-prepared statement. A return value of true indicates that the next execution of the statement will be done as a server-prepared statement, assuming the underlying protocol supports it.

Returns:

true if the next reuse of this statement will use a server-prepared statement

setPrepareThreshold

void setPrepareThreshold(int threshold)
                         throws java.sql.SQLException

Sets the reuse threshold for using server-prepared statements.

If threshold is a non-zero value N, the Nth and subsequent reuses of a PreparedStatement will use server-side prepare.

If threshold is zero, server-side prepare will not be used.

The reuse threshold is only used by PreparedStatement and CallableStatement objects; it is ignored for plain Statements.

Parameters:

threshold - the new threshold for this statement

Throws:

java.sql.SQLException - if an exception occurs while changing the threshold

Since:

build 302

getPrepareThreshold

int getPrepareThreshold()

Gets the server-side prepare reuse threshold in use for this statement.

Returns:

the current threshold

Since:

build 302

See Also:

setPrepareThreshold(int)