org.nuxeo.ecm.core.storage.sql

Class DatabaseHelper

java.lang.Object

org.nuxeo.ecm.core.storage.sql.DatabaseHelper

Direct Known Subclasses:

DatabaseDB2, DatabaseDerby, DatabaseH2, DatabaseMySQL, DatabaseOracle, DatabasePostgreSQL, DatabaseSQLServer

public abstract class DatabaseHelper
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
static DatabaseHelper	DATABASE
static String	DATABASE_PROPERTY
String	databaseName
static String	DB_CLASS_NAME_BASE
static String	DB_DEFAULT
static String	DB_PROPERTY
static String	DEF_ID_TYPE
static String	DEFAULT_DATABASE_NAME
static String	DEFAULT_REPOSITORY_NAME
static String	DRIVER_PROPERTY
static String	ID_TYPE_PROPERTY
static String	PASSWORD_PROPERTY
static String	PORT_PROPERTY
static String	REPOSITORY_PROPERTY
String	repositoryName
static String	SERVER_PROPERTY
static String	SINGLEDS_PROPERTY
static String	URL_PROPERTY
static String	USER_PROPERTY
static String	XA_DATASOURCE_PROPERTY

Constructor Summary

Constructors

Constructor and Description
DatabaseHelper()

Method Summary

Methods

Modifier and Type	Method and Description
static void	doOnAllTables(Connection connection, String catalog, String schemaPattern, String statement) Executes one statement on all the tables in a database.
static Connection	getConnection(String url, String user, String password) Gets a database connection, retrying if the server says it's overloaded.
abstract String	getDeploymentContrib()
int	getRecursiveRemovalDepthLimit() For databases that fail to cascade deletes beyond a certain depth.
abstract RepositoryDescriptor	getRepositoryDescriptor()
boolean	hasSubSecondResolution() For databases that don't have subsecond resolution, like MySQL.
void	maybeSleepToNextSecond() For databases that don't have subsecond resolution, sleep a bit to get to the next second.
static void	setBinaryManager(Class<? extends BinaryManager> binaryManagerClass, String key)
static void	setDatabaseForTests(String className) Sets the database backend used for VCS unit tests.
void	setDatabaseName(String name)
static String	setProperty(String name, String def)
static void	setRepositoryFactory(Class<? extends RepositoryFactory> factoryClass)
void	setRepositoryName(String name)
static void	setSingleDataSourceMode()
static String	setSystemProperty(String name, String def)
void	setUp()
void	setUp(Class<? extends RepositoryFactory> factoryClass)
void	sleepForFulltext() For databases that do asynchronous fulltext indexing, sleep a bit.
boolean	supportsArrayColumns()
boolean	supportsClustering() For databases that don't support clustering.
boolean	supportsMultipleFulltextIndexes()
boolean	supportsSequenceId() Whether this database supports "sequence" as an id type.
boolean	supportsSoftDelete()
boolean	supportsXA()
void	tearDown()

Methods inherited from class java.lang.Object

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

Field Detail

DB_PROPERTY

public static final String DB_PROPERTY

See Also:

Constant Field Values

DB_DEFAULT

public static final String DB_DEFAULT

See Also:

Constant Field Values

DEF_ID_TYPE

public static final String DEF_ID_TYPE

See Also:

Constant Field Values

DATABASE

public static DatabaseHelper DATABASE

DB_CLASS_NAME_BASE

public static final String DB_CLASS_NAME_BASE

See Also:

Constant Field Values

REPOSITORY_PROPERTY

public static final String REPOSITORY_PROPERTY

See Also:

Constant Field Values

DRIVER_PROPERTY

public static final String DRIVER_PROPERTY

See Also:

Constant Field Values

XA_DATASOURCE_PROPERTY

public static final String XA_DATASOURCE_PROPERTY

See Also:

Constant Field Values

URL_PROPERTY

public static final String URL_PROPERTY

See Also:

Constant Field Values

SERVER_PROPERTY

public static final String SERVER_PROPERTY

See Also:

Constant Field Values

PORT_PROPERTY

public static final String PORT_PROPERTY

See Also:

Constant Field Values

DATABASE_PROPERTY

public static final String DATABASE_PROPERTY

See Also:

Constant Field Values

USER_PROPERTY

public static final String USER_PROPERTY

See Also:

Constant Field Values

PASSWORD_PROPERTY

public static final String PASSWORD_PROPERTY

See Also:

Constant Field Values

ID_TYPE_PROPERTY

public static final String ID_TYPE_PROPERTY

See Also:

Constant Field Values

SINGLEDS_PROPERTY

public static final String SINGLEDS_PROPERTY

See Also:

Constant Field Values

DEFAULT_DATABASE_NAME

public static final String DEFAULT_DATABASE_NAME

See Also:

Constant Field Values

databaseName

public String databaseName

DEFAULT_REPOSITORY_NAME

public static final String DEFAULT_REPOSITORY_NAME

See Also:

Constant Field Values

repositoryName

public String repositoryName

Constructor Detail

DatabaseHelper

public DatabaseHelper()

Method Detail

setSystemProperty

public static String setSystemProperty(String name,
                       String def)

setProperty

public static String setProperty(String name,
                 String def)

setDatabaseName

public void setDatabaseName(String name)

setRepositoryName

public void setRepositoryName(String name)

setDatabaseForTests

public static void setDatabaseForTests(String className)

Sets the database backend used for VCS unit tests.

getConnection

public static Connection getConnection(String url,
                       String user,
                       String password)
                                throws SQLException

Gets a database connection, retrying if the server says it's overloaded.

Throws:

SQLException

Since:

5.9.3

doOnAllTables

public static void doOnAllTables(Connection connection,
                 String catalog,
                 String schemaPattern,
                 String statement)
                          throws SQLException

Executes one statement on all the tables in a database.

Throws:

SQLException

setUp

public void setUp(Class<? extends RepositoryFactory> factoryClass)
           throws Exception

Throws:

Exception

setUp

public void setUp()
           throws Exception

Throws:

Exception

tearDown

public void tearDown()
              throws SQLException

Throws:

SQLException

setRepositoryFactory

public static void setRepositoryFactory(Class<? extends RepositoryFactory> factoryClass)

setBinaryManager

public static void setBinaryManager(Class<? extends BinaryManager> binaryManagerClass,
                    String key)

getDeploymentContrib

public abstract String getDeploymentContrib()

getRepositoryDescriptor

public abstract RepositoryDescriptor getRepositoryDescriptor()

setSingleDataSourceMode

public static void setSingleDataSourceMode()

sleepForFulltext

public void sleepForFulltext()

For databases that do asynchronous fulltext indexing, sleep a bit.

maybeSleepToNextSecond

public void maybeSleepToNextSecond()

For databases that don't have subsecond resolution, sleep a bit to get to the next second.

hasSubSecondResolution

public boolean hasSubSecondResolution()

For databases that don't have subsecond resolution, like MySQL.

getRecursiveRemovalDepthLimit

public int getRecursiveRemovalDepthLimit()

For databases that fail to cascade deletes beyond a certain depth.

supportsClustering

public boolean supportsClustering()

For databases that don't support clustering.

supportsMultipleFulltextIndexes

public boolean supportsMultipleFulltextIndexes()

supportsXA

public boolean supportsXA()

supportsSoftDelete

public boolean supportsSoftDelete()

supportsSequenceId

public boolean supportsSequenceId()

Whether this database supports "sequence" as an id type.

Since:

5.9.3

supportsArrayColumns

public boolean supportsArrayColumns()