Hi,
Managed to fix this by myself :)
Need to have the DataSource information with in the
jackrabbit-bundle-postgres-search.xml file
<DataSources>
<DataSource name="magnolia">
<param name="driver" value="org.postgresql.Driver"/>
<param name="url"
value="jdbc:postgresql://localhost:5432/magnolia_author"/>
<param name="user" value="postgres" />
<param name="password" value="password" />
<param name="databaseType" value="postgres"/>
<param name="validationQuery" value="select 1"/>
</DataSource>
</DataSources>
Also with in the 2 instances of PersistenceManager need to have 2 seperate
values for the below tag.
<param name="schemaObjectPrefix" value="${wsp.name}_" />
<param name="schemaObjectPrefix" value="version_" />
In case anyone else run in to this problem, here is the working version of my
jackrabbit-bundle-postgres-search.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit
2.0//EN" "http://jackrabbit.apache.org/dtd/repository-2.0.dtd";>
<Repository>
<DataSources>
<DataSource name="magnolia">
<param name="driver" value="org.postgresql.Driver"/>
<param name="url"
value="jdbc:postgresql://localhost:5432/magnolia_author"/><!-- magnolia_author
is the database instance name with in my postgresql database -->
<param name="user" value="postgres" />
<param name="password" value="password" />
<param name="databaseType" value="postgres"/>
<param name="validationQuery" value="select 1"/>
</DataSource>
</DataSources>
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/repository" />
</FileSystem>
<Security appName="Jackrabbit">
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager"></AccessManager>
<LoginModule class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<param name="anonymousId" value="anonymous" />
</LoginModule>
</Security>
<DataStore class="org.apache.jackrabbit.core.data.FileDataStore">
<param name="path" value="${rep.home}/repository/datastore"/>
<param name="minRecordLength" value="1024"/>
</DataStore>
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" />
<Workspace name="default">
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}/default" />
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager">
<param name="driver" value="org.postgresql.Driver"/>
<param name="url"
value="jdbc:postgresql://localhost:5432/magnolia_author" />
<param name="schema" value="postgresql" /><!-- warning, this is not the
schema name, it's the db type -->
<param name="user" value="postgres" />
<param name="password" value="password" />
<param name="schemaObjectPrefix" value="${wsp.name}_" />
<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="maxFieldLength" value="10000" />
<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="queryClass"
value="org.apache.jackrabbit.core.query.QueryImpl" />
<param name="respectDocumentOrder" value="true" />
<param name="resultFetchSize" value="2147483647" />
<param name="extractorPoolSize" value="3" />
<param name="extractorTimeout" value="100" />
<param name="extractorBackLogSize" value="100" />
</SearchIndex>
<WorkspaceSecurity>
<AccessControlProvider
class="info.magnolia.cms.core.MagnoliaAccessProvider" />
</WorkspaceSecurity>
</Workspace>
<Versioning rootPath="${rep.home}/version">
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/workspaces/version" />
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager">
<param name="driver" value="org.postgresql.Driver"/>
<param name="url"
value="jdbc:postgresql://localhost:5432/magnolia_author" />
<param name="schema" value="postgresql" /><!-- warning, this is not the
schema name, it's the db type -->
<param name="user" value="postgres" />
<param name="password" value="password" />
<param name="schemaObjectPrefix" value="version_" />
<param name="externalBLOBs" value="false" />
</PersistenceManager>
</Versioning>
</Repository>
Regards,
Hasitha
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=419c112b-838f-4589-b7b6-b45b0e1c9ffd
----------------------------------------------------------------
For list details, see http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
