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

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

All Implemented Interfaces:

FileSystem

Direct Known Subclasses:

DbFileSystem, JNDIDatabaseFileSystem

public class DatabaseFileSystem
extends java.lang.Object
implements FileSystem

Base class for database file systems. This class contains common functionality for database file system subclasses that normally differ only in the way the database connection is acquired. Subclasses should override the getConnection() method to return the configured database connection.

See the DbFileSystem for a detailed description of the available configuration options and database behaviour.

Field Summary

protected java.sql.Connection	con
protected java.lang.String	copyFileSQL
protected java.lang.String	copyFilesSQL
protected java.lang.String	deleteFileSQL
protected java.lang.String	deleteFolderSQL
protected static int	INITIAL_BUFFER_SIZE
protected boolean	initialized
protected java.lang.String	insertFileSQL
protected java.lang.String	insertFolderSQL
protected java.lang.String	schema
protected static java.lang.String	SCHEMA_OBJECT_PREFIX_VARIABLE
protected java.lang.String	schemaObjectPrefix
protected java.lang.String	selectChildCountSQL
protected java.lang.String	selectDataSQL
protected java.lang.String	selectExistSQL
protected java.lang.String	selectFileAndFolderNamesSQL
protected java.lang.String	selectFileExistSQL
protected java.lang.String	selectFileNamesSQL
protected java.lang.String	selectFolderExistSQL
protected java.lang.String	selectFolderNamesSQL
protected java.lang.String	selectLastModifiedSQL
protected java.lang.String	selectLengthSQL
protected static int	SLEEP_BEFORE_RECONNECT
protected java.lang.String	updateDataSQL
protected java.lang.String	updateLastModifiedSQL

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

SEPARATOR, SEPARATOR_CHAR

Constructor Summary

DatabaseFileSystem()
Default constructor

Method Summary

protected void	buildSQLStatements() Builds the SQL statements
protected void	checkSchema() Checks if the required schema objects exist and creates them if they don't exist yet.
void	close() Close the file system.
protected void	closeConnection(java.sql.Connection connection) Closes the given database connection.
protected void	closeResultSet(java.sql.ResultSet rs)
protected void	closeStatement(java.sql.Statement stmt)
void	copy(java.lang.String srcPath, java.lang.String destPath) Copies a file or folder to a new location.
protected void	copyDeepFolder(java.lang.String srcPath, java.lang.String destPath) Recursively copies the given folder to the given destination.
protected void	copyFile(java.lang.String srcPath, java.lang.String destPath) Copies the given file entry to the given destination path.
protected void	createDeepFolder(java.lang.String folderPath) Creates the specified files system folder entry, recursively creating any non-existing intermediate folder entries.
void	createFolder(java.lang.String folderPath) Creates the folder named by this path, including any necessary but nonexistent parent folders.
void	deleteFile(java.lang.String filePath) Deletes the file denoted by this path.
void	deleteFolder(java.lang.String folderPath) Deletes the folder denoted by this path.
boolean	equals(java.lang.Object obj)
protected java.sql.Statement	executeStmt(java.lang.String sql, java.lang.Object[] params) Executes the given SQL statement with the specified parameters.
boolean	exists(java.lang.String path) Tests whether the file system entry denoted by this path exists.
protected java.sql.Connection	getConnection() Abstract factory method for creating a new database connection.
java.io.InputStream	getInputStream(java.lang.String filePath) Returns an input stream of the contents of the file denoted by this path.
java.io.OutputStream	getOutputStream(java.lang.String filePath) Returns an output stream for writing bytes to the file denoted by this path.
RandomAccessOutputStream	getRandomAccessOutputStream(java.lang.String filePath) Returns an output stream for writing bytes to the file denoted by this path.
java.lang.String	getSchema()
java.lang.String	getSchemaObjectPrefix()
boolean	hasChildren(java.lang.String path) Tests whether the file system entry denoted by this path has child entries.
int	hashCode() Returns zero to satisfy the Object equals/hashCode contract.
void	init() Initialize the file system
protected void	initConnection() Initializes the database connection used by this file system.
protected void	initPreparedStatements() Initializes the map of prepared statements.
boolean	isFile(java.lang.String path) Tests whether the file system entry denoted by this path exists and is a file.
boolean	isFolder(java.lang.String path) Tests whether the file system entry denoted by this path exists and is a folder.
long	lastModified(java.lang.String path) Returns the time that the file system entry denoted by this path was last modified.
long	length(java.lang.String filePath) Returns the length of the file denoted by this path.
java.lang.String[]	list(java.lang.String folderPath) Returns an array of strings naming the files and folders in the folder denoted by this path.
java.lang.String[]	listFiles(java.lang.String folderPath) Returns an array of strings naming the files in the folder denoted by this path.
java.lang.String[]	listFolders(java.lang.String folderPath) Returns an array of strings naming the folders in the folder denoted by this path.
void	move(java.lang.String srcPath, java.lang.String destPath) Moves a file or folder to a new location.
protected void	prepareSchemaObjectPrefix() Makes sure that schemaObjectPrefix does only consist of characters that are allowed in names on the target database.
protected boolean	reestablishConnection() Re-establishes the database connection.
protected void	resetStatement(java.sql.PreparedStatement stmt) Resets the given PreparedStatement by clearing the parameters and warnings contained.
void	setSchema(java.lang.String schema)
void	setSchemaObjectPrefix(java.lang.String schemaObjectPrefix)
void	touch(java.lang.String filePath) Set the modified time of an existing file to now.
protected void	verifyRootExists() Verifies that the root file system entry exists.

