org.apache.jackrabbit.core.persistence.db

Class MSSqlPersistenceManager

java.lang.Object

org.apache.jackrabbit.core.persistence.AbstractPersistenceManager

org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager

org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager

org.apache.jackrabbit.core.persistence.db.MSSqlPersistenceManager

All Implemented Interfaces:

PersistenceManager, DatabaseAware

Deprecated.

Please migrate to a bundle persistence manager (JCR-2802)

@Deprecated
public class MSSqlPersistenceManager
extends SimpleDbPersistenceManager

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 Summary

Fields

Modifier and Type	Field and Description
static String	TABLE_SPACE_VARIABLE Deprecated. the variable for the MSSql table space
protected String	tableSpace Deprecated. the MSSql table space to use

Fields inherited from class org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager

driver, password, url, user

Fields inherited from class org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager

autoReconnect, blobDeleteSQL, blobFS, blobInsertSQL, blobSelectExistSQL, blobSelectSQL, blobStore, blobUpdateSQL, con, externalBLOBs, INITIAL_BUFFER_SIZE, initialized, nodeReferenceDeleteSQL, nodeReferenceInsertSQL, nodeReferenceSelectExistSQL, nodeReferenceSelectSQL, nodeReferenceUpdateSQL, nodeStateDeleteSQL, nodeStateInsertSQL, nodeStateSelectExistSQL, nodeStateSelectSQL, nodeStateUpdateSQL, propertyStateDeleteSQL, propertyStateInsertSQL, propertyStateSelectExistSQL, propertyStateSelectSQL, propertyStateUpdateSQL, schema, SCHEMA_OBJECT_PREFIX_VARIABLE, schemaObjectPrefix, SLEEP_BEFORE_RECONNECT

Constructor Summary

Constructors

Constructor and Description
MSSqlPersistenceManager() Deprecated. Creates a new MSSqlPersistenceManager instance.

Method Summary

Modifier and Type	Method and Description
protected String	createSchemaSql(String sql) Deprecated. Replace wildcards and return the expanded SQL statement.
String	getTableSpace() Deprecated. Returns the configured MSSql table space.
void	setTableSpace(String tableSpace) Deprecated. Sets the MSSql table space.

Methods inherited from class org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager

getConnection, getDriver, getPassword, getUrl, getUser, setConnectionFactory, setDriver, setPassword, setUrl, setUser

Methods inherited from class org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager

buildSQLStatements, checkSchema, close, closeConnection, closeResultSet, closeStatement, destroy, destroy, destroy, executeStmt, exists, exists, existsReferencesTo, getSchema, getSchemaDDL, getSchemaObjectPrefix, init, initConnection, initPreparedStatements, isExternalBLOBs, isSchemaCheckEnabled, load, load, loadReferencesTo, logException, prepareSchemaObjectPrefix, reestablishConnection, resetStatement, setExternalBLOBs, setExternalBLOBs, setSchema, setSchemaCheckEnabled, setSchemaObjectPrefix, store, store, store, store

Methods inherited from class org.apache.jackrabbit.core.persistence.AbstractPersistenceManager

checkConsistency, createNew, createNew

Methods inherited from class java.lang.Object

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

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.

createSchemaSql

protected String createSchemaSql(String sql)

Deprecated.

Description copied from class: DatabasePersistenceManager

Replace wildcards and return the expanded SQL statement.

Overrides:

createSchemaSql in class DatabasePersistenceManager

Parameters:

sql - The SQL with embedded wildcards.

Returns:

The SQL with no wildcards present.