PgConnection (PostgreSQL JDBC Driver - JDBC 4.2 9.4.1212 API)

java.lang.Object
- org.postgresql.jdbc.PgConnection

All Implemented Interfaces:

AutoCloseable, Connection, Wrapper, BaseConnection, PGConnection
```
public class PgConnection
extends Object
implements BaseConnection
```

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

class PgConnection.AbortCommand

Nested Classes
Modifier and Type	Class and Description
`class`	`PgConnection.AbortCommand`

Field Summary

Fields
Modifier and Type	Field and Description
`protected int`	`defaultFetchSize` Default fetch size for statement
`protected boolean`	`forcebinary`
`protected DatabaseMetaData`	`metadata`
`protected int`	`prepareThreshold`
`protected Map<String,Class<?>>`	`typemap` The current type mappings

Fields inherited from interface java.sql.Connection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

Constructors
Constructor and Description

PgConnection(HostSpec[] hostSpecs, String user, String database, Properties info, String url)

Constructors
Constructor and Description
`PgConnection(HostSpec[] hostSpecs, String user, String database, Properties info, String url)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`protected void`	`abort()`
`void`	`abort(Executor executor)`
`void`	`addDataType(String type, Class<? extends PGobject> klass)` This allows client code to add a handler for one of org.postgresql's more unique data types.
`void`	`addDataType(String type, String name)` This allows client code to add a handler for one of org.postgresql's more unique data types.
`void`	`addTimerTask(TimerTask timerTask, long milliSeconds)` Schedule a TimerTask for later execution.
`void`	`addWarning(SQLWarning warn)` This adds a warning to the warning chain.
`boolean`	`binaryTransferSend(int oid)` Returns true if value for the given oid should be sent using binary transfer.
`void`	`cancelQuery()` Cancel the current query executing on this connection.
`protected void`	`checkClosed()`
`void`	`clearWarnings()`
`void`	`close()` Note: even though `Statement` is automatically closed when it is garbage collected, it is better to close it explicitly to lower resource consumption.
`void`	`commit()`
`Array`	`createArrayOf(String typeName, Object[] elements)`
`Blob`	`createBlob()`
`Clob`	`createClob()`
`NClob`	`createNClob()`
`CachedQuery`	`createQuery(String sql, boolean escapeProcessing, boolean isParameterized, String... columnNames)`
`<T> T`	`createQueryObject(Class<T> ifc)`
`SQLXML`	`createSQLXML()`
`Statement`	`createStatement()`
`Statement`	`createStatement(int resultSetType, int resultSetConcurrency)`
`Statement`	`createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)`
`Struct`	`createStruct(String typeName, Object[] attributes)`
`protected TypeInfo`	`createTypeInfo(BaseConnection conn, int unknownLength)`
`byte[]`	`encodeString(String str)` Encode a string using the database's client_encoding (usually UTF8, but can vary on older server versions).
`String`	`escapeIdentifier(String identifier)` Return the given string suitably quoted to be used as an identifier in an SQL statement string.
`String`	`escapeLiteral(String literal)` Return the given string suitably quoted to be used as a string literal in an SQL statement string.
`String`	`escapeString(String str)` Escapes a string for use as string-literal within an SQL command.
`ResultSet`	`execSQLQuery(String s)` Execute a SQL query that returns a single resultset.
`ResultSet`	`execSQLQuery(String s, int resultSetType, int resultSetConcurrency)`
`void`	`execSQLUpdate(String s)` Execute a SQL query that does not return results.
`protected void`	`finalize()` Overrides finalize().
`boolean`	`getAutoCommit()`
`AutoSave`	`getAutosave()` Connection configuration regarding automatic per-query savepoints.
`int`	`getBackendPID()` Return the process ID (PID) of the backend server process handling this connection.
`String`	`getCatalog()`
`Properties`	`getClientInfo()`
`String`	`getClientInfo(String name)`
`CopyManager`	`getCopyAPI()` This returns the COPY API for the current connection.
`String`	`getCursorName()` getCursorName gets the cursor name.
`String`	`getDBVersionNumber()` Get server version number
`int`	`getDefaultFetchSize()` Get the default fetch size for statements created from this connection
`Encoding`	`getEncoding()`
`Fastpath`	`getFastpathAPI()` This returns the Fastpath API for the current connection.
`LruCache<FieldMetadata.Key,FieldMetadata>`	`getFieldMetadataCache()` Return metadata cache for given connection
`boolean`	`getForceBinary()`
`int`	`getHoldability()`
`protected String`	`getIsolationLevelName(int level)`
`LargeObjectManager`	`getLargeObjectAPI()` This returns the LargeObject API for the current connection.
`Logger`	`getLogger()`
`DatabaseMetaData`	`getMetaData()`
`int`	`getNetworkTimeout()`
`PGNotification[]`	`getNotifications()` This method returns any notifications that have been received since the last call to this method.
`Object`	`getObject(String type, String value, byte[] byteValue)` Construct and return an appropriate object for the given type and value.
`PreferQueryMode`	`getPreferQueryMode()` Returns true if the connection is configured to use "simple 'Q' execute" commands only When running in simple protocol only, certain features are not available: callable statements, partial result set fetch, bytea type, etc.
`int`	`getPrepareThreshold()` Get the default server-side prepare reuse threshold for statements created from this connection.
`int`	`getProtocolVersion()`
`QueryExecutor`	`getQueryExecutor()` Get the QueryExecutor implementation for this connection.
`String`	`getSchema()`
`int`	`getServerMajorVersion()` Get server major version
`int`	`getServerMinorVersion()` Get server minor version
`boolean`	`getStandardConformingStrings()` Returns whether the server treats string-literals according to the SQL standard or if it uses traditional PostgreSQL escaping rules.
`boolean`	`getStringVarcharFlag()`
`TimestampUtils`	`getTimestampUtils()`
`int`	`getTransactionIsolation()`
`TransactionState`	`getTransactionState()` Get the current transaction state of this connection.
`TypeInfo`	`getTypeInfo()`
`Map<String,Class<?>>`	`getTypeMap()`
`String`	`getURL()` We are required to bring back certain information by the DatabaseMetaData class.
`String`	`getUserName()` Method getUserName() brings back the User Name (again, we saved it)
`SQLWarning`	`getWarnings()`
`boolean`	`haveMinimumCompatibleVersion(int ver)` Check if we should use driver behaviour introduced in a particular driver version.
`boolean`	`haveMinimumCompatibleVersion(String ver)` Check if we should use driver behaviour introduced in a particular driver version.
`boolean`	`haveMinimumCompatibleVersion(Version ver)` Check if we should use driver behaviour introduced in a particular driver version.
`boolean`	`haveMinimumServerVersion(int ver)` Check if we have at least a particular server version.
`boolean`	`haveMinimumServerVersion(String ver)` Check if we have at least a particular server version.
`boolean`	`haveMinimumServerVersion(Version ver)` Check if we have at least a particular server version.
`boolean`	`isClosed()`
`boolean`	`isColumnSanitiserDisabled()` Return whether to disable column name sanitation.
`boolean`	`isReadOnly()`
`boolean`	`isValid(int timeout)`
`boolean`	`isWrapperFor(Class<?> iface)`
`protected Array`	`makeArray(int oid, String fieldString)`
`protected Blob`	`makeBlob(long oid)`
`protected Clob`	`makeClob(long oid)`
`protected SQLXML`	`makeSQLXML()`
`String`	`nativeSQL(String sql)`
`CallableStatement`	`prepareCall(String sql)`
`CallableStatement`	`prepareCall(String sql, int resultSetType, int resultSetConcurrency)`
`CallableStatement`	`prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)`
`PreparedStatement`	`prepareStatement(String sql)`
`PreparedStatement`	`prepareStatement(String sql, int autoGeneratedKeys)`
`PreparedStatement`	`prepareStatement(String sql, int[] columnIndexes)`
`PreparedStatement`	`prepareStatement(String sql, int resultSetType, int resultSetConcurrency)`
`PreparedStatement`	`prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)`
`PreparedStatement`	`prepareStatement(String sql, String[] columnNames)`
`void`	`purgeTimerTasks()` Invoke purge() on the underlying shared Timer so that internal resources will be released.
`void`	`releaseSavepoint(Savepoint savepoint)`
`void`	`rollback()`
`void`	`rollback(Savepoint savepoint)`
`void`	`setAutoCommit(boolean autoCommit)`
`void`	`setAutosave(AutoSave autoSave)` Configures if connection should use automatic savepoints.
`void`	`setCatalog(String catalog)`
`void`	`setClientInfo(Properties properties)`
`void`	`setClientInfo(String name, String value)`
`void`	`setCursorName(String cursor)` In SQL, a result table can be retrieved through a cursor that is named.
`void`	`setDefaultFetchSize(int fetchSize)` Set the default fetch size for statements created from this connection
`void`	`setDisableColumnSanitiser(boolean disableColumnSanitiser)`
`void`	`setFlushCacheOnDeallocate(boolean flushCacheOnDeallocate)` By default, the connection resets statement cache in case deallocate all/discard all message is observed.
`void`	`setForceBinary(boolean newValue)`
`void`	`setHoldability(int holdability)`
`void`	`setNetworkTimeout(Executor executor, int milliseconds)`
`void`	`setPrepareThreshold(int newThreshold)` Set the default statement reuse threshold before enabling server-side prepare.
`void`	`setReadOnly(boolean readOnly)`
`Savepoint`	`setSavepoint()`
`Savepoint`	`setSavepoint(String name)`
`void`	`setSchema(String schema)`
`void`	`setTransactionIsolation(int level)`
`void`	`setTypeMap(Map<String,Class<?>> map)`
`void`	`setTypeMapImpl(Map<String,Class<?>> map)`
`<T> T`	`unwrap(Class<T> iface)`

Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - prepareThreshold
```
protected int prepareThreshold
```
  - defaultFetchSize
```
protected int defaultFetchSize
```
    Default fetch size for statement
    
    See Also:
    
    PGProperty.DEFAULT_ROW_FETCH_SIZE
  - forcebinary
```
protected boolean forcebinary
```
  - typemap
```
protected Map<String,Class<?>> typemap
```
    The current type mappings
  - metadata
```
protected DatabaseMetaData metadata
```
- Constructor Detail
  - PgConnection
```
public PgConnection(HostSpec[] hostSpecs,
                    String user,
                    String database,
                    Properties info,
                    String url)
             throws SQLException
