public interface PGConnection
Modifier and Type | Method and Description |
---|---|
void |
addDataType(java.lang.String type,
java.lang.Class<? extends PGobject> klass)
This allows client code to add a handler for one of org.postgresql's more unique data types.
|
void |
addDataType(java.lang.String type,
java.lang.String className)
Deprecated.
As of 8.0, replaced by
addDataType(String, Class) . This deprecated method
does not work correctly for registering classes that cannot be directly loaded by
the JDBC driver's classloader. |
java.lang.String |
escapeIdentifier(java.lang.String identifier)
Return the given string suitably quoted to be used as an identifier in an SQL statement string.
|
java.lang.String |
escapeLiteral(java.lang.String literal)
Return the given string suitably quoted to be used as a string literal in an SQL statement
string.
|
AutoSave |
getAutosave()
Connection configuration regarding automatic per-query savepoints.
|
int |
getBackendPID()
Return the process ID (PID) of the backend server process handling this connection.
|
CopyManager |
getCopyAPI()
This returns the COPY API for the current connection.
|
int |
getDefaultFetchSize()
Get the default fetch size for statements created from this connection
|
Fastpath |
getFastpathAPI()
This returns the Fastpath API for the current connection.
|
LargeObjectManager |
getLargeObjectAPI()
This returns the LargeObject API for the current connection.
|
PGNotification[] |
getNotifications()
This method returns any notifications that have been received since the last call to this
method.
|
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.
|
void |
setAutosave(AutoSave autoSave)
Configures if connection should use automatic savepoints.
|
void |
setDefaultFetchSize(int fetchSize)
Set the default fetch size for statements created from this connection
|
void |
setPrepareThreshold(int threshold)
Set the default statement reuse threshold before enabling server-side prepare.
|
PGNotification[] getNotifications() throws java.sql.SQLException
java.sql.SQLException
- if something wrong happensCopyManager getCopyAPI() throws java.sql.SQLException
java.sql.SQLException
- if something wrong happensLargeObjectManager getLargeObjectAPI() throws java.sql.SQLException
java.sql.SQLException
- if something wrong happensFastpath getFastpathAPI() throws java.sql.SQLException
java.sql.SQLException
- if something wrong happensvoid addDataType(java.lang.String type, java.lang.String className)
addDataType(String, Class)
. This deprecated method
does not work correctly for registering classes that cannot be directly loaded by
the JDBC driver's classloader.addDataType(type, Class.forName(name))
.type
- JDBC type nameclassName
- class namejava.lang.RuntimeException
- if the type cannot be registered (class not found, etc).void addDataType(java.lang.String type, java.lang.Class<? extends PGobject> klass) throws java.sql.SQLException
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
void setPrepareThreshold(int threshold)
PGStatement.setPrepareThreshold(int)
for details.threshold
- the new thresholdint getPrepareThreshold()
void setDefaultFetchSize(int fetchSize) throws java.sql.SQLException
fetchSize
- new default fetch sizejava.sql.SQLException
- if specified negative fetchSize
parameterStatement.setFetchSize(int)
int getDefaultFetchSize()
PGProperty.DEFAULT_ROW_FETCH_SIZE
,
Statement.getFetchSize()
int getBackendPID()
java.lang.String escapeIdentifier(java.lang.String identifier) throws java.sql.SQLException
identifier
- input identifierjava.sql.SQLException
- if something goes wrongjava.lang.String escapeLiteral(java.lang.String literal) throws java.sql.SQLException
literal
- input literaljava.sql.SQLException
- if something goes wrongPreferQueryMode getPreferQueryMode()
AutoSave getAutosave()
PGProperty.AUTOSAVE
void setAutosave(AutoSave autoSave)
autoSave
- connection configuration regarding automatic per-query savepointsPGProperty.AUTOSAVE
Copyright © 2018 PostgreSQL Global Development Group. All rights reserved.