Methods inherited from class java.lang.Object

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

Field Detail

SCHEMA_OBJECT_PREFIX_VARIABLE

protected static final java.lang.String SCHEMA_OBJECT_PREFIX_VARIABLE

See Also:

Constant Field Values

initialized

protected boolean initialized

schema

protected java.lang.String schema

schemaObjectPrefix

protected java.lang.String schemaObjectPrefix

INITIAL_BUFFER_SIZE

protected static final int INITIAL_BUFFER_SIZE

See Also:

Constant Field Values

con

protected java.sql.Connection con

SLEEP_BEFORE_RECONNECT

protected static final int SLEEP_BEFORE_RECONNECT

See Also:

Constant Field Values

selectExistSQL

protected java.lang.String selectExistSQL

selectFileExistSQL

protected java.lang.String selectFileExistSQL

selectFolderExistSQL

protected java.lang.String selectFolderExistSQL

selectChildCountSQL

protected java.lang.String selectChildCountSQL

selectDataSQL

protected java.lang.String selectDataSQL

selectLastModifiedSQL

protected java.lang.String selectLastModifiedSQL

selectLengthSQL

protected java.lang.String selectLengthSQL

selectFileNamesSQL

protected java.lang.String selectFileNamesSQL

selectFolderNamesSQL

protected java.lang.String selectFolderNamesSQL

selectFileAndFolderNamesSQL

protected java.lang.String selectFileAndFolderNamesSQL

deleteFileSQL

protected java.lang.String deleteFileSQL

deleteFolderSQL

protected java.lang.String deleteFolderSQL

insertFileSQL

protected java.lang.String insertFileSQL

insertFolderSQL

protected java.lang.String insertFolderSQL

updateDataSQL

protected java.lang.String updateDataSQL

updateLastModifiedSQL

protected java.lang.String updateLastModifiedSQL

copyFileSQL

protected java.lang.String copyFileSQL

copyFilesSQL

protected java.lang.String copyFilesSQL

Constructor Detail

DatabaseFileSystem

public DatabaseFileSystem()

Default constructor

Method Detail

getSchemaObjectPrefix

public java.lang.String getSchemaObjectPrefix()

setSchemaObjectPrefix

public void setSchemaObjectPrefix(java.lang.String schemaObjectPrefix)

getSchema

public java.lang.String getSchema()

setSchema

public void setSchema(java.lang.String schema)

equals

public boolean equals(java.lang.Object obj)

