Hola necesito un poco de ayuda, eh leido toda la documentacion que se encuentra en la pagina y aun no se como configurar de forma correcta el OpenKM para que funcione con el PostgreSQL, hasta el momento tengo esto en mi repository.xml
<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<Repository>
<!--<FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
<param name=\"path\" value=\"${rep.home}/repository\"></param>
</FileSystem> -->
<FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"org.postgresql.Driver\"></param>
<param name=\"url\" value=\"jdbc:postgresql://localhost:5432/test\"></param>
<param name=\"schema\" value=\"postgresql\"></param>
<param name=\"user\" value=\"test\"></param>
<param name=\"password\" value=\"test11\"></param>
<param name=\"schemaObjectPrefix\" value=\"rep_\"></param>
</FileSystem>
<Security appName=\"Jackrabbit\">
<AccessManager class=\"es.git.openkm.core.OKMAccessManager\"></AccessManager>
<!-- <AccessManager class=\"org.apache.jackrabbit.core.security.SimpleAccessManager\"/> -->
</Security>
<Workspaces rootPath=\"${rep.home}/workspaces\" defaultWorkspace=\"default\"></Workspaces>
<Workspace name=\"${wsp.name}\">
<FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"org.postgresql.Driver\"></param>
<param name=\"url\" value=\"jdbc:postgresql://localhost:5432/test\"></param>
<param name=\"schema\" value=\"public\"></param>
<param name=\"user\" value=\"test\"></param>
<param name=\"password\" value=\"test11\"></param>
<param name=\"schemaObjectPrefix\" value=\"rep1_\"></param>
</FileSystem>
<PersistenceManager class=\"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager\">
<param name=\"driver\" value=\"org.postgresql.Driver\"></param>
<param name=\"url\" value=\"jdbc:postgresql://localhost:5432/test\"></param>
<param name=\"schema\" value=\"postgresql\"></param>
<param name=\"user\" value=\"test\"></param>
<param name=\"password\" value=\"test11\"></param>
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\"></param>
<param name=\"externalBLOBs\" value=\"false\"></param>
</PersistenceManager>
<SearchIndex class=\"org.apache.jackrabbit.core.query.lucene.SearchIndex\">
<param name=\"path\" value=\"${wsp.home}/index\"></param>
<param name=\"useCompoundFile\" value=\"true\"></param>
<param name=\"minMergeDocs\" value=\"100\"></param>
<param name=\"volatileIdleTime\" value=\"3\"></param>
<param name=\"maxMergeDocs\" value=\"100000\"></param>
<param name=\"mergeFactor\" value=\"10\"></param>
<param name=\"bufferSize\" value=\"10\"></param>
<param name=\"cacheSize\" value=\"1000\"></param>
<param name=\"forceConsistencyCheck\" value=\"false\"></param>
<param name=\"autoRepair\" value=\"true\"></param>
<param name=\"analyzer\" value=\"org.apache.lucene.analysis.standard.StandardAnalyzer\"></param>
<param name=\"respectDocumentOrder\" value=\"false\"></param>
<param name=\"textFilterClasses\" value=\"
org.apache.jackrabbit.core.query.lucene.TextPlainTextFilter,
org.apache.jackrabbit.extractor.MsExcelTextExtractor,
org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,
org.apache.jackrabbit.extractor.MsWordTextExtractor,
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\"></param>
</SearchIndex>
</Workspace>
<Versioning rootPath=\"${rep.home}/version\">
<FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
<param name=\"path\" value=\"${rep.home}/version\"></param>
</FileSystem>
<PersistenceManager class=\"org.apache.jackrabbit.core.persistence.db.DerbyPersistenceManager\">
<param name=\"url\" value=\"jdbc:derby:${rep.home}/version/db;create=true\"></param>
<param name=\"schemaObjectPrefix\" value=\"version_\"></param>
</PersistenceManager>
</Versioning>
</Repository>
En mi base de datos solo se crea una tabla quese llama rep_fsentry que tiene 5 variables, esta tabla es donde se almacenan todos mis documentos ? Si no es asi como le puedo hacer para que todos los documentos se almacenen directamente en la base de datos?
Muchas gracias de antemano
<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<Repository>
<!--<FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
<param name=\"path\" value=\"${rep.home}/repository\"></param>
</FileSystem> -->
<FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"org.postgresql.Driver\"></param>
<param name=\"url\" value=\"jdbc:postgresql://localhost:5432/test\"></param>
<param name=\"schema\" value=\"postgresql\"></param>
<param name=\"user\" value=\"test\"></param>
<param name=\"password\" value=\"test11\"></param>
<param name=\"schemaObjectPrefix\" value=\"rep_\"></param>
</FileSystem>
<Security appName=\"Jackrabbit\">
<AccessManager class=\"es.git.openkm.core.OKMAccessManager\"></AccessManager>
<!-- <AccessManager class=\"org.apache.jackrabbit.core.security.SimpleAccessManager\"/> -->
</Security>
<Workspaces rootPath=\"${rep.home}/workspaces\" defaultWorkspace=\"default\"></Workspaces>
<Workspace name=\"${wsp.name}\">
<FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"org.postgresql.Driver\"></param>
<param name=\"url\" value=\"jdbc:postgresql://localhost:5432/test\"></param>
<param name=\"schema\" value=\"public\"></param>
<param name=\"user\" value=\"test\"></param>
<param name=\"password\" value=\"test11\"></param>
<param name=\"schemaObjectPrefix\" value=\"rep1_\"></param>
</FileSystem>
<PersistenceManager class=\"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager\">
<param name=\"driver\" value=\"org.postgresql.Driver\"></param>
<param name=\"url\" value=\"jdbc:postgresql://localhost:5432/test\"></param>
<param name=\"schema\" value=\"postgresql\"></param>
<param name=\"user\" value=\"test\"></param>
<param name=\"password\" value=\"test11\"></param>
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\"></param>
<param name=\"externalBLOBs\" value=\"false\"></param>
</PersistenceManager>
<SearchIndex class=\"org.apache.jackrabbit.core.query.lucene.SearchIndex\">
<param name=\"path\" value=\"${wsp.home}/index\"></param>
<param name=\"useCompoundFile\" value=\"true\"></param>
<param name=\"minMergeDocs\" value=\"100\"></param>
<param name=\"volatileIdleTime\" value=\"3\"></param>
<param name=\"maxMergeDocs\" value=\"100000\"></param>
<param name=\"mergeFactor\" value=\"10\"></param>
<param name=\"bufferSize\" value=\"10\"></param>
<param name=\"cacheSize\" value=\"1000\"></param>
<param name=\"forceConsistencyCheck\" value=\"false\"></param>
<param name=\"autoRepair\" value=\"true\"></param>
<param name=\"analyzer\" value=\"org.apache.lucene.analysis.standard.StandardAnalyzer\"></param>
<param name=\"respectDocumentOrder\" value=\"false\"></param>
<param name=\"textFilterClasses\" value=\"
org.apache.jackrabbit.core.query.lucene.TextPlainTextFilter,
org.apache.jackrabbit.extractor.MsExcelTextExtractor,
org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,
org.apache.jackrabbit.extractor.MsWordTextExtractor,
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\"></param>
</SearchIndex>
</Workspace>
<Versioning rootPath=\"${rep.home}/version\">
<FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
<param name=\"path\" value=\"${rep.home}/version\"></param>
</FileSystem>
<PersistenceManager class=\"org.apache.jackrabbit.core.persistence.db.DerbyPersistenceManager\">
<param name=\"url\" value=\"jdbc:derby:${rep.home}/version/db;create=true\"></param>
<param name=\"schemaObjectPrefix\" value=\"version_\"></param>
</PersistenceManager>
</Versioning>
</Repository>
En mi base de datos solo se crea una tabla quese llama rep_fsentry que tiene 5 variables, esta tabla es donde se almacenan todos mis documentos ? Si no es asi como le puedo hacer para que todos los documentos se almacenen directamente en la base de datos?
Muchas gracias de antemano