PostgreSQL JDBC Driver 42.7.2 · org.postgresql.PGStatement

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

Method Summary

Modifier and Type	Method and Description
public boolean	Returns: state of adaptive fetch (turned on or off) getAdaptiveFetch() Get state of adaptive fetch for statement.
public long	Returns: OID of last insert getLastOID() Returns the Last inserted/updated oid.
public int	Returns: the current threshold getPrepareThreshold() Gets the server-side prepare reuse threshold in use for this statement.
public boolean	Returns: true if the next reuse of this statement will use a server-prepared statement isUseServerPrepare() Checks if this statement will be executed as a server-prepared statement.
public void	setAdaptiveFetch(boolean desired state of adaptive fetch. adaptiveFetch) Turn on/off adaptive fetch for statement.
public void	setPrepareThreshold(int the new threshold for this statement threshold) Sets the reuse threshold for using server-prepared statements.
public void	setUseServerPrepare(boolean use server prepare flag) 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)`.

DATE_NEGATIVE_INFINITY	back to summary
public static final long DATE_NEGATIVE_INFINITY

DATE_NEGATIVE_SMALLER_INFINITY	back to summary
public static final long DATE_NEGATIVE_SMALLER_INFINITY

DATE_POSITIVE_INFINITY	back to summary
public static final long DATE_POSITIVE_INFINITY

DATE_POSITIVE_SMALLER_INFINITY	back to summary
public static final long DATE_POSITIVE_SMALLER_INFINITY

Method Detail

getAdaptiveFetch	back to summary
public boolean getAdaptiveFetch() Get state of adaptive fetch for statement. Returns:boolean state of adaptive fetch (turned on or off)

getAdaptiveFetch

back to summary

public boolean getAdaptiveFetch()

Get state of adaptive fetch for statement.

Returns:boolean: state of adaptive fetch (turned on or off)

getLastOID	back to summary
public long getLastOID() throws SQLException Returns the Last inserted/updated oid. Returns:long OID of last insert Exceptions SQLException: if something goes wrong Since 7.3

getLastOID

back to summary

public long getLastOID() throws SQLException

Returns the Last inserted/updated oid.

Returns:long

OID of last insert

Exceptions

SQLException:: if something goes wrong

Since

7.3

getPrepareThreshold back to summary

getPrepareThreshold	back to summary
public int getPrepareThreshold() Gets the server-side prepare reuse threshold in use for this statement. Returns:int the current threshold Since build 302 See Also `setPrepareThreshold(int)`

public int getPrepareThreshold()

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

Returns:int: the current threshold
Since: build 302
See Also: setPrepareThreshold(int)

isUseServerPrepare back to summary

isUseServerPrepare	back to summary
public 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:boolean true if the next reuse of this statement will use a server-prepared statement

public 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:boolean: true if the next reuse of this statement will use a server-prepared statement

setAdaptiveFetch	back to summary
public void setAdaptiveFetch(boolean adaptiveFetch) Turn on/off adaptive fetch for statement. Existing resultSets won't be affected by change here. Parameters adaptiveFetch:boolean desired state of adaptive fetch.

setAdaptiveFetch

back to summary

public void setAdaptiveFetch(boolean adaptiveFetch)

Turn on/off adaptive fetch for statement. Existing resultSets won't be affected by change here.

Parameters

adaptiveFetch:boolean: desired state of adaptive fetch.

setPrepareThreshold back to summary

setPrepareThreshold	back to summary
public void setPrepareThreshold(int threshold) throws 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:int the new threshold for this statement Exceptions SQLException: if an exception occurs while changing the threshold Since build 302

public void setPrepareThreshold(int threshold) throws 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:int: the new threshold for this statement

Exceptions

SQLException:: if an exception occurs while changing the threshold

Since

build 302

setUseServerPrepare back to summary

setUseServerPrepare	back to summary
public void setUseServerPrepare(boolean flag) throws 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)`. Parameters flag:boolean use server prepare Annotations @Deprecated Exceptions SQLException: if something goes wrong Since 7.3

public void setUseServerPrepare(boolean flag) throws 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).

Parameters

flag:boolean: use server prepare

Annotations

@Deprecated

Exceptions

SQLException:: if something goes wrong

Since

7.3

public Interface PGStatement

Field Summary

Method Summary

Field Detail

Method Detail