1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
|
/*-------------------------------------------------------------------------
*
* Copyright (c) 2003-2008, PostgreSQL Global Development Group
*
* IDENTIFICATION
* $PostgreSQL: pgjdbc/org/postgresql/PGStatement.java,v 1.15 2008/01/08 06:56:26 jurka Exp $
*
*-------------------------------------------------------------------------
*/
package org.postgresql;
import java.sql.*;
/**
* This interface defines the public PostgreSQL extensions to
* java.sql.Statement. All Statements constructed by the PostgreSQL
* driver implement PGStatement.
*/
public interface PGStatement
{
// We can't use Long.MAX_VALUE or Long.MIN_VALUE for java.sql.date
// because this would break the 'normalization contract' of the
// java.sql.Date API.
// The follow values are the nearest MAX/MIN values with hour,
// minute, second, millisecond set to 0 - this is used for
// -infinity / infinity representation in Java
public static final long DATE_POSITIVE_INFINITY = 9223372036825200000l;
public static final long DATE_NEGATIVE_INFINITY = -9223372036832400000l;
/**
* Returns the Last inserted/updated oid.
* @return OID of last insert
* @since 7.3
*/
public long getLastOID() throws SQLException;
/**
* 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
* <code>setPrepareThreshold(1)</code>.
*
* @deprecated As of build 302, replaced by {@link #setPrepareThreshold(int)}
* @since 7.3
*/
public void setUseServerPrepare(boolean flag) throws SQLException;
/**
* Checks if this statement will be executed as a server-prepared
* statement. A return value of <code>true</code> indicates that the next
* execution of the statement will be done as a server-prepared statement,
* assuming the underlying protocol supports it.
*
* @return true if the next reuse of this statement will use a
* server-prepared statement
*/
public boolean isUseServerPrepare();
/**
* Sets the reuse threshold for using server-prepared statements.
*<p>
* If <code>threshold</code> is a non-zero value N, the Nth and subsequent
* reuses of a PreparedStatement will use server-side prepare.
*<p>
* If <code>threshold</code> is zero, server-side prepare will not be used.
*<p>
* The reuse threshold is only used by PreparedStatement and
* CallableStatement objects; it is ignored for plain Statements.
*
* @since build 302
* @param threshold the new threshold for this statement
* @throws SQLException if an exception occurs while changing the threshold
*/
public void setPrepareThreshold(int threshold) throws SQLException;
/**
* Gets the server-side prepare reuse threshold in use for this statement.
*
* @since build 302
* @return the current threshold
* @see #setPrepareThreshold(int)
*/
public int getPrepareThreshold();
}
|
