Class MSSqlFileSystem

  • All Implemented Interfaces:
    FileSystem, DatabaseAware

    public class MSSqlFileSystem
    extends DbFileSystem
    MSSqlFileSystem is a JDBC-based FileSystem implementation for Jackrabbit that persists file system entries in an MS SQL database.

    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:sqlserver://[host]:[port];<params>")
    • user: the database user
    • password: the user's password
    • schemaObjectPrefix: prefix to be prepended to schema objects
    • tableSpace: the tablespace to use
    See also DbFileSystem.

    The following is a fragment from a sample configuration:

       <FileSystem class="org.apache.jackrabbit.core.fs.db.MSSqlFileSystem">
           <param name="url" value="jdbc:sqlserver://localhost:1433"/>
           <param name="user" value="padv25"/>
           <param name="password" value="padv25"/>
           <param name="schemaObjectPrefix" value="rep_"/>
           <param name="tableSpace" value="default"/>
      </FileSystem>