My repository on okm is about 25G.I\'m using windows 2003 and SQL server 2005. In repository.xml, I config simpleDBPersistManager followed doc on web. For a short time,I find system is too slow.
I saw the doc about Jackrabbit and found that Bundle Database PM with Data Store is much faster then simpleDbPM. I try to using this PM. So I change the repository.xml. But it\'s fail to deploy okm.
Could u tell me what\'s wrong in the repository.xml file.
Thank U!
<?xml version=\"1.0\" ?>
- <Repository>
- <DataStore class=\"org.apache.jackrabbit.core.data.db.DbDataStore\">
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"databaseType\" value=\"mssql\" />
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"minRecordLength\" value=\"1024\" />
<param name=\"maxConnections\" value=\"30\" />
<param name=\"copyWhenReading\" value=\"true\" />
<param name=\"tablePrefix\" value=\"\" />
<param name=\"schemaObjectPrefix\" value=\"\" />
</DataStore>
- <FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
<param name=\"path\" value=\"${rep.home}/repository\" />
</FileSystem>
- <Security appName=\"OpenKM\">
<AccessManager class=\"es.git.openkm.core.OKMAccessManager\" />
- <!-- <AccessManager class=\"org.apache.jackrabbit.core.security.SimpleAccessManager\"/>
-->
</Security>
<Workspaces rootPath=\"${rep.home}/workspaces\" defaultWorkspace=\"default\" />
- <Workspace name=\"${wsp.name}\">
- <FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"schema\" value=\"mssql\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"schemaObjectPrefix\" value=\"rep_\" />
</FileSystem>
- <PersistenceManager class=\"org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager\">
<param name=\"bundleCacheSize\" value=\"8\" />
<param name=\"consistencyCheck\" value=\"false\" />
<param name=\"minBlobSize\" value=\"16384\" />
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"schema\" value=\"mssql\" />
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\" />
<param name=\"errorHandling\" value=\"\" />
<param name=\"tableSpace\" value=\"\" />
</PersistenceManager>
- <SearchIndex class=\"org.apache.jackrabbit.core.query.lucene.SearchIndex\">
<param name=\"path\" value=\"${wsp.home}/index\" />
<param name=\"useCompoundFile\" value=\"true\" />
<param name=\"minMergeDocs\" value=\"100\" />
<param name=\"volatileIdleTime\" value=\"3\" />
<param name=\"maxMergeDocs\" value=\"100000\" />
<param name=\"mergeFactor\" value=\"10\" />
<param name=\"bufferSize\" value=\"10\" />
<param name=\"cacheSize\" value=\"1000\" />
<param name=\"forceConsistencyCheck\" value=\"false\" />
<param name=\"autoRepair\" value=\"true\" />
<param name=\"analyzer\" value=\"org.apache.lucene.analysis.standard.StandardAnalyzer\" />
<param name=\"respectDocumentOrder\" value=\"false\" />
<param name=\"indexingConfiguration\" value=\"${wsp.home}/../../../indexing_configuration.xml\" />
<param name=\"textFilterClasses\" value=\"org.apache.jackrabbit.core.query.lucene.TextPlainTextFilter, org.apache.jackrabbit.extractor.PdfTextExtractor, org.apache.jackrabbit.extractor.HTMLTextExtractor, org.apache.jackrabbit.extractor.XMLTextExtractor, org.apache.jackrabbit.extractor.RTFTextExtractor, org.apache.jackrabbit.extractor.OpenOfficeTextExtractor, es.git.openkm.extractor.MsExcelTextExtractor, es.git.openkm.extractor.MsPowerPointTextExtractor, es.git.openkm.extractor.MsWordTextExtractor, es.git.openkm.extractor.MsOffice2007TextExtractor, es.git.openkm.extractor.ExifTextExtractor, es.git.openkm.extractor.TiffTextExtractor, es.git.openkm.extractor.AudioTextExtractor\" />
</SearchIndex>
</Workspace>
- <Versioning rootPath=\"${rep.home}/version\">
- <FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"schema\" value=\"mssql\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"schemaObjectPrefix\" value=\"ver_rep_\" />
</FileSystem>
- <PersistenceManager class=\"org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager\">
<param name=\"bundleCacheSize\" value=\"8\" />
<param name=\"consistencyCheck\" value=\"false\" />
<param name=\"minBlobSize\" value=\"16384\" />
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"schema\" value=\"mssql\" />
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\" />
<param name=\"errorHandling\" value=\"\" />
<param name=\"tableSpace\" value=\"\" />
</PersistenceManager>
</Versioning>
</Repository>
I saw the doc about Jackrabbit and found that Bundle Database PM with Data Store is much faster then simpleDbPM. I try to using this PM. So I change the repository.xml. But it\'s fail to deploy okm.
Could u tell me what\'s wrong in the repository.xml file.
Thank U!
<?xml version=\"1.0\" ?>
- <Repository>
- <DataStore class=\"org.apache.jackrabbit.core.data.db.DbDataStore\">
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"databaseType\" value=\"mssql\" />
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"minRecordLength\" value=\"1024\" />
<param name=\"maxConnections\" value=\"30\" />
<param name=\"copyWhenReading\" value=\"true\" />
<param name=\"tablePrefix\" value=\"\" />
<param name=\"schemaObjectPrefix\" value=\"\" />
</DataStore>
- <FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
<param name=\"path\" value=\"${rep.home}/repository\" />
</FileSystem>
- <Security appName=\"OpenKM\">
<AccessManager class=\"es.git.openkm.core.OKMAccessManager\" />
- <!-- <AccessManager class=\"org.apache.jackrabbit.core.security.SimpleAccessManager\"/>
-->
</Security>
<Workspaces rootPath=\"${rep.home}/workspaces\" defaultWorkspace=\"default\" />
- <Workspace name=\"${wsp.name}\">
- <FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"schema\" value=\"mssql\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"schemaObjectPrefix\" value=\"rep_\" />
</FileSystem>
- <PersistenceManager class=\"org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager\">
<param name=\"bundleCacheSize\" value=\"8\" />
<param name=\"consistencyCheck\" value=\"false\" />
<param name=\"minBlobSize\" value=\"16384\" />
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"schema\" value=\"mssql\" />
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\" />
<param name=\"errorHandling\" value=\"\" />
<param name=\"tableSpace\" value=\"\" />
</PersistenceManager>
- <SearchIndex class=\"org.apache.jackrabbit.core.query.lucene.SearchIndex\">
<param name=\"path\" value=\"${wsp.home}/index\" />
<param name=\"useCompoundFile\" value=\"true\" />
<param name=\"minMergeDocs\" value=\"100\" />
<param name=\"volatileIdleTime\" value=\"3\" />
<param name=\"maxMergeDocs\" value=\"100000\" />
<param name=\"mergeFactor\" value=\"10\" />
<param name=\"bufferSize\" value=\"10\" />
<param name=\"cacheSize\" value=\"1000\" />
<param name=\"forceConsistencyCheck\" value=\"false\" />
<param name=\"autoRepair\" value=\"true\" />
<param name=\"analyzer\" value=\"org.apache.lucene.analysis.standard.StandardAnalyzer\" />
<param name=\"respectDocumentOrder\" value=\"false\" />
<param name=\"indexingConfiguration\" value=\"${wsp.home}/../../../indexing_configuration.xml\" />
<param name=\"textFilterClasses\" value=\"org.apache.jackrabbit.core.query.lucene.TextPlainTextFilter, org.apache.jackrabbit.extractor.PdfTextExtractor, org.apache.jackrabbit.extractor.HTMLTextExtractor, org.apache.jackrabbit.extractor.XMLTextExtractor, org.apache.jackrabbit.extractor.RTFTextExtractor, org.apache.jackrabbit.extractor.OpenOfficeTextExtractor, es.git.openkm.extractor.MsExcelTextExtractor, es.git.openkm.extractor.MsPowerPointTextExtractor, es.git.openkm.extractor.MsWordTextExtractor, es.git.openkm.extractor.MsOffice2007TextExtractor, es.git.openkm.extractor.ExifTextExtractor, es.git.openkm.extractor.TiffTextExtractor, es.git.openkm.extractor.AudioTextExtractor\" />
</SearchIndex>
</Workspace>
- <Versioning rootPath=\"${rep.home}/version\">
- <FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"schema\" value=\"mssql\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"schemaObjectPrefix\" value=\"ver_rep_\" />
</FileSystem>
- <PersistenceManager class=\"org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager\">
<param name=\"bundleCacheSize\" value=\"8\" />
<param name=\"consistencyCheck\" value=\"false\" />
<param name=\"minBlobSize\" value=\"16384\" />
<param name=\"driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />
<param name=\"url\" value=\"jdbc:sqlserver://192.168.168.38:1433;DatabaseName=OpenKM1;SelectMethod=Cursor;\" />
<param name=\"user\" value=\"sa\" />
<param name=\"password\" value=\"\" />
<param name=\"schema\" value=\"mssql\" />
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\" />
<param name=\"errorHandling\" value=\"\" />
<param name=\"tableSpace\" value=\"\" />
</PersistenceManager>
</Versioning>
</Repository>