de.fuberlin.wiwiss.d2rq.sql.vendor

Class PostgreSQL

java.lang.Object

de.fuberlin.wiwiss.d2rq.sql.vendor.SQL92

de.fuberlin.wiwiss.d2rq.sql.vendor.PostgreSQL

All Implemented Interfaces:

Vendor

public class PostgreSQL
extends SQL92

Field Summary

Fields inherited from interface de.fuberlin.wiwiss.d2rq.sql.vendor.Vendor

HSQLDB, InterbaseOrFirebird, MSAccess, MySQL, Oracle, PostgreSQL, SQL92, SQLServer

Constructor Summary

Constructors

Constructor and Description
PostgreSQL()

Method Summary

Methods

Modifier and Type	Method and Description
void	afterCancel(Connection connection) Vendor-specific cleanup code to execute after statement cancel.
void	afterClose(Connection connection) Vendor-specific cleanup code to execute after statement close.
DataType	getDataType(int jdbcType, String name, int size) Returns a DataType corresponding to a JDBC type.
void	initializeConnection(Connection connection) Vendor-specific initialization for a database connection.
boolean	isIgnoredTable(String schema, String table) TODO Use the Filter interface for this
String	quoteBinaryLiteral(String hexString)

Methods inherited from class de.fuberlin.wiwiss.d2rq.sql.vendor.SQL92

afterQuery, beforeCancel, beforeClose, beforeQuery, booleanExpressionToSimpleExpression, getConcatenationExpression, getDefaultConnectionProperties, getRelationNameAliasExpression, getRowNumLimitAsExpression, getRowNumLimitAsQueryAppendage, getRowNumLimitAsSelectModifier, quoteAttribute, quoteDateLiteral, quoteIdentifier, quoteRelationName, quoteStringLiteral, quoteTimeLiteral, quoteTimestampLiteral

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSQL

public PostgreSQL()

Method Detail

quoteBinaryLiteral

public String quoteBinaryLiteral(String hexString)

Specified by:

quoteBinaryLiteral in interface Vendor

Overrides:

quoteBinaryLiteral in class SQL92

getDataType

public DataType getDataType(int jdbcType,
                   String name,
                   int size)

Description copied from interface: Vendor

Returns a DataType corresponding to a JDBC type. This may be an unsupported datatype; in this case, its DataType.isUnsupported() method will return true. null will be returned if the vendor code doesn't handle this datatype at all; that should generally be considered a bug.

Specified by:

getDataType in interface Vendor

Overrides:

getDataType in class SQL92

Parameters:

jdbcType - A java.sql.Types constant

name - The type name, as reported by java.sql metadata methods, normalized to uppercase

size - Character size of the type, or 0 if not applicable

Returns:

A compatible D2RQ DataType instance, or null if the vendor code is broken

isIgnoredTable

public boolean isIgnoredTable(String schema,
                     String table)

Description copied from interface: Vendor

TODO Use the Filter interface for this

Specified by:

isIgnoredTable in interface Vendor

Overrides:

isIgnoredTable in class SQL92

Parameters:

schema - A schema name, or null for the connection's default schema

table - A table name

Returns:

true if this is a system table that doesn't contain user/application data

initializeConnection

public void initializeConnection(Connection connection)
                          throws SQLException

Description copied from interface: Vendor

Vendor-specific initialization for a database connection.

Specified by:

initializeConnection in interface Vendor

Overrides:

initializeConnection in class SQL92

Throws:

SQLException

afterClose

public void afterClose(Connection connection)
                throws SQLException

Description copied from interface: Vendor

Vendor-specific cleanup code to execute after statement close. Note: only one query can be "active" at a time per connection

Specified by:

afterClose in interface Vendor

Overrides:

afterClose in class SQL92

Throws:

SQLException

afterCancel

public void afterCancel(Connection connection)
                 throws SQLException

Description copied from interface: Vendor

Vendor-specific cleanup code to execute after statement cancel. Note: only one query can be "active" at a time per connection

Specified by:

afterCancel in interface Vendor

Overrides:

afterCancel in class SQL92

Throws:

SQLException