```
    Throws:
    
    SQLException
- Method Detail
  - createQuery
```
public CachedQuery createQuery(String sql,
                               boolean escapeProcessing,
                               boolean isParameterized,
                               String... columnNames)
                        throws SQLException
```
    Specified by:
    
    createQuery in interface BaseConnection
    
    Throws:
    
    SQLException
  - setFlushCacheOnDeallocate
```
public void setFlushCacheOnDeallocate(boolean flushCacheOnDeallocate)
```
    Description copied from interface: BaseConnection
    
    By default, the connection resets statement cache in case deallocate all/discard all message is observed. This API allows to disable that feature for testing purposes.
    
    Specified by:
    
    setFlushCacheOnDeallocate in interface BaseConnection
    
    Parameters:
    
    flushCacheOnDeallocate - true if statement cache should be reset when "deallocate/discard" message observed
  - getTimestampUtils
```
public TimestampUtils getTimestampUtils()
```
    Specified by:
    
    getTimestampUtils in interface BaseConnection
  - createStatement
```
public Statement createStatement()
                          throws SQLException
```
    Specified by:
    
    createStatement in interface Connection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Throws:
    
    SQLException
  - prepareCall
```
public CallableStatement prepareCall(String sql)
                              throws SQLException
```
    Specified by:
    
    prepareCall in interface Connection
    
    Throws:
    
    SQLException
  - getTypeMap
```
public Map<String,Class<?>> getTypeMap()
                                throws SQLException
