I want to configure Apache JackRabbit in such a way that all metadata should be stored in a MyQSL database and files associated with that metadata to be stored in the file system.
Use case: I will get some files in Pdf/Word format and the user will also send properties like author, topic etc.. for these files. I want to store those properties in a database and the actual file in the filesystem.
My question is: is it possible to do so?
If yes: How do I configure it?
Since version 1.4, Apache Jackrabbit defines the concept of a Data Store, i.e. a separate storage for binary properties. You can define a Data Store in the repository.xml file. Further details about the Data Store are in this wiki page.
In particular, you would like to define your Data Store as an instance of org.apache.jackrabbit.core.data.FileDataStore. The aforementioned wiki page contains an example configuration for this implementation of Data Store.