Interface PGStatement

  • All Known Subinterfaces:
    BaseStatement
    All Known Implementing Classes:
    PgStatement

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

      • getLastOID

        long getLastOID()
                 throws java.sql.SQLException
        Returns the Last inserted/updated oid.
        Returns:
        OID of last insert
        Throws:
        java.sql.SQLException - if something goes wrong
        Since:
        7.3
      • setUseServerPrepare

        @Deprecated
        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).
        Parameters:
        flag - use server prepare
        Throws:
        java.sql.SQLException - if something goes wrong
        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)