org.jminor.dbms.sqlserver

Class SQLServerDatabase

java.lang.Object

org.jminor.common.db.AbstractDatabase

org.jminor.dbms.sqlserver.SQLServerDatabase

All Implemented Interfaces:

Database

public final class SQLServerDatabase
extends AbstractDatabase

A Database implementation based on the SQL Server (2000 or higher) 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
SQLServerDatabase() Instantiates a new SQLServerDatabase.
SQLServerDatabase(java.lang.String host, java.lang.Integer port, java.lang.String databaseName) Instantiates a new SQLServerDatabase.

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	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	supportsNowait() Returns true if the dbms supports the select for update NOWAIT option
boolean	supportsSelectForUpdate()

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

addConnectionProperties, createConnection, getAuthenticationInfo, getCheckConnectionQuery, getDriverClassName, getErrorMessage, getHost, getLoginTimeout, getPort, getSequenceQuery, getSid, getType, getUrlAppend, isEmbedded, setUrlAppend, shutdownEmbedded, supportsIsValid

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

SQLServerDatabase

public SQLServerDatabase()

Instantiates a new SQLServerDatabase.

SQLServerDatabase

public SQLServerDatabase(java.lang.String host,
                         java.lang.Integer port,
                         java.lang.String databaseName)

Instantiates a new SQLServerDatabase.

Parameters:

host - the host name

port - the port number

databaseName - the database name

Method Detail

supportsSelectForUpdate

public boolean supportsSelectForUpdate()

Specified by:

supportsSelectForUpdate in interface Database

Overrides:

supportsSelectForUpdate in class AbstractDatabase

Returns:

true if the dbms supports the 'select for update' syntax

supportsNowait

public boolean supportsNowait()

Returns true if the dbms supports the select for update NOWAIT option

Specified by:

supportsNowait in interface Database

Overrides:

supportsNowait in class AbstractDatabase

Returns:

true if NOWAIT is supported for select for update

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

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