Class MSSqlPersistenceManager

  • All Implemented Interfaces:
    PersistenceManager, DatabaseAware

    public class MSSqlPersistenceManager
    extends SimpleDbPersistenceManager
    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: "")
    • 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="${}_"/>
           <param name="tableSpace" value=""/>
           <param name="externalBLOBs" value="false"/>
    • Field Detail


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

        protected String tableSpace
        the MSSql table space to use
    • Constructor Detail

      • MSSqlPersistenceManager

        public MSSqlPersistenceManager()
        Creates a new MSSqlPersistenceManager instance.
    • Method Detail

      • getTableSpace

        public String getTableSpace()
        Returns the configured MSSql table space.
        the configured MSSql table space.
      • setTableSpace

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