```
    Specified by:
    
    getTypeMap in interface Connection
    
    Throws:
    
    SQLException
  - getQueryExecutor
```
public QueryExecutor getQueryExecutor()
```
    Description copied from interface: BaseConnection
    
    Get the QueryExecutor implementation for this connection.
    
    Specified by:
    
    getQueryExecutor in interface BaseConnection
    
    Returns:
    
    the (non-null) executor
  - addWarning
```
public void addWarning(SQLWarning warn)
```
    This adds a warning to the warning chain.
    
    Parameters:
    
    warn - warning to add
  - execSQLQuery
```
public ResultSet execSQLQuery(String s)
                       throws SQLException
```
    Description copied from interface: BaseConnection
    
    Execute a SQL query that returns a single resultset. Never causes a new transaction to be started regardless of the autocommit setting.
    
    Specified by:
    
    execSQLQuery in interface BaseConnection
    
    Parameters:
    
    s - the query to execute
    
    Returns:
    
    the (non-null) returned resultset
    
    Throws:
    
    SQLException - if something goes wrong.
  - execSQLQuery
```
public ResultSet execSQLQuery(String s,
                              int resultSetType,
                              int resultSetConcurrency)
                       throws SQLException
```
    Specified by:
    
    execSQLQuery in interface BaseConnection
    
    Throws:
    
    SQLException
  - execSQLUpdate
```
public void execSQLUpdate(String s)
                   throws SQLException
```
    Description copied from interface: BaseConnection
    
    Execute a SQL query that does not return results. Never causes a new transaction to be started regardless of the autocommit setting.
    
    Specified by:
    
    execSQLUpdate in interface BaseConnection
    
    Parameters:
    
    s - the query to execute
    
    Throws:
    
    SQLException - if something goes wrong.
  - setCursorName
```
public void setCursorName(String cursor)
                   throws SQLException
```
    In SQL, a result table can be retrieved through a cursor that is named. The current row of a result can be updated or deleted using a positioned update/delete statement that references the cursor name.
    We do not support positioned update/delete, so this is a no-op.
    
    Parameters:
    
    cursor - the cursor name
    
    Throws:
    
    SQLException - if a database access error occurs
  - getCursorName
```
public String getCursorName()
                     throws SQLException
```
    getCursorName gets the cursor name.
    
    Returns:
    
    the current cursor name
    
    Throws:
    
    SQLException - if a database access error occurs
  - getURL
```
public String getURL()
              throws SQLException
```
    We are required to bring back certain information by the DatabaseMetaData class. These functions do that.
    Method getURL() brings back the URL (good job we saved it)
    
    Returns:
    
    the url
    
    Throws:
    
    SQLException - just in case...
  - getUserName
```
public String getUserName()
                   throws SQLException
```
    Method getUserName() brings back the User Name (again, we saved it)
    
    Returns:
    
    the user name
    
    Throws:
    
    SQLException - just in case...
  - getFastpathAPI
```
public Fastpath getFastpathAPI()
                        throws SQLException
```
    Description copied from interface: PGConnection
    
    This returns the Fastpath API for the current connection.
    
    Specified by:
    
    getFastpathAPI in interface PGConnection
    
    Returns:
    
    Fastpath API for the current connection
    
    Throws:
    
    SQLException - if something wrong happens
  - getLargeObjectAPI
```
public LargeObjectManager getLargeObjectAPI()
                                     throws SQLException
```
    Description copied from interface: PGConnection
    
    This returns the LargeObject API for the current connection.
    
    Specified by:
    
    getLargeObjectAPI in interface PGConnection
    
    Returns:
    
    LargeObject API for the current connection
    
    Throws:
    
    SQLException - if something wrong happens
  - getObject
```
public Object getObject(String type,
                        String value,
                        byte[] byteValue)
                 throws SQLException
```
    Description copied from interface: BaseConnection
    
    Construct and return an appropriate object for the given type and value. This only considers the types registered via PGConnection.addDataType(String, Class) and PGConnection.addDataType(String, String).
    If no class is registered as handling the given type, then a generic PGobject instance is returned.
    
    Specified by:
    
    getObject in interface BaseConnection
    
    Parameters:
    
    type - the backend typename
    
    value - the type-specific string representation of the value
    
    byteValue - the type-specific binary representation of the value
    
    Returns:
    
    an appropriate object; never null.
    
    Throws:
    
    SQLException - if something goes wrong
  - createTypeInfo
```
protected TypeInfo createTypeInfo(BaseConnection conn,
                                  int unknownLength)
