org.apache.jackrabbit.core.fs.db
Class MSSqlFileSystem

java.lang.Object
  org.apache.jackrabbit.core.fs.db.DatabaseFileSystem
      org.apache.jackrabbit.core.fs.db.DbFileSystem
          org.apache.jackrabbit.core.fs.db.MSSqlFileSystem

All Implemented Interfaces:

FileSystem

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>
 

Field Summary

static String	TABLE_SPACE_VARIABLE the variable for the MS SQL table space
protected String	tableSpace the MS SQL table space to use

Fields inherited from class org.apache.jackrabbit.core.fs.db.DbFileSystem

driver, password, url, user

Fields inherited from class org.apache.jackrabbit.core.fs.db.DatabaseFileSystem

con, copyFileSQL, copyFilesSQL, deleteFileSQL, deleteFolderSQL, INITIAL_BUFFER_SIZE, initialized, insertFileSQL, insertFolderSQL, schema, SCHEMA_OBJECT_PREFIX_VARIABLE, schemaObjectPrefix, selectChildCountSQL, selectDataSQL, selectExistSQL, selectFileAndFolderNamesSQL, selectFileExistSQL, selectFileNamesSQL, selectFolderExistSQL, selectFolderNamesSQL, selectLastModifiedSQL, selectLengthSQL, SLEEP_BEFORE_RECONNECT, updateDataSQL, updateLastModifiedSQL

Fields inherited from interface org.apache.jackrabbit.core.fs.FileSystem

SEPARATOR, SEPARATOR_CHAR

Constructor Summary

MSSqlFileSystem()
Creates a new MSSqlFileSystem instance.

Method Summary

protected String	createSchemaSql(String sql) Replace wildcards.
String	getTableSpace() Returns the configured MS SQL table space.
void	setTableSpace(String tableSpace) Sets the MS SQL table space.

Methods inherited from class org.apache.jackrabbit.core.fs.db.DbFileSystem

equals, getConnection, getDriver, getPassword, getUrl, getUser, hashCode, setDriver, setPassword, setUrl, setUser

Methods inherited from class org.apache.jackrabbit.core.fs.db.DatabaseFileSystem

buildSQLStatements, checkSchema, close, closeConnection, closeResultSet, closeStatement, copy, copyDeepFolder, copyFile, createDeepFolder, createFolder, deleteFile, deleteFolder, executeStmt, exists, getInputStream, getOutputStream, getRandomAccessOutputStream, getSchema, getSchemaObjectPrefix, hasChildren, init, initConnection, initPreparedStatements, isFile, isFolder, isSchemaCheckEnabled, lastModified, length, list, listFiles, listFolders, move, prepareSchemaObjectPrefix, reestablishConnection, resetStatement, setSchema, setSchemaCheckEnabled, setSchemaObjectPrefix, touch, verifyRootExists

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, toString, wait, wait, wait

Field Detail

TABLE_SPACE_VARIABLE

public static final String TABLE_SPACE_VARIABLE

the variable for the MS SQL table space

See Also:

Constant Field Values

tableSpace

protected String tableSpace

the MS SQL table space to use

Constructor Detail

MSSqlFileSystem

public MSSqlFileSystem()

Creates a new MSSqlFileSystem instance.

Method Detail

getTableSpace

public String getTableSpace()

Returns the configured MS SQL table space.

Returns:

the configured MS SQL table space.

setTableSpace

public void setTableSpace(String tableSpace)

Sets the MS SQL table space.

Parameters:

tableSpace - the MS SQL table space.

createSchemaSql

protected String createSchemaSql(String sql)

Description copied from class: DatabaseFileSystem

Replace wildcards.

Overrides:

createSchemaSql in class DatabaseFileSystem