org.jminor.dbms.oracle

Class OracleDatabase

java.lang.Object

org.jminor.common.db.AbstractDatabase

org.jminor.dbms.oracle.OracleDatabase

All Implemented Interfaces:

Database

public final class OracleDatabase
extends AbstractDatabase

A Database implementation based on the Oracle 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
OracleDatabase() Instantiates a new OracleDatabase.
OracleDatabase(java.lang.String host, java.lang.Integer port, java.lang.String sid) Instantiates a new OracleDatabase.

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	getErrorMessage(java.sql.SQLException exception) Returns a user friendly error message for the given exception, otherwise simply return the message from exception
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, 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

OracleDatabase

public OracleDatabase()

Instantiates a new OracleDatabase.

OracleDatabase

public OracleDatabase(java.lang.String host,
                      java.lang.Integer port,
                      java.lang.String sid)

Instantiates a new OracleDatabase.

Parameters:

host - the host name

port - the port number

sid - the service identifier

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

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()

getErrorMessage

public java.lang.String getErrorMessage(java.sql.SQLException exception)

Returns a user friendly error message for the given exception, otherwise simply return the message from exception

Specified by:

getErrorMessage in interface Database

Overrides:

getErrorMessage in class AbstractDatabase

Parameters:

exception - the underlying SQLException

Returns:

the message assigned to the given exception

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