```
  - getTypeInfo
```
public TypeInfo getTypeInfo()
```
    Specified by:
    
    getTypeInfo in interface BaseConnection
  - addDataType
```
public void addDataType(String type,
                        String name)
```
    Description copied from interface: PGConnection
    
    This allows client code to add a handler for one of org.postgresql's more unique data types. It is approximately equivalent to addDataType(type, Class.forName(name)).
    
    Specified by:
    
    addDataType in interface PGConnection
    
    Parameters:
    
    type - JDBC type name
    
    name - class name
  - addDataType
```
public void addDataType(String type,
                        Class<? extends PGobject> klass)
                 throws SQLException
```
    Description copied from interface: PGConnection
    This allows client code to add a handler for one of org.postgresql's more unique data types.
    NOTE: This is not part of JDBC, but an extension.
    The best way to use this is as follows:
```
 ...
 ((org.postgresql.PGConnection)myconn).addDataType("mytype", my.class.name.class);
 ...
 
```
    where myconn is an open Connection to org.postgresql.
    The handling class must extend org.postgresql.util.PGobject
    Specified by:
    
    addDataType in interface PGConnection
    
    Parameters:
    
    type - the PostgreSQL type to register
    
    klass - the class implementing the Java representation of the type; this class must implement PGobject).
    
    Throws:
    
    SQLException - if klass does not implement PGobject).
    
    See Also:
    
    PGobject
  - close
```
public void close()
           throws SQLException
```
    Note: even though Statement is automatically closed when it is garbage collected, it is better to close it explicitly to lower resource consumption.
    
    Specified by:
    
    close in interface AutoCloseable
    
    Specified by:
    
    close in interface Connection
    
    Throws:
    
    SQLException
  - nativeSQL
```
public String nativeSQL(String sql)
                 throws SQLException
```
    Specified by:
    
    nativeSQL in interface Connection
    
    Throws:
    
    SQLException
  - getWarnings
```
public SQLWarning getWarnings()
                       throws SQLException
```
    Specified by:
    
    getWarnings in interface Connection
    
    Throws:
    
    SQLException
  - clearWarnings
```
public void clearWarnings()
                   throws SQLException
```
    Specified by:
    
    clearWarnings in interface Connection
    
    Throws:
    
    SQLException
  - setReadOnly
```
public void setReadOnly(boolean readOnly)
                 throws SQLException
```
    Specified by:
    
    setReadOnly in interface Connection
    
    Throws:
    
    SQLException
  - isReadOnly
```
public boolean isReadOnly()
                   throws SQLException
```
    Specified by:
    
    isReadOnly in interface Connection
    
    Throws:
    
    SQLException
  - setAutoCommit
```
public void setAutoCommit(boolean autoCommit)
                   throws SQLException
```
    Specified by:
    
    setAutoCommit in interface Connection
    
    Throws:
    
    SQLException
  - getAutoCommit
```
public boolean getAutoCommit()
                      throws SQLException
```
    Specified by:
    
    getAutoCommit in interface Connection
    
    Throws:
    
    SQLException
  - commit
```
public void commit()
            throws SQLException
```
    Specified by:
    
    commit in interface Connection
    
    Throws:
    
    SQLException
  - checkClosed
```
protected void checkClosed()
                    throws SQLException
```
    Throws:
    
    SQLException
  - rollback
```
public void rollback()
              throws SQLException
```
    Specified by:
    
    rollback in interface Connection
    
    Throws:
    
    SQLException
  - getTransactionState
```
public TransactionState getTransactionState()
```
    Description copied from interface: BaseConnection
    
    Get the current transaction state of this connection.
    
    Specified by:
    
    getTransactionState in interface BaseConnection
    
    Returns:
    
    current transaction state of this connection
  - getTransactionIsolation
```
public int getTransactionIsolation()
                            throws SQLException
```
    Specified by:
    
    getTransactionIsolation in interface Connection
    
    Throws:
    
    SQLException
  - setTransactionIsolation
```
public void setTransactionIsolation(int level)
                             throws SQLException
```
    Specified by:
    
    setTransactionIsolation in interface Connection
    
    Throws:
    
    SQLException
  - getIsolationLevelName
```
protected String getIsolationLevelName(int level)
```
  - setCatalog
```
public void setCatalog(String catalog)
                throws SQLException
```
    Specified by:
    
    setCatalog in interface Connection
    
    Throws:
    
    SQLException
  - getCatalog
```
public String getCatalog()
                  throws SQLException
```
    Specified by:
    
    getCatalog in interface Connection
    
    Throws:
    
    SQLException
  - finalize
```
protected void finalize()
                 throws Throwable
