Failed to access to MS SQL Server 2005 Express

[fredjiang]

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

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>

[pavila]

Sorry but never tested with this database. You should visit Jackrabbit wiki / forum for more info.