Failed to access to MS SQL Server 2005 Express
PostPosted:Tue Mar 24, 2009 4:56 am
Hello :
I had finished installation of OpenKM on Windows XP with MS SQL Server 2005 Express.
OpenKM is running well with default repository.xml.
But after I changed the repository.xml to connect MS SQL Server,I still got the error message \"File system initialization failure.: failed to initialize file system\" when I logged in.
my repository.xml as belows, Are there any mistakes? please give me some suggestion.
thanks a lot in advance.
Fred Jiang
I had finished installation of OpenKM on Windows XP with MS SQL Server 2005 Express.
OpenKM is running well with default repository.xml.
But after I changed the repository.xml to connect MS SQL Server,I still got the error message \"File system initialization failure.: failed to initialize file system\" when I logged in.
my repository.xml as belows, Are there any mistakes? please give me some suggestion.
thanks a lot in advance.
Fred Jiang
Code: Select all
<?xml version=\"1.0\"?>
<Repository>
<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.jdbc.sqlserver.SQLServerDriver\"/>
<param name=\"url\" value=\"jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=OpenKM;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.db.SimpleDbPersistenceManager\">
<param name=\"driver\" value=\"com.microsoft.jdbc.sqlserver.SQLServerDriver\"/>
<param name=\"url\" value=\"jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=OpenKM;SelectMethod=Cursor;\"/>
<param name=\"schema\" value=\"mssql\"/>
<param name=\"user\" value=\"sa\"/>
<param name=\"password\" value=\"\"/>
<param name=\"schemaObjectPrefix\" value=\"OKM_\"/>
<param name=\"externalBLOBs\" value=\"false\"/>
</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.jdbc.sqlserver.SQLServerDriver\"/>
<param name=\"url\" value=\"jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=OpenKM;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.db.SimpleDbPersistenceManager\">
<param name=\"driver\" value=\"com.microsoft.jdbc.sqlserver.SQLServerDriver\"/>
<param name=\"url\" value=\"jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=OpenKM;SelectMethod=Cursor;\"/>
<param name=\"schema\" value=\"mssql\"/>
<param name=\"user\" value=\"sa\"/>
<param name=\"password\" value=\"\"/>
<param name=\"schemaObjectPrefix\" value=\"OKM_\"/>
<param name=\"externalBLOBs\" value=\"false\"/>
</PersistenceManager>
</Versioning>
</Repository>