```
    Overrides finalize(). If called, it closes the connection.
    This was done at the request of Rachel Greenham who hit a problem where multiple clients didn't close the connection, and once a fortnight enough clients were open to kill the postgres server.
    
    Overrides:
    
    finalize in class Object
    
    Throws:
    
    Throwable
  - getDBVersionNumber
```
public String getDBVersionNumber()
```
    Get server version number
    
    Returns:
    
    server version number
  - getServerMajorVersion
```
public int getServerMajorVersion()
```
    Get server major version
    
    Returns:
    
    server major version
  - getServerMinorVersion
```
public int getServerMinorVersion()
```
    Get server minor version
    
    Returns:
    
    server minor version
  - haveMinimumServerVersion
```
public boolean haveMinimumServerVersion(String ver)
```
    Description copied from interface: BaseConnection
    
    Check if we have at least a particular server version.
    
    Specified by:
    
    haveMinimumServerVersion in interface BaseConnection
    
    Parameters:
    
    ver - the server version to check
    
    Returns:
    
    true if the server version is at least "ver".
  - haveMinimumServerVersion
```
public boolean haveMinimumServerVersion(int ver)
```
    Description copied from interface: BaseConnection
    
    Check if we have at least a particular server version. The input version is of the form xxyyzz, matching a PostgreSQL version like xx.yy.zz. So 9.0.12 is 90012 .
    
    Specified by:
    
    haveMinimumServerVersion in interface BaseConnection
    
    Parameters:
    
    ver - the server version to check, of the form xxyyzz eg 90401
    
    Returns:
    
    true if the server version is at least "ver".
  - haveMinimumServerVersion
```
public boolean haveMinimumServerVersion(Version ver)
```
    Description copied from interface: BaseConnection
    
    Check if we have at least a particular server version. The input version is of the form xxyyzz, matching a PostgreSQL version like xx.yy.zz. So 9.0.12 is 90012 .
    
    Specified by:
    
    haveMinimumServerVersion in interface BaseConnection
    
    Parameters:
    
    ver - the server version to check
    
    Returns:
    
    true if the server version is at least "ver".
  - haveMinimumCompatibleVersion
```
public boolean haveMinimumCompatibleVersion(int ver)
```
    Description copied from interface: BaseConnection
    
    Check if we should use driver behaviour introduced in a particular driver version. This defaults to behaving as the actual driver's version but can be overridden by the "compatible" URL parameter. The version is of the form xxyyzz, e.g. 90401 for PgJDBC 9.4.1. This is used to toggle between different functionality as it changes across different releases of the jdbc driver code. The values here are versions of the jdbc client and not server versions. For example in 7.1 get/setBytes worked on LargeObject values, in 7.2 these methods were changed to work on bytea values. This change in functionality could be disabled by setting the "compatible" level to be 7.1, in which case the driver will revert to the 7.1 functionality.
    
    Specified by:
    
    haveMinimumCompatibleVersion in interface BaseConnection
    
    Parameters:
    
    ver - the driver version to check, eg 90401 for 9.4.1
    
    Returns:
    
    true if the driver's behavioural version is at least "ver".
  - haveMinimumCompatibleVersion
```
public boolean haveMinimumCompatibleVersion(String ver)
```
    Description copied from interface: BaseConnection
    
    Check if we should use driver behaviour introduced in a particular driver version. This defaults to behaving as the actual driver's version but can be overridden by the "compatible" URL parameter. If possible you should use the integer version of this method instead. It was introduced with the 9.4 driver release.
    
    Specified by:
    
    haveMinimumCompatibleVersion in interface BaseConnection
    
    Parameters:
    
    ver - the driver version to check
    
    Returns:
    
    true if the driver's behavioural version is at least "ver".
  - haveMinimumCompatibleVersion
```
public boolean haveMinimumCompatibleVersion(Version ver)
```
    Description copied from interface: BaseConnection
    
    Check if we should use driver behaviour introduced in a particular driver version. This defaults to behaving as the actual driver's version but can be overridden by the "compatible" URL parameter.
    
    Specified by:
    
    haveMinimumCompatibleVersion in interface BaseConnection
    
    Parameters:
    
    ver - the driver version to check
    
    Returns:
    
    true if the driver's behavioural version is at least "ver".
  - getEncoding
```
public Encoding getEncoding()
```
    Specified by:
    
    getEncoding in interface BaseConnection
  - encodeString
```
public byte[] encodeString(String str)
                    throws SQLException
```
    Description copied from interface: BaseConnection
    
    Encode a string using the database's client_encoding (usually UTF8, but can vary on older server versions). This is used when constructing synthetic resultsets (for example, in metadata methods).
    
    Specified by:
    
    encodeString in interface BaseConnection
    
    Parameters:
    
    str - the string to encode
    
    Returns:
    
    an encoded representation of the string
    
    Throws:
    
    SQLException - if something goes wrong.
  - escapeString
```
public String escapeString(String str)
                    throws SQLException
```
    Description copied from interface: BaseConnection
    
    Escapes a string for use as string-literal within an SQL command. The method chooses the applicable escaping rules based on the value of BaseConnection.getStandardConformingStrings().
    
    Specified by:
    
    escapeString in interface BaseConnection
    
    Parameters:
    
    str - a string value
    
    Returns:
    
    the escaped representation of the string
    
    Throws:
    
    SQLException - if the string contains a \0 character
  - getStandardConformingStrings
```
public boolean getStandardConformingStrings()
```
    Description copied from interface: BaseConnection
    
    Returns whether the server treats string-literals according to the SQL standard or if it uses traditional PostgreSQL escaping rules. Versions up to 8.1 always treated backslashes as escape characters in string-literals. Since 8.2, this depends on the value of the standard_conforming_strings server variable.
    
    Specified by:
    
    getStandardConformingStrings in interface BaseConnection
    
    Returns:
    
    true if the server treats string literals according to the SQL standard
    
    See Also:
    
    QueryExecutor.getStandardConformingStrings()
  - isClosed
```
public boolean isClosed()
                 throws SQLException
