net.sf.hajdbc.dialect

Class PostgreSQLDialect

java.lang.Object

net.sf.hajdbc.dialect.StandardDialect

net.sf.hajdbc.dialect.PostgreSQLDialect

All Implemented Interfaces:

Dialect

public class PostgreSQLDialect
extends StandardDialect

Dialect for PostgreSQL.

Since:

1.1

Author:

Paul Ferraro

Constructor Summary

Constructors

Constructor and Description
PostgreSQLDialect()

Method Summary

Modifier and Type	Method and Description
protected java.lang.String	alterIdentityColumnFormat()
protected java.lang.String	currentTimestampPattern()
int	getColumnType(ColumnProperties properties) PostgreSQL uses the native type OID to identify BLOBs.
java.util.List<java.lang.String>	getDefaultSchemas(java.sql.DatabaseMetaData metaData) PostgreSQL uses a schema search path to locate unqualified table names.
java.util.regex.Pattern	getIdentifierPattern(java.sql.DatabaseMetaData metaData) Versions >=8.1 of the PostgreSQL JDBC driver return incorrect values for DatabaseMetaData.getExtraNameCharacters().
protected java.lang.String	nextSequenceValueFormat()
protected java.lang.String	randomPattern()
protected java.lang.String	selectForUpdatePattern() Recognizes FOR SHARE and FOR UPDATE.
protected java.lang.String	sequencePattern()
protected java.lang.String	truncateTableFormat()

Methods inherited from class net.sf.hajdbc.dialect.StandardDialect

alterSequenceFormat, createForeignKeyConstraintFormat, createUniqueConstraintFormat, currentDatePattern, currentTimePattern, currentTimestampFunction, dateLiteralFormat, dropConstraintFormat, dropForeignKeyConstraintFormat, dropUniqueConstraintFormat, dummyTable, evaluateCurrentDate, evaluateCurrentTime, evaluateCurrentTimestamp, evaluateRand, executeFunction, executeFunctionFormat, executeFunctionSQL, executeQuery, getAlterIdentityColumnSQL, getAlterSequenceSQL, getCreateForeignKeyConstraintSQL, getCreateUniqueConstraintSQL, getDropForeignKeyConstraintSQL, getDropUniqueConstraintSQL, getNextSequenceValueSQL, getSequences, getSimpleSQL, getTruncateTableSQL, insertIntoTablePattern, isSelectForUpdate, parse, parseInsertTable, parseSequence, sequenceTableType, timeLiteralFormat, timestampLiteralFormat

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSQLDialect

public PostgreSQLDialect()

Method Detail

getDefaultSchemas

public java.util.List<java.lang.String> getDefaultSchemas(java.sql.DatabaseMetaData metaData)
                                                   throws java.sql.SQLException

PostgreSQL uses a schema search path to locate unqualified table names. The default search path is [$user,public], where $user is the current user.

Specified by:

getDefaultSchemas in interface Dialect

Overrides:

getDefaultSchemas in class StandardDialect

Returns:

a list of schema names

Throws:

java.sql.SQLException

See Also:

StandardDialect.getDefaultSchemas(java.sql.DatabaseMetaData)

getColumnType

public int getColumnType(ColumnProperties properties)

PostgreSQL uses the native type OID to identify BLOBs. However the JDBC driver incomprehensibly maps OIDs to INTEGERs. The PostgreSQL JDBC folks claim this intentional.

Specified by:

getColumnType in interface Dialect

Overrides:

getColumnType in class StandardDialect

Parameters:

properties - table column meta data

Returns:

the JDBC data type of this column

See Also:

StandardDialect.getColumnType(net.sf.hajdbc.ColumnProperties)

getIdentifierPattern

public java.util.regex.Pattern getIdentifierPattern(java.sql.DatabaseMetaData metaData)
                                             throws java.sql.SQLException

Versions >=8.1 of the PostgreSQL JDBC driver return incorrect values for DatabaseMetaData.getExtraNameCharacters().

Specified by:

getIdentifierPattern in interface Dialect

Overrides:

getIdentifierPattern in class StandardDialect

Returns:

a regular expression pattern

Throws:

java.sql.SQLException

See Also:

StandardDialect.getIdentifierPattern(java.sql.DatabaseMetaData)

truncateTableFormat

protected java.lang.String truncateTableFormat()

Overrides:

truncateTableFormat in class StandardDialect

See Also:

StandardDialect.truncateTableFormat()

sequencePattern

protected java.lang.String sequencePattern()

Overrides:

sequencePattern in class StandardDialect

See Also:

StandardDialect.sequencePattern()

nextSequenceValueFormat

protected java.lang.String nextSequenceValueFormat()

Overrides:

nextSequenceValueFormat in class StandardDialect

See Also:

StandardDialect.nextSequenceValueFormat()

alterIdentityColumnFormat

protected java.lang.String alterIdentityColumnFormat()

Overrides:

alterIdentityColumnFormat in class StandardDialect

See Also:

StandardDialect.alterIdentityColumnFormat()

currentTimestampPattern

protected java.lang.String currentTimestampPattern()

Overrides:

currentTimestampPattern in class StandardDialect

See Also:

StandardDialect.currentTimestampPattern()

randomPattern

protected java.lang.String randomPattern()

Overrides:

randomPattern in class StandardDialect

See Also:

StandardDialect.randomPattern()

selectForUpdatePattern

protected java.lang.String selectForUpdatePattern()

Recognizes FOR SHARE and FOR UPDATE.

Overrides:

selectForUpdatePattern in class StandardDialect

See Also:

StandardDialect.selectForUpdatePattern()