org.jminor.dbms.postgresql

Class PostgreSQLDatabase

java.lang.Object

org.jminor.common.db.AbstractDatabase

org.jminor.dbms.postgresql.PostgreSQLDatabase

All Implemented Interfaces:

Database

public final class PostgreSQLDatabase
extends AbstractDatabase

A Database implementation based on the PostgreSQL database.

Nested Class Summary

Nested classes/interfaces inherited from interface org.jminor.common.db.Database

Database.Statistics, Database.Type

Field Summary

Fields inherited from interface org.jminor.common.db.Database

DATABASE_EMBEDDED, DATABASE_EMBEDDED_IN_MEMORY, DATABASE_HOST, DATABASE_INIT_SCRIPT, DATABASE_PORT, DATABASE_SID, DATABASE_TYPE, DEFAULT_LOGIN_TIMEOUT, PASSWORD_PROPERTY, USER_PROPERTY

Constructor Summary

Constructors

Constructor and Description
PostgreSQLDatabase() Instantiates a new PostgreSQLDatabase.
PostgreSQLDatabase(java.lang.String host, java.lang.Integer port, java.lang.String database) Instantiates a new PostgreSQLDatabase.

Method Summary

Modifier and Type	Method and Description
java.lang.String	getAutoIncrementQuery(java.lang.String idSource) Returns a query string for retrieving the last automatically generated id from the given id source
java.lang.String	getCheckConnectionQuery() Returns a query to use when checking if the connection is valid, this is used in cases where the dbms does not support the isValid() call.
java.lang.String	getSequenceQuery(java.lang.String sequenceName)
java.lang.String	getURL(java.util.Properties connectionProperties)
boolean	isAuthenticationException(java.sql.SQLException exception) This default implementation returns false
boolean	isReferentialIntegrityException(java.sql.SQLException exception) This default implementation returns false
boolean	isUniqueConstraintException(java.sql.SQLException exception)
boolean	supportsIsValid()

Methods inherited from class org.jminor.common.db.AbstractDatabase

addConnectionProperties, createConnection, getAuthenticationInfo, getDriverClassName, getErrorMessage, getHost, getLoginTimeout, getPort, getSid, getType, getUrlAppend, isEmbedded, setUrlAppend, shutdownEmbedded, supportsNowait, supportsSelectForUpdate

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.jminor.common.db.Database

getDatabaseType

Constructor Detail

PostgreSQLDatabase

public PostgreSQLDatabase()

Instantiates a new PostgreSQLDatabase.

PostgreSQLDatabase

public PostgreSQLDatabase(java.lang.String host,
                          java.lang.Integer port,
                          java.lang.String database)

Instantiates a new PostgreSQLDatabase.

Parameters:

host - the host name

port - the port number

database - the database name

Method Detail

getAutoIncrementQuery

public java.lang.String getAutoIncrementQuery(java.lang.String idSource)

Returns a query string for retrieving the last automatically generated id from the given id source

Parameters:

idSource - the source for the id, for example a sequence name or in the case of Derby, the name of the table auto generating the value

Returns:

a query string for retrieving the last auto-increment value from idSource

getSequenceQuery

public java.lang.String getSequenceQuery(java.lang.String sequenceName)

Specified by:

getSequenceQuery in interface Database

Overrides:

getSequenceQuery in class AbstractDatabase

Parameters:

sequenceName - the name of the sequence

Returns:

a query for selecting the next value from the given sequence

getURL

public java.lang.String getURL(java.util.Properties connectionProperties)

Parameters:

connectionProperties - the connection properties, used primarily to provide embedded databases with user info for authentication purposes

Returns:

the database url of the active database, based on system properties

isAuthenticationException

public boolean isAuthenticationException(java.sql.SQLException exception)

This default implementation returns false

Specified by:

isAuthenticationException in interface Database

Overrides:

isAuthenticationException in class AbstractDatabase

Parameters:

exception - the exception

Returns:

false

isReferentialIntegrityException

public boolean isReferentialIntegrityException(java.sql.SQLException exception)

This default implementation returns false

Specified by:

isReferentialIntegrityException in interface Database

Overrides:

isReferentialIntegrityException in class AbstractDatabase

Parameters:

exception - the exception

Returns:

false

isUniqueConstraintException

public boolean isUniqueConstraintException(java.sql.SQLException exception)

Specified by:

isUniqueConstraintException in interface Database

Overrides:

isUniqueConstraintException in class AbstractDatabase

Parameters:

exception - the exception

Returns:

true if this exception is a unique key exception

supportsIsValid

public boolean supportsIsValid()

Description copied from class: AbstractDatabase

Specified by:

supportsIsValid in interface Database

Overrides:

supportsIsValid in class AbstractDatabase

Returns:

false

getCheckConnectionQuery

public java.lang.String getCheckConnectionQuery()

Returns a query to use when checking if the connection is valid, this is used in cases where the dbms does not support the isValid() call. Returning null is safe if isValid() is supported.

Specified by:

getCheckConnectionQuery in interface Database

Overrides:

getCheckConnectionQuery in class AbstractDatabase

Returns:

a check connection query

See Also:

Database.supportsIsValid()