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

java.lang.Object
  org.nuxeo.ecm.core.storage.sql.DatabaseHelper

Direct Known Subclasses:

DatabaseDerby, DatabaseH2, DatabaseMySQL, DatabaseOracle, DatabasePostgreSQL, DatabaseSQLServer

public abstract class DatabaseHelper
extends java.lang.Object

Field Summary

static DatabaseHelper	DATABASE
static java.lang.String	DATABASE_PROPERTY
static java.lang.String	DB_CLASS_NAME_BASE
static java.lang.String	DB_DEFAULT
static java.lang.String	DB_PROPERTY
static java.lang.String	PASSWORD_PROPERTY
static java.lang.String	PORT_PROPERTY
static java.lang.String	SERVER_PROPERTY
static java.lang.String	URL_PROPERTY
static java.lang.String	USER_PROPERTY

Constructor Summary

DatabaseHelper()

Method Summary

static void	doOnAllTables(java.sql.Connection connection, java.lang.String catalog, java.lang.String schemaPattern, java.lang.String statement) Executes one statement on all the tables in a database.
abstract java.lang.String	getDeploymentContrib()
int	getRecursiveRemovalDepthLimit() For databases that fail to cascade deletes beyond a certain depth.
abstract RepositoryDescriptor	getRepositoryDescriptor()
void	maybeSleepToNextSecond() For databases that don't have subsecond resolution, sleep a bit to get to the next second.
static void	setDatabaseForTests(java.lang.String className) Sets the database backend used for VCS unit tests.
static java.lang.String	setProperty(java.lang.String name, java.lang.String def)
abstract void	setUp()
void	sleepForFulltext() For databases that do asynchronous fulltext indexing, sleep a bit.
boolean	supportsClustering() For databases that don't support clustering.
boolean	supportsMultipleFulltextIndexes()
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 java.lang.String DB_PROPERTY

See Also:

Constant Field Values

DB_DEFAULT

public static final java.lang.String DB_DEFAULT

See Also:

Constant Field Values

DATABASE

public static DatabaseHelper DATABASE

DB_CLASS_NAME_BASE

public static final java.lang.String DB_CLASS_NAME_BASE

See Also:

Constant Field Values

URL_PROPERTY

public static final java.lang.String URL_PROPERTY

See Also:

Constant Field Values

SERVER_PROPERTY

public static final java.lang.String SERVER_PROPERTY

See Also:

Constant Field Values

PORT_PROPERTY

public static final java.lang.String PORT_PROPERTY

See Also:

Constant Field Values

DATABASE_PROPERTY

public static final java.lang.String DATABASE_PROPERTY

See Also:

Constant Field Values

USER_PROPERTY

public static final java.lang.String USER_PROPERTY

See Also:

Constant Field Values

PASSWORD_PROPERTY

public static final java.lang.String PASSWORD_PROPERTY

See Also:

Constant Field Values

Constructor Detail

DatabaseHelper

public DatabaseHelper()

Method Detail

setProperty

public static java.lang.String setProperty(java.lang.String name,
                                           java.lang.String def)

setDatabaseForTests

public static void setDatabaseForTests(java.lang.String className)

Sets the database backend used for VCS unit tests.

doOnAllTables

public static void doOnAllTables(java.sql.Connection connection,
                                 java.lang.String catalog,
                                 java.lang.String schemaPattern,
                                 java.lang.String statement)
                          throws java.sql.SQLException

Executes one statement on all the tables in a database.

Throws:

java.sql.SQLException

setUp

public abstract void setUp()
                    throws java.lang.Exception

Throws:

java.lang.Exception

tearDown

public void tearDown()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

getDeploymentContrib

public abstract java.lang.String getDeploymentContrib()

getRepositoryDescriptor

public abstract RepositoryDescriptor getRepositoryDescriptor()

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.

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