org.postgresql.core

Interface BaseConnection

All Superinterfaces:

java.lang.AutoCloseable, java.sql.Connection, PGConnection, java.sql.Wrapper

All Known Implementing Classes:

AbstractJdbc2Connection, AbstractJdbc3Connection, AbstractJdbc3gConnection, Jdbc4Connection

public interface BaseConnection
extends PGConnection, java.sql.Connection

Driver-internal connection interface. Application code should not use this interface.

Field Summary

Fields inherited from interface java.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Method Summary

Methods

Modifier and Type	Method and Description
void	cancelQuery() Cancel the current query executing on this connection.
byte[]	encodeString(java.lang.String str) Encode a string using the database's client_encoding (usually UTF8, but can vary on older server versions).
java.lang.String	escapeString(java.lang.String str) Escapes a string for use as string-literal within an SQL command.
java.sql.ResultSet	execSQLQuery(java.lang.String s) Execute a SQL query that returns a single resultset.
java.sql.ResultSet	execSQLQuery(java.lang.String s, int resultSetType, int resultSetConcurrency)
void	execSQLUpdate(java.lang.String s) Execute a SQL query that does not return results.
Encoding	getEncoding()
Logger	getLogger()
java.lang.Object	getObject(java.lang.String type, java.lang.String value) Construct and return an appropriate object for the given type and value.
QueryExecutor	getQueryExecutor() Get the QueryExecutor implementation for this connection.
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	getTransactionState() Get the current transaction state of this connection.
TypeInfo	getTypeInfo()
boolean	haveMinimumCompatibleVersion(java.lang.String ver) Check if we should use driver behaviour introduced in a particular driver version.
boolean	haveMinimumServerVersion(java.lang.String ver) Check if we have at least a particular server version.

Methods inherited from interface org.postgresql.PGConnection

addDataType, addDataType, getCopyAPI, getFastpathAPI, getLargeObjectAPI, getNotifications, getPrepareThreshold, setPrepareThreshold

Methods inherited from interface java.sql.Connection

abort, clearWarnings, close, commit, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStruct, getAutoCommit, getCatalog, getClientInfo, getClientInfo, getHoldability, getMetaData, getNetworkTimeout, getSchema, getTransactionIsolation, getTypeMap, getWarnings, isClosed, isReadOnly, isValid, nativeSQL, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, releaseSavepoint, rollback, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setHoldability, setNetworkTimeout, setReadOnly, setSavepoint, setSavepoint, setSchema, setTransactionIsolation, setTypeMap

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Detail

cancelQuery

void cancelQuery()
                 throws java.sql.SQLException

Cancel the current query executing on this connection.

Throws:

java.sql.SQLException - if something goes wrong.

execSQLQuery

java.sql.ResultSet execSQLQuery(java.lang.String s)
                                throws java.sql.SQLException

Execute a SQL query that returns a single resultset. Never causes a new transaction to be started regardless of the autocommit setting.

Parameters:

s - the query to execute

Returns:

the (non-null) returned resultset

Throws:

java.sql.SQLException - if something goes wrong.

execSQLQuery

java.sql.ResultSet execSQLQuery(java.lang.String s,
                              int resultSetType,
                              int resultSetConcurrency)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

execSQLUpdate

void execSQLUpdate(java.lang.String s)
                   throws java.sql.SQLException

Execute a SQL query that does not return results. Never causes a new transaction to be started regardless of the autocommit setting.

Parameters:

s - the query to execute

Throws:

java.sql.SQLException - if something goes wrong.

getQueryExecutor

QueryExecutor getQueryExecutor()

Get the QueryExecutor implementation for this connection.

Returns:

the (non-null) executor

getObject

java.lang.Object getObject(java.lang.String type,
                         java.lang.String value)
                           throws java.sql.SQLException

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.

Parameters:

type - the backend typename

value - the type-specific string representation of the value

Returns:

an appropriate object; never null.

Throws:

java.sql.SQLException - if something goes wrong

getEncoding

Encoding getEncoding()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getTypeInfo

TypeInfo getTypeInfo()

haveMinimumCompatibleVersion

boolean haveMinimumCompatibleVersion(java.lang.String ver)

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.

Parameters:

ver - the driver version to check

Returns:

true if the driver's behavioural version is at least "ver".

Throws:

java.sql.SQLException - if something goes wrong

haveMinimumServerVersion

boolean haveMinimumServerVersion(java.lang.String ver)

Check if we have at least a particular server version.

Parameters:

ver - the server version to check

Returns:

true if the server version is at least "ver".

Throws:

java.sql.SQLException - if something goes wrong

encodeString

byte[] encodeString(java.lang.String str)
                    throws java.sql.SQLException

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).

Parameters:

str - the string to encode

Returns:

an encoded representation of the string

Throws:

java.sql.SQLException - if something goes wrong.

escapeString

java.lang.String escapeString(java.lang.String str)
                              throws java.sql.SQLException

Escapes a string for use as string-literal within an SQL command. The method chooses the applicable escaping rules based on the value of getStandardConformingStrings().

Parameters:

str - a string value

Returns:

the escaped representation of the string

Throws:

java.sql.SQLException - if the string contains a \0 character

getStandardConformingStrings

boolean getStandardConformingStrings()

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.

Returns:

true if the server treats string literals according to the SQL standard

See Also:

ProtocolConnection.getStandardConformingStrings()

getTimestampUtils

TimestampUtils getTimestampUtils()

getLogger

Logger getLogger()

getStringVarcharFlag

boolean getStringVarcharFlag()

getTransactionState

int getTransactionState()

Get the current transaction state of this connection.

Returns:

a ProtocolConnection.TRANSACTION_* constant.