Overrides:

equals in class java.lang.Object

hashCode

public int hashCode()

Returns zero to satisfy the Object equals/hashCode contract. This class is mutable and not meant to be used as a hash key.

Overrides:

hashCode in class java.lang.Object

Returns:

always zero

See Also:

Object.hashCode()

init

public void init()
          throws FileSystemException

Initialize the file system

Specified by:

init in interface FileSystem

Throws:

FileSystemException - if the file system initialization fails

close

public void close()
           throws FileSystemException

Close the file system. After calling this method, the file system is no longer accessible.

Specified by:

close in interface FileSystem

Throws:

FileSystemException

createFolder

public void createFolder(java.lang.String folderPath)
                  throws FileSystemException

Creates the folder named by this path, including any necessary but nonexistent parent folders. Note that if this operation fails it may have succeeded in creating some of the necessary parent folders.

Specified by:

createFolder in interface FileSystem

Parameters:

folderPath - the path of the folder to be created.

Throws:

FileSystemException - if a file system entry denoted by path already exists or if another error occurs.

deleteFile

public void deleteFile(java.lang.String filePath)
                throws FileSystemException

Deletes the file denoted by this path.

Specified by:

deleteFile in interface FileSystem

Parameters:

filePath - the path of the file to be deleted.

Throws:

FileSystemException - if this path does not denote a file or if another error occurs.

deleteFolder

public void deleteFolder(java.lang.String folderPath)
                  throws FileSystemException

Deletes the folder denoted by this path. Any contents of this folder (folders and files) will be deleted recursively.

Specified by:

deleteFolder in interface FileSystem

Parameters:

folderPath - the path of the folder to be deleted.

Throws:

FileSystemException - if this path does not denote a folder or if another error occurs.

exists

public boolean exists(java.lang.String path)
               throws FileSystemException

Tests whether the file system entry denoted by this path exists.

Specified by:

exists in interface FileSystem

Parameters:

path - the path of a file system entry.

Returns:

true if the file system entry at path exists; false otherwise.

Throws:

FileSystemException

isFile

public boolean isFile(java.lang.String path)
               throws FileSystemException

Tests whether the file system entry denoted by this path exists and is a file.

Specified by:

isFile in interface FileSystem

Parameters:

path - the path of a file system entry.

Returns:

true if the file system entry at path is a file; false otherwise.

Throws:

FileSystemException

isFolder

public boolean isFolder(java.lang.String path)
                 throws FileSystemException

Tests whether the file system entry denoted by this path exists and is a folder.

Specified by:

isFolder in interface FileSystem

Parameters:

path - the path of a file system entry.

Returns:

true if the file system entry at path is a folder; false otherwise.

Throws:

FileSystemException

lastModified

public long lastModified(java.lang.String path)
                  throws FileSystemException

Returns the time that the file system entry denoted by this path was last modified.

Specified by:

lastModified in interface FileSystem

Parameters:

path - the path of a file system entry.

Returns:

A long value representing the time the file system entry was last modified, measured in milliseconds since the epoch (00:00:00 GMT, January 1, 1970), or 0L if the modification time can't be determined.

Throws:

FileSystemException - if the file system entry does not exist.

length

public long length(java.lang.String filePath)
            throws FileSystemException

Returns the length of the file denoted by this path.

Specified by:

length in interface FileSystem

Parameters:

filePath - the path of the file.

Returns:

The length, in bytes, of the file denoted by this path, or -1L if the length can't be determined.

Throws:

FileSystemException - if the path does not denote an existing file.

hasChildren

public boolean hasChildren(java.lang.String path)
                    throws FileSystemException

Tests whether the file system entry denoted by this path has child entries.

Specified by:

hasChildren in interface FileSystem

Parameters:

path - the path of a file system entry.

Returns:

true if the file system entry at path has child entries; false otherwise.

Throws:

FileSystemException

list

public java.lang.String[] list(java.lang.String folderPath)
                        throws FileSystemException

Returns an array of strings naming the files and folders in the folder denoted by this path.

