com.caucho.quercus.lib.db

Class Postgres

java.lang.Object

com.caucho.quercus.lib.db.JdbcConnectionResource

com.caucho.quercus.lib.db.Postgres

All Implemented Interfaces:

EnvCleanup

public class Postgres
extends JdbcConnectionResource

postgres connection class (postgres has NO object oriented API)

Field Summary

Fields inherited from class com.caucho.quercus.lib.db.JdbcConnectionResource

_conn, _driver, _flags, _host, _isEmulatePrepares, _port, _socket, _sqlParseToken, _url

Constructor Summary

Constructors

Constructor and Description
Postgres(Env env, java.lang.String host, java.lang.String user, java.lang.String password, java.lang.String db, int port, java.lang.String driver, java.lang.String url)

Method Summary

Modifier and Type	Method and Description
protected void	clearErrors() This function is overriden in Postgres to clear any postgres specific server error message
protected ConnectionEntry	connectImpl(Env env, java.lang.String host, java.lang.String userName, java.lang.String password, java.lang.String dbname, int port, java.lang.String socket, int flags, java.lang.String driver, java.lang.String url, boolean isNewLink, boolean isEmulatePrepares) Connects to the underlying database.
protected JdbcResultResource	createResult(java.sql.Statement stmt, java.sql.ResultSet rs) Creates a database-specific result.
protected PostgresStatement	createStatementResource(Env env)
PostgresResult	getAsynchronousResult()
PostgresStatement	getAsynchronousStatement()
java.lang.String	getClientEncoding() Return the "client_encoding" property.
protected java.lang.String	getDriverName()
protected java.lang.Object	getServerErrorMessage() Return the postgres server specific error message
PostgresStatement	getStatement(java.lang.String name)
protected void	keepResourceValues(java.sql.Statement stmt) This function is overriden in Postgres to keep result set references for php/430a (see also php/1f33)
protected boolean	keepStatementOpen() This function is overriden in Postgres to keep statement references for php/430a
static StringValue	pgRealEscapeString(StringValue str)
PostgresStatement	prepare(Env env, java.lang.String query) returns a prepared statement
void	putStatement(java.lang.String name, PostgresStatement stmt)
PostgresResult	query(Env env, java.lang.String sql) Executes a query.
protected StringValue	realEscapeString(StringValue str) Escape the given string for SQL statements.
PostgresStatement	removeStatement(java.lang.String name)
protected void	saveErrors(java.sql.SQLException e) This function is overriden in Postgres to save the postgres specific server error message
void	setAsynchronousResult(PostgresResult asyncResult)
void	setAsynchronousStatement(PostgresStatement asyncStmt)
boolean	setClientEncoding(java.lang.String encoding) Set the "client_encoding" property.
java.lang.String	toString() Converts to a string.

Methods inherited from class com.caucho.quercus.lib.db.JdbcConnectionResource

cleanup, close, closeStatement, commit, connectInternal, createJavaStatement, createStatement, error, getAffectedRows, getAutoCommit, getCatalog, getCatalogs, getCharacterSetName, getClientInfo, getClientInfo, getConnection, getDbName, getDriver, getErrorCode, getErrorMessage, getException, getFieldCount, getHost, getHostInfo, getJavaConnection, getPassword, getPort, getResultResource, getResultSet, getServerInfo, getServerStat, getTableMetaData, getUrl, getURL, getUserName, getWarnings, infoToVersion, isConnected, isEmulatePrepares, isSeekable, parseSqlToken, ping, realEscapeString, realQuery, rollback, setAffectedRows, setAutoCommit, setCatalog, setResultResource, setWarnings, toObject, validateConnection

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

Postgres

public Postgres(Env env,
                java.lang.String host,
                java.lang.String user,
                java.lang.String password,
                java.lang.String db,
                int port,
                java.lang.String driver,
                java.lang.String url)

Method Detail

getDriverName

protected java.lang.String getDriverName()

Overrides:

getDriverName in class JdbcConnectionResource

connectImpl

protected ConnectionEntry connectImpl(Env env,
                                      java.lang.String host,
                                      java.lang.String userName,
                                      java.lang.String password,
                                      java.lang.String dbname,
                                      int port,
                                      java.lang.String socket,
                                      int flags,
                                      java.lang.String driver,
                                      java.lang.String url,
                                      boolean isNewLink,
                                      boolean isEmulatePrepares)

Connects to the underlying database.

Specified by:

connectImpl in class JdbcConnectionResource

prepare

public PostgresStatement prepare(Env env,
                                 java.lang.String query)

returns a prepared statement

Overrides:

prepare in class JdbcConnectionResource

createStatementResource

protected PostgresStatement createStatementResource(Env env)

Overrides:

createStatementResource in class JdbcConnectionResource

query

public PostgresResult query(Env env,
                            java.lang.String sql)

Executes a query.

Parameters:

sql - the escaped query string (can contain escape sequences like `\n' and `\Z')

Returns:

a JdbcResultResource, or null for failure

createResult

protected JdbcResultResource createResult(java.sql.Statement stmt,
                                          java.sql.ResultSet rs)

Creates a database-specific result.

Overrides:

createResult in class JdbcConnectionResource

setAsynchronousResult

public void setAsynchronousResult(PostgresResult asyncResult)

getAsynchronousResult

public PostgresResult getAsynchronousResult()

getAsynchronousStatement

public PostgresStatement getAsynchronousStatement()

setAsynchronousStatement

public void setAsynchronousStatement(PostgresStatement asyncStmt)

putStatement

public void putStatement(java.lang.String name,
                         PostgresStatement stmt)

getStatement

public PostgresStatement getStatement(java.lang.String name)

removeStatement

public PostgresStatement removeStatement(java.lang.String name)

keepResourceValues

protected void keepResourceValues(java.sql.Statement stmt)

This function is overriden in Postgres to keep result set references for php/430a (see also php/1f33)

Overrides:

keepResourceValues in class JdbcConnectionResource

keepStatementOpen

protected boolean keepStatementOpen()

This function is overriden in Postgres to keep statement references for php/430a

Overrides:

keepStatementOpen in class JdbcConnectionResource

pgRealEscapeString

public static StringValue pgRealEscapeString(StringValue str)

realEscapeString

protected StringValue realEscapeString(StringValue str)

Escape the given string for SQL statements.

Parameters:

str - a string

Returns:

the string escaped for SQL statements

clearErrors

protected void clearErrors()

This function is overriden in Postgres to clear any postgres specific server error message

Overrides:

clearErrors in class JdbcConnectionResource

saveErrors

protected void saveErrors(java.sql.SQLException e)

This function is overriden in Postgres to save the postgres specific server error message

Overrides:

saveErrors in class JdbcConnectionResource

getServerErrorMessage

protected java.lang.Object getServerErrorMessage()

Return the postgres server specific error message

toString

public java.lang.String toString()

Description copied from class: JdbcConnectionResource

Converts to a string.

Overrides:

toString in class JdbcConnectionResource

getClientEncoding

public java.lang.String getClientEncoding()

Return the "client_encoding" property. This is the encoding the JDBC driver uses to read character data from the server. The JDBC driver used to let the user change the encoding, but it now fails on any attempt to set the encoding to anything other than UNICODE.

Overrides:

getClientEncoding in class JdbcConnectionResource

setClientEncoding

public boolean setClientEncoding(java.lang.String encoding)

Set the "client_encoding" property. This is a no-op for the JDBC driver because it only supports UNICODE as the client encoding. Return true to indicate success in all cases.

Overrides:

setClientEncoding in class JdbcConnectionResource