fr.gouv.culture.sdx.utils.database
Class MSSQLDatabase

java.lang.Object
  extended by fr.gouv.culture.sdx.utils.AbstractSdxObject
      extended by fr.gouv.culture.sdx.utils.rdbms.JDBC
          extended by fr.gouv.culture.sdx.utils.rdbms.DataSourceComponentBacked
              extended by fr.gouv.culture.sdx.utils.database.AbstractJDBCDatabase
                  extended by fr.gouv.culture.sdx.utils.database.JDBCDatabase
                      extended by fr.gouv.culture.sdx.utils.database.MSSQLDatabase
All Implemented Interfaces:
Database, Describable, Encodable, Identifiable, Localizable, Saveable, SdxObject, org.apache.avalon.framework.configuration.Configurable, org.apache.avalon.framework.context.Contextualizable, org.apache.avalon.framework.logger.LogEnabled, org.apache.avalon.framework.service.Serviceable, org.apache.excalibur.xml.sax.XMLizable

public class MSSQLDatabase
extends JDBCDatabase

Created by Mobydoc. User: Vincent Leconte Date: 12/03/2008 Time: 17:30:24 To change this template use Options | File Templates.


Nested Class Summary
 
Nested classes/interfaces inherited from class fr.gouv.culture.sdx.utils.rdbms.JDBC
JDBC.QueryExecutor, JDBC.Template
 
Nested classes/interfaces inherited from interface fr.gouv.culture.sdx.utils.SdxObject
SdxObject.ConfigurationNode
 
Field Summary
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
           
 
Fields inherited from class fr.gouv.culture.sdx.utils.database.AbstractJDBCDatabase
_searchModes, COLUMN_PARAM_INDEX_FIELD_ID, COLUMN_PARAM_INDEX_FIELD_PROPERTY_NAME, COLUMN_PARAM_INDEX_FIELD_PROPERTY_VALUE
 
Fields inherited from class fr.gouv.culture.sdx.utils.rdbms.DataSourceComponentBacked
ATTRIBUTE_DSI, dbSelector, dsi
 
Fields inherited from class fr.gouv.culture.sdx.utils.rdbms.JDBC
tableName
 
Fields inherited from class fr.gouv.culture.sdx.utils.AbstractSdxObject
_configuration, _context, _description, _encoding, _id, _locale, _logger, _manager, _xmlizable_objects, _xmlLang, isToSaxInitialized
 
Fields inherited from interface fr.gouv.culture.sdx.utils.database.Database
CLASS_NAME_SUFFIX, DATABASE_DIR_PATH, PACKAGE_QUALNAME, SEARCH_MODE_AND, SEARCH_MODE_NOT, SEARCH_MODE_OR
 
Fields inherited from interface fr.gouv.culture.sdx.utils.Encodable
DEFAULT_ENCODING
 
Fields inherited from interface fr.gouv.culture.sdx.utils.save.Saveable
ALL_SAVE_ATTRIB, PATH_ATTRIB, SAVE_DIRECTORY_PARAM
 
Constructor Summary
MSSQLDatabase()
           
 
Method Summary
 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
 
Methods inherited from class fr.gouv.culture.sdx.utils.database.JDBCDatabase
getDatabaseDirectoryName, initVolatileObjectsToSax, optimize
 
Methods inherited from class fr.gouv.culture.sdx.utils.database.AbstractJDBCDatabase
addProperty, 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, update
 
Methods inherited from class fr.gouv.culture.sdx.utils.rdbms.DataSourceComponentBacked
finalize, getDataSourceComponent, releaseDataSourceComponent, service
 
Methods inherited from class fr.gouv.culture.sdx.utils.rdbms.JDBC
createTable, getTableName, handleUnsupportedTokens
 
Methods inherited from class fr.gouv.culture.sdx.utils.AbstractSdxObject
configureDescription, contextualize, enableLogging, getBaseAttributes, getConfiguration, getContext, getDescription, getEncoding, getId, getLocale, getLog, getServiceManager, getXmlLang, setDescription, setEncoding, setId, setLocale, setUpSdxObject, setUpSdxObject, setXmlLang, toSAX, verifyConfigurationResources
 
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface fr.gouv.culture.sdx.utils.SdxObject
getLog
 
Methods inherited from interface org.apache.avalon.framework.logger.LogEnabled
enableLogging
 
Methods inherited from interface org.apache.avalon.framework.context.Contextualizable
contextualize
 
Methods inherited from interface org.apache.avalon.framework.service.Serviceable
service
 
Methods inherited from interface fr.gouv.culture.sdx.utils.Identifiable
getId, setId
 
Methods inherited from interface fr.gouv.culture.sdx.utils.Describable
getDescription, setDescription
 
Methods inherited from interface fr.gouv.culture.sdx.utils.Encodable
getEncoding, setEncoding
 
Methods inherited from interface fr.gouv.culture.sdx.utils.Localizable
getLocale, getXmlLang, setLocale, setXmlLang
 
Methods inherited from interface org.apache.excalibur.xml.sax.XMLizable
toSAX
 

Field Detail

FIELD_ID

protected final java.lang.String FIELD_ID
See Also:
Constant Field Values

FIELD_PROPERTY_NAME

protected final java.lang.String FIELD_PROPERTY_NAME
See Also:
Constant Field Values

FIELD_PROPERTY_VALUE

protected final java.lang.String FIELD_PROPERTY_VALUE
See Also:
Constant Field Values

FIELD_KEY

protected final java.lang.String FIELD_KEY
See Also:
Constant Field Values
Constructor Detail

MSSQLDatabase

public MSSQLDatabase()
Method Detail

getTableCreationQuery

protected java.lang.String getTableCreationQuery()
Description copied from class: JDBC
Returns an SQL query that could create the table.

This query should not have any parameter.

Overrides:
getTableCreationQuery in class AbstractJDBCDatabase
Returns:
The query. see subclasses for implementation

initToSax

protected boolean initToSax()
Description copied from class: AbstractSdxObject
Init the LinkedHashMap _xmlizable_objects with the objects in order to describ them in XML

Overrides:
initToSax in class JDBCDatabase

backup

public void backup(SaveParameters save_config)
            throws SDXException
Save the database

Specified by:
backup in interface Saveable
Overrides:
backup in class AbstractJDBCDatabase
Throws:
SDXException
See Also:
Saveable.backup(fr.gouv.culture.sdx.utils.save.SaveParameters)

getEntriesWithLimitQuery

protected java.lang.String getEntriesWithLimitQuery(long offset,
                                                    long number)
Description copied from class: AbstractJDBCDatabase
Implementation of statement with a limit parameter

Overrides:
getEntriesWithLimitQuery in class JDBCDatabase
Returns:
the query
See Also:
MSSQL 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;

restore

public void restore(SaveParameters save_config)
             throws SDXException
Restore the database

Specified by:
restore in interface Saveable
Overrides:
restore in class AbstractJDBCDatabase
Throws:
SDXException
See Also:
Saveable.restore(fr.gouv.culture.sdx.utils.save.SaveParameters)


Copyright © 2000-2010 Ministere de la culture et de la communication / AJLSM. All Rights Reserved.