Specified by:

list in interface FileSystem

Parameters:

folderPath - the path of the folder whose contents is to be listed.

Returns:

an array of strings naming the files and folders in the folder denoted by this path.

Throws:

FileSystemException - if this path does not denote a folder or if another error occurs.

listFiles

public java.lang.String[] listFiles(java.lang.String folderPath)
                             throws FileSystemException

Returns an array of strings naming the files in the folder denoted by this path.

Specified by:

listFiles in interface FileSystem

Parameters:

folderPath - the path of the folder whose contents is to be listed.

Returns:

an array of strings naming the files in the folder denoted by this path.

Throws:

FileSystemException - if this path does not denote a folder or if another error occurs.

listFolders

public java.lang.String[] listFolders(java.lang.String folderPath)
                               throws FileSystemException

Returns an array of strings naming the folders in the folder denoted by this path.

Specified by:

listFolders in interface FileSystem

Parameters:

folderPath - the path of the folder whose contents is to be listed.

Returns:

an array of strings naming the folders in the folder denoted by this path.

Throws:

FileSystemException - if this path does not denote a folder or if another error occurs.

touch

public void touch(java.lang.String filePath)
           throws FileSystemException

Set the modified time of an existing file to now.

Specified by:

touch in interface FileSystem

Parameters:

filePath - the path of the file.

Throws:

FileSystemException - if the path does not denote an existing file.

getInputStream

public java.io.InputStream getInputStream(java.lang.String filePath)
                                   throws FileSystemException

Returns an input stream of the contents of the file denoted by this path.

Specified by:

getInputStream in interface FileSystem

Parameters:

filePath - the path of the file.

Returns:

an input stream of the contents of the file.

Throws:

FileSystemException - if the file does not exist or if it cannot be read from

getOutputStream

public java.io.OutputStream getOutputStream(java.lang.String filePath)
                                     throws FileSystemException

Returns an output stream for writing bytes to the file denoted by this path. The file will be created if it doesn't exist. If the file exists, its contents will be overwritten.

Specified by:

getOutputStream in interface FileSystem

Parameters:

filePath - the path of the file.

Returns:

an output stream for writing bytes to the file.

Throws:

FileSystemException - if the file cannot be written to or created

getRandomAccessOutputStream

public RandomAccessOutputStream getRandomAccessOutputStream(java.lang.String filePath)
                                                     throws FileSystemException,
                                                            java.lang.UnsupportedOperationException

Returns an output stream for writing bytes to the file denoted by this path. The file will be created if it doesn't exist. The current position of the file pointer is set to 0. See also RandomAccessOutputStream.seek(long);

Specified by:

getRandomAccessOutputStream in interface FileSystem

Parameters:

filePath - the path of the file.

Returns:

an random access output stream for writing bytes to the file.

Throws:

FileSystemException - if the file could not be created or if the output stream cannot be obtained.

java.lang.UnsupportedOperationException - if the implementation does not support file access through a RandomAccessOutputStream.

copy

public void copy(java.lang.String srcPath,
                 java.lang.String destPath)
          throws FileSystemException

Copies a file or folder to a new location.

Specified by:

copy in interface FileSystem

Parameters:

srcPath - the path of the file or folder to be copied.

destPath - the destination path to which the file or folder is to be copied.

Throws:

FileSystemException - if the copy fails

move

public void move(java.lang.String srcPath,
                 java.lang.String destPath)
          throws FileSystemException

Moves a file or folder to a new location.

Specified by:

move in interface FileSystem

Parameters:

srcPath - the path of the file or folder to be moved.

destPath - the destination path to which the file or folder is to be moved.

Throws:

FileSystemException - if the move fails

initConnection

protected void initConnection()
                       throws java.lang.Exception

Initializes the database connection used by this file system.

Subclasses should normally override the getConnection() method instead of this one. The default implementation calls getConnection() to get the database connection and disables the autocommit feature.

Throws:

java.lang.Exception - if an error occurs

getConnection