```
    Specified by:
    
    isClosed in interface Connection
    
    Throws:
    
    SQLException
  - cancelQuery
```
public void cancelQuery()
                 throws SQLException
```
    Description copied from interface: BaseConnection
    
    Cancel the current query executing on this connection.
    
    Specified by:
    
    cancelQuery in interface BaseConnection
    
    Throws:
    
    SQLException - if something goes wrong.
  - getNotifications
```
public PGNotification[] getNotifications()
                                  throws SQLException
```
    Description copied from interface: PGConnection
    
    This method returns any notifications that have been received since the last call to this method. Returns null if there have been no notifications.
    
    Specified by:
    
    getNotifications in interface PGConnection
    
    Returns:
    
    notifications that have been received
    
    Throws:
    
    SQLException - if something wrong happens
  - getPrepareThreshold
```
public int getPrepareThreshold()
```
    Description copied from interface: PGConnection
    
    Get the default server-side prepare reuse threshold for statements created from this connection.
    
    Specified by:
    
    getPrepareThreshold in interface PGConnection
    
    Returns:
    
    the current threshold
  - setDefaultFetchSize
```
public void setDefaultFetchSize(int fetchSize)
                         throws SQLException
```
    Description copied from interface: PGConnection
    
    Set the default fetch size for statements created from this connection
    
    Specified by:
    
    setDefaultFetchSize in interface PGConnection
    
    Parameters:
    
    fetchSize - new default fetch size
    
    Throws:
    
    SQLException - if specified negative fetchSize parameter
    
    See Also:
    
    Statement.setFetchSize(int)
  - getDefaultFetchSize
```
public int getDefaultFetchSize()
```
    Description copied from interface: PGConnection
    
    Get the default fetch size for statements created from this connection
    
    Specified by:
    
    getDefaultFetchSize in interface PGConnection
    
    Returns:
    
    current state for default fetch size
    
    See Also:
    
    PGProperty.DEFAULT_ROW_FETCH_SIZE, Statement.getFetchSize()
  - setPrepareThreshold
```
public void setPrepareThreshold(int newThreshold)
```
    Description copied from interface: PGConnection
    
    Set the default statement reuse threshold before enabling server-side prepare. See PGStatement.setPrepareThreshold(int) for details.
    
    Specified by:
    
    setPrepareThreshold in interface PGConnection
    
    Parameters:
    
    newThreshold - the new threshold
  - getForceBinary
```
public boolean getForceBinary()
```
  - setForceBinary
```
public void setForceBinary(boolean newValue)
```
  - setTypeMapImpl
```
public void setTypeMapImpl(Map<String,Class<?>> map)
                    throws SQLException
```
    Throws:
    
    SQLException
  - getLogger
```
public Logger getLogger()
```
    Specified by:
    
    getLogger in interface BaseConnection
  - getProtocolVersion
```
public int getProtocolVersion()
```
  - getStringVarcharFlag
```
public boolean getStringVarcharFlag()
```
    Specified by:
    
    getStringVarcharFlag in interface BaseConnection
  - getCopyAPI
```
public CopyManager getCopyAPI()
                       throws SQLException
```
    Description copied from interface: PGConnection
    
    This returns the COPY API for the current connection.
    
    Specified by:
    
    getCopyAPI in interface PGConnection
    
    Returns:
    
    COPY API for the current connection
    
    Throws:
    
    SQLException - if something wrong happens
  - binaryTransferSend
```
public boolean binaryTransferSend(int oid)
```
    Description copied from interface: BaseConnection
    
    Returns true if value for the given oid should be sent using binary transfer. False if value should be sent using text transfer.
    
    Specified by:
    
    binaryTransferSend in interface BaseConnection
    
    Parameters:
    
    oid - The oid to check.
    
    Returns:
    
    True for binary transfer, false for text transfer.
  - getBackendPID
```
public int getBackendPID()
```
    Description copied from interface: PGConnection
    
    Return the process ID (PID) of the backend server process handling this connection.
    
    Specified by:
    
    getBackendPID in interface PGConnection
    
    Returns:
    
    PID of backend server process.
  - isColumnSanitiserDisabled
```
public boolean isColumnSanitiserDisabled()
```
    Description copied from interface: BaseConnection
    
    Return whether to disable column name sanitation.
    
    Specified by:
    
    isColumnSanitiserDisabled in interface BaseConnection
    
    Returns:
    
    true column sanitizer is disabled
  - setDisableColumnSanitiser
```
public void setDisableColumnSanitiser(boolean disableColumnSanitiser)
```
  - getPreferQueryMode
```
public PreferQueryMode getPreferQueryMode()
```
    Description copied from interface: PGConnection
    
    Returns true if the connection is configured to use "simple 'Q' execute" commands only When running in simple protocol only, certain features are not available: callable statements, partial result set fetch, bytea type, etc. The list of supported features is subject to change.
    
    Specified by:
    
    getPreferQueryMode in interface PGConnection
    
    Returns:
    
    true if the connection is configured to use "simple 'Q' execute" commands only
  - getAutosave
```
public AutoSave getAutosave()
```
    Description copied from interface: PGConnection
    
    Connection configuration regarding automatic per-query savepoints.
    
    Specified by:
    
    getAutosave in interface PGConnection
    
    Returns:
    
    connection configuration regarding automatic per-query savepoints
    
    See Also:
    
    PGProperty.AUTOSAVE
  - setAutosave
```
public void setAutosave(AutoSave autoSave)
```
    Description copied from interface: PGConnection
    
    Configures if connection should use automatic savepoints.
    
    Specified by:
    
    setAutosave in interface PGConnection
    
    Parameters:
    
    autoSave - connection configuration regarding automatic per-query savepoints
    
    See Also:
    
    PGProperty.AUTOSAVE
  - abort
```
protected void abort()
```
  - addTimerTask
```
public void addTimerTask(TimerTask timerTask,
                         long milliSeconds)
