public class MSSQLDatabase extends JDBCDatabase
JDBC.QueryExecutor, JDBC.TemplateSdxObject.ConfigurationNode| Modifier and Type | Field and Description |
|---|---|
protected java.lang.String |
FIELD_ID |
protected java.lang.String |
FIELD_KEY |
protected java.lang.String |
FIELD_PROPERTY_NAME |
protected java.lang.String |
FIELD_PROPERTY_VALUE |
_searchModes, COLUMN_PARAM_INDEX_FIELD_ID, COLUMN_PARAM_INDEX_FIELD_PROPERTY_NAME, COLUMN_PARAM_INDEX_FIELD_PROPERTY_VALUEATTRIBUTE_DSI, dbSelector, dsi_configuration, _context, _description, _encoding, _id, _locale, _logger, _manager, _xmlizable_objects, _xmlLang, isToSaxInitializedCLASS_NAME_SUFFIX, DATABASE_DIR_PATH, PACKAGE_QUALNAME, SEARCH_MODE_AND, SEARCH_MODE_NOT, SEARCH_MODE_ORDEFAULT_ENCODINGALL_SAVE_ATTRIB, PATH_ATTRIB, SAVE_DIRECTORY_PARAM| Constructor and Description |
|---|
MSSQLDatabase() |
| Modifier and Type | Method and Description |
|---|---|
void |
backup(SaveParameters save_config)
Save the database
|
protected java.lang.String |
getEntriesWithLimitQuery(long offset,
long number)
Implementation of statement with a limit parameter
|
protected java.lang.String |
getTableCreationQuery()
Returns an SQL query that could create the table.
|
protected boolean |
initToSax()
Init the LinkedHashMap _xmlizable_objects with the objects in order to describ them in XML
|
void |
restore(SaveParameters save_config)
Restore the database
|
getDatabaseDirectoryName, initVolatileObjectsToSax, optimizeaddProperty, configure, createIndicies, delete, delete, empty, entityExists, getAllEntitiesQuery, getClassNameSuffix, getConnection, getCreateIndiciesQuery, getDeleteAllQuery, getEntities, getEntities, getEntity, getEntity, getEntityDeleteQuery, getEntityGetQuery, getEntityIds, getProperties, getPropertyAddQuery, getPropertyRemoveQueryWithId, getPropertyRemoveQueryWithoutId, getPropertyValue, getPropertyValues, getWildcardSearchToken, init, releaseConnection, removeProperty, removeProperty, save, search, search, searchWithParams, size, updatefinalize, getDataSourceComponent, releaseDataSourceComponent, servicecreateTable, getTableName, handleUnsupportedTokensconfigureDescription, contextualize, enableLogging, getBaseAttributes, getConfiguration, getContext, getDescription, getEncoding, getId, getLocale, getLog, getServiceManager, getXmlLang, setDescription, setEncoding, setId, setLocale, setUpSdxObject, setUpSdxObject, setXmlLang, toSAX, verifyConfigurationResourcesclone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitgetId, setIdgetDescription, setDescriptiongetEncoding, setEncodinggetLocale, getXmlLang, setLocale, setXmlLangprotected final java.lang.String FIELD_ID
protected final java.lang.String FIELD_PROPERTY_NAME
protected final java.lang.String FIELD_PROPERTY_VALUE
protected final java.lang.String FIELD_KEY
protected java.lang.String getTableCreationQuery()
JDBCThis query should not have any parameter.
getTableCreationQuery in class AbstractJDBCDatabaseprotected boolean initToSax()
AbstractSdxObjectinitToSax in class JDBCDatabasepublic void backup(SaveParameters save_config) throws SDXException
backup in interface Saveablebackup in class AbstractJDBCDatabaseSDXExceptionSaveable.backup(fr.gouv.culture.sdx.utils.save.SaveParameters)protected java.lang.String getEntriesWithLimitQuery(long offset,
long number)
AbstractJDBCDatabasegetEntriesWithLimitQuery in class JDBCDatabaseMSSQL implementation (un peu lourd mais LIMIT existe pas en MSSQL)
SELECT * FROM
(SELECT TOP >number< id, propertyName, propertyValue, sdx_key FROM
(SELECT TOP >number + offset< id, propertyName, propertyValue, sdx_key FROM >table_name< ORDER BY sdx_key asc)
AS tbl1 ORDER BY sdx_key desc)
AS tbl2 ORDR BY sdx_key asc;public void restore(SaveParameters save_config) throws SDXException
restore in interface Saveablerestore in class AbstractJDBCDatabaseSDXExceptionSaveable.restore(fr.gouv.culture.sdx.utils.save.SaveParameters)Copyright © 2000-2010 Ministere de la culture et de la communication / AJLSM. All Rights Reserved.