protected java.sql.Connection getConnection()
                                     throws java.lang.Exception

Abstract factory method for creating a new database connection. This method is called by initConnection() when the file system is started. The returned connection should come with the default JDBC settings, as the initConnection() method will explicitly set the autoCommit and other properties as needed.

Note that the returned database connection is kept during the entire lifetime of the file system, after which it is closed by close() using the closeConnection(Connection) method.

Returns:

new connection

Throws:

java.lang.Exception - if an error occurs

closeConnection

protected void closeConnection(java.sql.Connection connection)
                        throws java.sql.SQLException

Closes the given database connection. This method is called by close() to close the connection acquired using getConnection() when the file system was started.

The default implementation just calls the Connection.close() method of the given connection, but subclasses can override this method to provide more extensive database and connection cleanup.

Parameters:

connection - database connection

Throws:

java.sql.SQLException - if an error occurs

reestablishConnection

protected boolean reestablishConnection()

Re-establishes the database connection. This method is called by executeStmt(String, Object[]) after a SQLException had been encountered.

Returns:

true if the connection could be successfully re-established, false otherwise.

executeStmt

protected java.sql.Statement executeStmt(java.lang.String sql,
                                         java.lang.Object[] params)
                                  throws java.sql.SQLException

Executes the given SQL statement with the specified parameters. If a SQLException is encountered one attempt is made to re-establish the database connection and re-execute the statement.

Parameters:

sql - statement to execute

params - parameters to set

Returns:

the Statement object that had been executed

Throws:

java.sql.SQLException - if an error occurs

prepareSchemaObjectPrefix

protected void prepareSchemaObjectPrefix()
                                  throws java.lang.Exception

Makes sure that schemaObjectPrefix does only consist of characters that are allowed in names on the target database. Illegal characters will be escaped as necessary.

Throws:

java.lang.Exception - if an error occurs

checkSchema

protected void checkSchema()
                    throws java.lang.Exception

Checks if the required schema objects exist and creates them if they don't exist yet.

Throws:

java.lang.Exception - if an error occurs

buildSQLStatements

protected void buildSQLStatements()

Builds the SQL statements

initPreparedStatements

protected void initPreparedStatements()
                               throws java.sql.SQLException

Initializes the map of prepared statements.

Throws:

java.sql.SQLException - if an error occurs

verifyRootExists

protected void verifyRootExists()
                         throws java.lang.Exception

Verifies that the root file system entry exists. If it doesn't exist yet it will be automatically created.

Throws:

java.lang.Exception - if an error occurs

createDeepFolder

protected void createDeepFolder(java.lang.String folderPath)
                         throws FileSystemException

Creates the specified files system folder entry, recursively creating any non-existing intermediate folder entries.

Parameters:

folderPath - folder entry to create

Throws:

FileSystemException - if an error occurs

copyDeepFolder

protected void copyDeepFolder(java.lang.String srcPath,
                              java.lang.String destPath)
                       throws FileSystemException

Recursively copies the given folder to the given destination.

Parameters:

srcPath - folder to be copied

destPath - destination path to which the folder is to be copied

Throws:

FileSystemException - if an error occurs

copyFile

protected void copyFile(java.lang.String srcPath,
                        java.lang.String destPath)
                 throws FileSystemException

Copies the given file entry to the given destination path. The parent folder of the destination path will be created if it doesn't exist already. If the destination path refers to an existing file, the file will be overwritten.

Parameters:

srcPath - file to be copied

destPath - destination path to which the file is to be copied

Throws:

FileSystemException - if an error occurs

resetStatement

protected void resetStatement(java.sql.PreparedStatement stmt)

Resets the given PreparedStatement by clearing the parameters and warnings contained.

NOTE: This method MUST be called in a synchronized context as neither this method nor the PreparedStatement instance on which it operates are thread safe.

Parameters:

stmt - The PreparedStatement to reset. If null this method does nothing.

closeResultSet

protected void closeResultSet(java.sql.ResultSet rs)

closeStatement

protected void closeStatement(java.sql.Statement stmt)