```
    Description copied from interface: BaseConnection
    
    Schedule a TimerTask for later execution. The task will be scheduled with the shared Timer for this connection.
    
    Specified by:
    
    addTimerTask in interface BaseConnection
    
    Parameters:
    
    timerTask - timer task to schedule
    
    milliSeconds - delay in milliseconds
  - purgeTimerTasks
```
public void purgeTimerTasks()
```
    Description copied from interface: BaseConnection
    
    Invoke purge() on the underlying shared Timer so that internal resources will be released.
    
    Specified by:
    
    purgeTimerTasks in interface BaseConnection
  - escapeIdentifier
```
public String escapeIdentifier(String identifier)
                        throws SQLException
```
    Description copied from interface: PGConnection
    
    Return the given string suitably quoted to be used as an identifier in an SQL statement string. Quotes are added only if necessary (i.e., if the string contains non-identifier characters or would be case-folded). Embedded quotes are properly doubled.
    
    Specified by:
    
    escapeIdentifier in interface PGConnection
    
    Parameters:
    
    identifier - input identifier
    
    Returns:
    
    the escaped identifier
    
    Throws:
    
    SQLException - if something goes wrong
  - escapeLiteral
```
public String escapeLiteral(String literal)
                     throws SQLException
```
    Description copied from interface: PGConnection
    
    Return the given string suitably quoted to be used as a string literal in an SQL statement string. Embedded single-quotes and backslashes are properly doubled. Note that quote_literal returns null on null input.
    
    Specified by:
    
    escapeLiteral in interface PGConnection
    
    Parameters:
    
    literal - input literal
    
    Returns:
    
    the quoted literal
    
    Throws:
    
    SQLException - if something goes wrong
  - getFieldMetadataCache
```
public LruCache<FieldMetadata.Key,FieldMetadata> getFieldMetadataCache()
```
    Description copied from interface: BaseConnection
    
    Return metadata cache for given connection
    
    Specified by:
    
    getFieldMetadataCache in interface BaseConnection
    
    Returns:
    
    metadata cache
  - createStatement
```
public Statement createStatement(int resultSetType,
                                 int resultSetConcurrency,
                                 int resultSetHoldability)
                          throws SQLException
```
    Specified by:
    
    createStatement in interface Connection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          int resultSetType,
                                          int resultSetConcurrency,
                                          int resultSetHoldability)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Throws:
    
    SQLException
  - prepareCall
```
public CallableStatement prepareCall(String sql,
                                     int resultSetType,
                                     int resultSetConcurrency,
                                     int resultSetHoldability)
                              throws SQLException
```
    Specified by:
    
    prepareCall in interface Connection
    
    Throws:
    
    SQLException
  - getMetaData
```
public DatabaseMetaData getMetaData()
                             throws SQLException
```
    Specified by:
    
    getMetaData in interface Connection
    
    Throws:
    
    SQLException
  - setTypeMap
```
public void setTypeMap(Map<String,Class<?>> map)
                throws SQLException
```
    Specified by:
    
    setTypeMap in interface Connection
    
    Throws:
    
    SQLException
  - makeArray
```
protected Array makeArray(int oid,
                          String fieldString)
                   throws SQLException
```
    Throws:
    
    SQLException
  - makeBlob
```
protected Blob makeBlob(long oid)
                 throws SQLException
```
    Throws:
    
    SQLException
  - makeClob
```
protected Clob makeClob(long oid)
                 throws SQLException
```
    Throws:
    
    SQLException
  - makeSQLXML
```
protected SQLXML makeSQLXML()
                     throws SQLException
```
    Throws:
    
    SQLException
  - createClob
```
public Clob createClob()
                throws SQLException
```
    Specified by:
    
    createClob in interface Connection
    
    Throws:
    
    SQLException
  - createBlob
```
public Blob createBlob()
                throws SQLException
```
    Specified by:
    
    createBlob in interface Connection
    
    Throws:
    
    SQLException
  - createNClob
```
public NClob createNClob()
                  throws SQLException
```
    Specified by:
    
    createNClob in interface Connection
    
    Throws:
    
    SQLException
  - createSQLXML
```
public SQLXML createSQLXML()
                    throws SQLException
```
    Specified by:
    
    createSQLXML in interface Connection
    
    Throws:
    
    SQLException
  - createStruct
```
public Struct createStruct(String typeName,
                           Object[] attributes)
                    throws SQLException
```
    Specified by:
    
    createStruct in interface Connection
    
    Throws:
    
    SQLException
  - createArrayOf
```
public Array createArrayOf(String typeName,
                           Object[] elements)
                    throws SQLException
```
    Specified by:
    
    createArrayOf in interface Connection
    
    Throws:
    
    SQLException
  - isValid
```
public boolean isValid(int timeout)
                throws SQLException
```
    Specified by:
    
    isValid in interface Connection
    
    Throws:
    
    SQLException
  - setClientInfo
```
public void setClientInfo(String name,
                          String value)
                   throws SQLClientInfoException
