Package org.apache.jackrabbit.core.persistence.db

Class MSSqlPersistenceManager

  • All Implemented Interfaces:
    PersistenceManager, DatabaseAware
    @Deprecated
public class MSSqlPersistenceManager
extends SimpleDbPersistenceManager
    Deprecated.
    Please migrate to a bundle persistence manager (JCR-2802)
    MSSqlPersistenceManager is a JDBC-based PersistenceManager for Jackrabbit that persists ItemState and NodeReferences objects in MS SQL database using a simple custom serialization format and a very basic non-normalized database schema (in essence tables with one 'key' and one 'data' column).

    It is configured through the following properties:

    • driver: the FQN name of the JDBC driver class (default: "com.microsoft.sqlserver.jdbc.SQLServerDriver")
    • schema: type of schema to be used (default: "mssql")
    • url: the database url (e.g. "jdbc:microsoft:sqlserver://[host]:[port];databaseName=[dbname]")
    • user: the database user
    • password: the user's password
    • schemaObjectPrefix: prefix to be prepended to schema objects
    • tableSpace: the tablespace to use
    • externalBLOBs: if true (the default) BINARY values (BLOBs) are stored in the local file system; if false BLOBs are stored in the database
    See also SimpleDbPersistenceManager.

    The following is a fragment from a sample configuration: 

       <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.MSSqlPersistenceManager">
       <param name="url" value="jdbc:microsoft:sqlserver://localhost:1433;mydb"/>
       <param name="user" value="mydba"/>
       <param name="password" value="mydba"/>
       <param name="schemaObjectPrefix" value="${wsp.name}_"/>
       <param name="tableSpace" value=""/>
       <param name="externalBLOBs" value="false"/>
  </PersistenceManager>

    • Field Detail

      • TABLE_SPACE_VARIABLE

        public static final String TABLE_SPACE_VARIABLE
        Deprecated.
        the variable for the MSSql table space
        See Also:
        Constant Field Values

      • tableSpace

        protected String tableSpace
        Deprecated.
        the MSSql table space to use

    • Constructor Detail

      • MSSqlPersistenceManager

        public MSSqlPersistenceManager()
        Deprecated.
        Creates a new MSSqlPersistenceManager instance.

    • Method Detail

      • getTableSpace

        public String getTableSpace()
        Deprecated.
        Returns the configured MSSql table space.
        Returns:
        the configured MSSql table space.

      • setTableSpace

        public void setTableSpace​(String tableSpace)
        Deprecated.
        Sets the MSSql table space.
        Parameters:
        tableSpace - the MSSql table space.