jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Klimetschek (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (JCR-2702) How to store indexes in mssql database
Date Fri, 06 Aug 2010 08:14:16 GMT

     [ https://issues.apache.org/jira/browse/JCR-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alexander Klimetschek resolved JCR-2702.
----------------------------------------

    Resolution: Invalid

Please ask questions on the users mailing list: http://jackrabbit.apache.org/mailing-lists.html

> How to store indexes in mssql database
> --------------------------------------
>
>                 Key: JCR-2702
>                 URL: https://issues.apache.org/jira/browse/JCR-2702
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: indexing
>    Affects Versions: 1.6.0
>         Environment: JackRabbit 1.6.0
> Lucene 2.4.1
> JDK 6,
> Apache Tomcat 6_0_20
> MS SQL SERVER 2005
>            Reporter: Atul Tripathi
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> I am creating the jackrabbit repository programmatically instead of using xml configuration.
I am able to store my content (datasore) and versioning  information in MS SQL SERVER database
but indexes are still being stored in file system even though i pass FileSystemFactory (creates
org.apache.jackrabbit.core.fs.db.MSSqlFileSystem instance) in SearchConfig.
> Below is the code snippet:
> // Method to get FileSystemFactory  which creates instance of MSSqlFileSystem
> FileSystemFactory  getFileSystem() {
> ..........................
> .........................
> return new FileSystemFactory() {
>             public FileSystem getFileSystem() throws RepositoryException {
> Properties parameters = new Properties();
> parameters.put("url",getUrl());
> parameters.put("user", getUserName());
> parameters.put("password", getPassword());
> parameters.put("schema", mssql);
> parameters.put("driver", getDriver());
> parameters.put("schemaObjectPrefix", "JR_");
> String fileSystemClass = "org.apache.jackrabbit.core.fs.db.MSSqlFileSystem"
> BeanConfig config = new BeanConfig(fileSystemClass, parameters);
> FileSystem fileSystem = (FileSystem) config.newInstance();
> fileSystem.init();
> }
> }
> // Method to get SearchConfig
> SearchConfig getSearchConfig(FileSystemFactory  fileSystemFactory ) {
> String searchIndexClass = "org.apache.jackrabbit.core.query.lucene.SearchIndex";
> Properties params = new Properties();
> params.put("path", getIndexPath());
> params.put("textFilterClasses", .....................);
> params.put("analyzer", ....................);
> params.put("queryClass", ...............);
> ....................
> .......................
> return new SearchConfig(searchIndexClass , params, fileSystemFactory );
> }
> void createRepository(){
> FileSystemFactory   fileSystem = getFileSystem();
> searchConfig = getSearchConfig(fileSystem);
> RepositoryConfig repositoryConfig = new RepositoryConfig(repoPath, securityConfig, fileSystem,
workspaceDirectory,
>                 null, defaultWorkspace, maxIdleTime, wsElement, versioningConfig, searchConfig,
null, dataStoreFactory, LockMechanismFactory, repositoryConfigurationParser);
> repositoryConfig.init();
> JackrabbitRepository repository = RepositoryImpl.create(repositoryConfig);
> }
> Is this possible to store indexes in database using jackrabbit?
> Thanks,
> Atul Tripathi

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message