```
    Specified by:
    
    setClientInfo in interface Connection
    
    Throws:
    
    SQLClientInfoException
  - setClientInfo
```
public void setClientInfo(Properties properties)
                   throws SQLClientInfoException
```
    Specified by:
    
    setClientInfo in interface Connection
    
    Throws:
    
    SQLClientInfoException
  - getClientInfo
```
public String getClientInfo(String name)
                     throws SQLException
```
    Specified by:
    
    getClientInfo in interface Connection
    
    Throws:
    
    SQLException
  - getClientInfo
```
public Properties getClientInfo()
                         throws SQLException
```
    Specified by:
    
    getClientInfo in interface Connection
    
    Throws:
    
    SQLException
  - createQueryObject
```
public <T> T createQueryObject(Class<T> ifc)
                        throws SQLException
```
    Throws:
    
    SQLException
  - isWrapperFor
```
public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
```
    Specified by:
    
    isWrapperFor in interface Wrapper
    
    Throws:
    
    SQLException
  - unwrap
```
public <T> T unwrap(Class<T> iface)
             throws SQLException
```
    Specified by:
    
    unwrap in interface Wrapper
    
    Throws:
    
    SQLException
  - getSchema
```
public String getSchema()
                 throws SQLException
```
    Specified by:
    
    getSchema in interface Connection
    
    Throws:
    
    SQLException
  - setSchema
```
public void setSchema(String schema)
               throws SQLException
```
    Specified by:
    
    setSchema in interface Connection
    
    Throws:
    
    SQLException
  - abort
```
public void abort(Executor executor)
           throws SQLException
```
    Specified by:
    
    abort in interface Connection
    
    Throws:
    
    SQLException
  - setNetworkTimeout
```
public void setNetworkTimeout(Executor executor,
                              int milliseconds)
                       throws SQLException
```
    Specified by:
    
    setNetworkTimeout in interface Connection
    
    Throws:
    
    SQLException
  - getNetworkTimeout
```
public int getNetworkTimeout()
                      throws SQLException
```
    Specified by:
    
    getNetworkTimeout in interface Connection
    
    Throws:
    
    SQLException
  - setHoldability
```
public void setHoldability(int holdability)
                    throws SQLException
```
    Specified by:
    
    setHoldability in interface Connection
    
    Throws:
    
    SQLException
  - getHoldability
```
public int getHoldability()
                   throws SQLException
```
    Specified by:
    
    getHoldability in interface Connection
    
    Throws:
    
    SQLException
  - setSavepoint
```
public Savepoint setSavepoint()
                       throws SQLException
```
    Specified by:
    
    setSavepoint in interface Connection
    
    Throws:
    
    SQLException
  - setSavepoint
```
public Savepoint setSavepoint(String name)
                       throws SQLException
```
    Specified by:
    
    setSavepoint in interface Connection
    
    Throws:
    
    SQLException
  - rollback
```
public void rollback(Savepoint savepoint)
              throws SQLException
```
    Specified by:
    
    rollback in interface Connection
    
    Throws:
    
    SQLException
  - releaseSavepoint
```
public void releaseSavepoint(Savepoint savepoint)
                      throws SQLException
```
    Specified by:
    
    releaseSavepoint in interface Connection
    
    Throws:
    
    SQLException
  - createStatement
```
public Statement createStatement(int resultSetType,
                                 int resultSetConcurrency)
                          throws SQLException
```
    Specified by:
    
    createStatement in interface Connection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          int resultSetType,
                                          int resultSetConcurrency)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Throws:
    
    SQLException
  - prepareCall
```
public CallableStatement prepareCall(String sql,
                                     int resultSetType,
                                     int resultSetConcurrency)
                              throws SQLException
```
    Specified by:
    
    prepareCall in interface Connection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          int autoGeneratedKeys)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          int[] columnIndexes)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Throws:
    
    SQLException
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                          String[] columnNames)
                                   throws SQLException
```
    Specified by:
    
    prepareStatement in interface Connection
    
    Throws:
    
    SQLException

Class PgConnection

Nested Class Summary

Field Summary

Fields inherited from interface java.sql.Connection

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

prepareThreshold

defaultFetchSize

forcebinary

typemap

metadata

Constructor Detail

PgConnection

Method Detail

createQuery

setFlushCacheOnDeallocate

getTimestampUtils

createStatement

prepareStatement

prepareCall

getTypeMap

getQueryExecutor

addWarning

execSQLQuery

execSQLQuery

execSQLUpdate

setCursorName

getCursorName

getURL

getUserName

getFastpathAPI

getLargeObjectAPI

getObject

createTypeInfo

getTypeInfo

addDataType

addDataType

close

nativeSQL

getWarnings

clearWarnings

setReadOnly

isReadOnly

setAutoCommit

getAutoCommit

commit

checkClosed

rollback

getTransactionState

getTransactionIsolation

setTransactionIsolation

getIsolationLevelName

setCatalog

getCatalog

finalize

getDBVersionNumber

getServerMajorVersion

getServerMinorVersion

haveMinimumServerVersion

haveMinimumServerVersion

haveMinimumServerVersion

haveMinimumCompatibleVersion

haveMinimumCompatibleVersion

haveMinimumCompatibleVersion

getEncoding

encodeString

escapeString

getStandardConformingStrings

isClosed

cancelQuery

getNotifications

getPrepareThreshold

setDefaultFetchSize

getDefaultFetchSize

setPrepareThreshold

getForceBinary

setForceBinary

setTypeMapImpl