[
http://jira.magnolia.info/browse/MAGNOLIA-2152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17143#action_17143
]
Philippe Marschall commented on MAGNOLIA-2152:
----------------------------------------------
We use Oracle 9 and the bundle persistence manager.
h2.jackrabbit-oracle-search.xml
{code}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit
1.2//EN" "http://jackrabbit.apache.org/dtd/repository-1.2.dtd";>
<Repository>
<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>
<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.Oracle9PersistenceManager">
<param name="driver" value="oracle.jdbc.OracleDriver"/>
<param name="url" value="jdbc:oracle:thin:@localhost:521:localhost"/>
<param name="user" value="sysdba"/>
<param name="password" value="secret"/>
<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" />
<param name="textFilterClasses"
value="org.apache.jackrabbit.extractor.MsWordTextExtractor,
org.apache.jackrabbit.extractor.MsExcelTextExtractor,
org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,
org.apache.jackrabbit.extractor.PdfTextExtractor,
org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,
org.apache.jackrabbit.extractor.RTFTextExtractor,
org.apache.jackrabbit.extractor.HTMLTextExtractor,
org.apache.jackrabbit.extractor.PlainTextExtractor,
org.apache.jackrabbit.extractor.XMLTextExtractor" />
</SearchIndex>
</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.Oracle9PersistenceManager">
<param name="driver" value="oracle.jdbc.OracleDriver"/>
<param name="url" value="jdbc:oracle:thin:@localhost:1521:localhost"/>
<param name="user" value="sysdba"/>
<param name="password" value="secret"/>
<param name="schemaObjectPrefix" value="version_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
</Versioning>
</Repository>
{code}
h2.respository.xml
{code}
<!DOCTYPE JCR [
<!ELEMENT Map (#PCDATA)>
<!ATTLIST Map
name CDATA #REQUIRED
repositoryName CDATA #REQUIRED
workspaceName CDATA #REQUIRED>
<!ELEMENT JCR (RepositoryMapping|Repository)*>
<!ELEMENT param (#PCDATA)>
<!ATTLIST param
name CDATA #REQUIRED
value CDATA #REQUIRED>
<!ELEMENT Repository (param|workspace)*>
<!ATTLIST Repository
loadOnStartup CDATA #REQUIRED
name CDATA #REQUIRED
provider CDATA #REQUIRED>
<!ELEMENT workspace (#PCDATA)>
<!ATTLIST workspace
name CDATA #REQUIRED>
<!ELEMENT RepositoryMapping (Map)*>
]><JCR>
<RepositoryMapping>
<Map name="website" repositoryName="magnolia" workspaceName="website" />
<Map name="config" repositoryName="magnolia" workspaceName="config" />
<Map name="users" repositoryName="magnolia" workspaceName="users" />
<Map name="userroles" repositoryName="magnolia"
workspaceName="userroles" />
<Map name="usergroups" repositoryName="magnolia"
workspaceName="usergroups" />
<Map name="mgnlSystem" repositoryName="magnolia"
workspaceName="mgnlSystem" />
<Map name="mgnlVersion" repositoryName="magnolia"
workspaceName="mgnlVersion" />
<Map name="dms" repositoryName="magnolia" workspaceName="dms" />
<Map name="packages" repositoryName="magnolia" workspaceName="packages"
/>
<Map name="Store" repositoryName="magnolia" workspaceName="Store" />
<Map name="Expressions" repositoryName="magnolia"
workspaceName="Expressions" />
</RepositoryMapping>
<Repository name="magnolia"
provider="info.magnolia.jackrabbit.ProviderImpl" loadOnStartup="true">
<param name="configFile"
value="${magnolia.repositories.jackrabbit.config}" />
<param name="repositoryHome"
value="${magnolia.repositories.home}/magnolia" />
<param name="contextFactoryClass"
value="org.apache.jackrabbit.core.jndi.provider.DummyInitialContextFactory" />
<param name="providerURL" value="localhost" />
<param name="bindName" value="${magnolia.webapp}" />
<workspace name="website" />
<workspace name="config" />
<workspace name="users" />
<workspace name="userroles" />
<workspace name="usergroups" />
<workspace name="mgnlSystem" />
<workspace name="mgnlVersion" />
<workspace name="dms" />
<workspace name="packages" />
<workspace name="Store" />
<workspace name="Expressions" />
</Repository>
</JCR>
{code}
> QueryManager and JCR browser seem to have different view on repository
> ----------------------------------------------------------------------
>
> Key: MAGNOLIA-2152
> URL: http://jira.magnolia.info/browse/MAGNOLIA-2152
> Project: Magnolia
> Issue Type: Bug
> Components: core
> Affects Versions: 3.5.8
> Reporter: Philippe Marschall
> Assignee: Philipp Bracher
>
> We have a very strange issue with querying custom page attributes. We have a
> custom page dialog that sets some custom page properties. These attributes
> are ad hoc and not defined in some sort of schema. We then have observation
> code that queries the JCR for pages with these attributes and certain values.
> Our queries look like this:
> {code}
> //element(*, mgnl:content) [EMAIL PROTECTED] and @someLongAttribute != 0]
> {code}
> {code}
> SELECT *
> FROM mgnl:content
> WHERE someLongAttribute IS NOT NULL AND someLongAttribute != 0
> {code}
> {code}
> //element(*, mgnl:content) [EMAIL PROTECTED] and @someBooleanAttribute =
> 'true']
> {code}
> {code}
> SELECT *
> FROM someBooleanAttribute IS NOT NULL AND someBooleanAttribute = 'true'
> {code}
> The behavior we are observing is that for certain pages the check for an
> attribute value is always false even if it should match according to the JCR
> browser. However the check for the attribute presence works as expected. As
> soon as we change a page attribute in the JCR browser the checks for the
> values work even if changed with the page properties dialog.
> This issue is very rare and we have not yet found a way to reproduce or
> trigger it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.magnolia.info/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/
----------------------------------------------------------------
