Package org.jivesoftware.database

Enum Class DbConnectionManager.DatabaseType

java.lang.Object

java.lang.Enum<DbConnectionManager.DatabaseType>

org.jivesoftware.database.DbConnectionManager.DatabaseType

All Implemented Interfaces:

Serializable, Comparable<DbConnectionManager.DatabaseType>, Constable

Enclosing class:

DbConnectionManager

public static enum DbConnectionManager.DatabaseType
extends Enum<DbConnectionManager.DatabaseType>

A class that identifies the type of the database that Jive is connected to. In most cases, we don't want to make any database specific calls and have no need to know the type of database we're using. However, there are certain cases where it's critical to know the database for performance reasons.

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
db2
hsqldb
interbase
mysql
oracle
postgresql
sqlserver
unknown

Method Summary

Modifier and Type	Method	Description
String	escapeIdentifier(String keyword)
DbConnectionManager.ResultSetLimitKeyword	getResultSetLimitKeyword()	Returns the keyword or keyword phrase that should be used to limit result sets for this database type.
boolean	isResultSetLimitKeywordPrefix()	Indicates if the result-set limit keyword is used before the column list in a SELECT statement.
static DbConnectionManager.DatabaseType	valueOf(String name)	Returns the enum constant of this class with the specified name.
static DbConnectionManager.DatabaseType[]	values()	Returns an array containing the constants of this enum class, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

oracle

public static final DbConnectionManager.DatabaseType oracle

postgresql

public static final DbConnectionManager.DatabaseType postgresql

mysql

public static final DbConnectionManager.DatabaseType mysql

hsqldb

public static final DbConnectionManager.DatabaseType hsqldb

db2

public static final DbConnectionManager.DatabaseType db2

sqlserver

public static final DbConnectionManager.DatabaseType sqlserver

interbase

public static final DbConnectionManager.DatabaseType interbase

unknown

public static final DbConnectionManager.DatabaseType unknown

Method Details

values

public static DbConnectionManager.DatabaseType[] values()

Returns an array containing the constants of this enum class, in the order they are declared.

Returns:

an array containing the constants of this enum class, in the order they are declared

valueOf

public static DbConnectionManager.DatabaseType valueOf(String name)

Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum class has no constant with the specified name

NullPointerException - if the argument is null

escapeIdentifier

public String escapeIdentifier(String keyword)

getResultSetLimitKeyword

public DbConnectionManager.ResultSetLimitKeyword getResultSetLimitKeyword()

Returns the keyword or keyword phrase that should be used to limit result sets for this database type.

Returns:

the result-set limit keyword, or a sensible default when the database type is unknown.

See Also:

• OF-3277

isResultSetLimitKeywordPrefix

public boolean isResultSetLimitKeywordPrefix()

Indicates if the result-set limit keyword is used before the column list in a SELECT statement.

Returns:

true when the keyword is prefix-style (for example TOP), otherwise false.

See Also:

• OF-3277