topic jcr:contains is not working properly in Alfresco Archive

jcr:contains is not working properly

stockbuyer — Tue, 10 Jul 2012 02:59:40 GMT

Hi all,I have a question to use jcr:contains to search the repository, my query is: "//* [jcr:contains(., 'load')]"and I got Repository Exception as below:javax.jcr.RepositoryException: 06100000 : 06100000 at org.alfresco.jcr.util.JCRProxyFactory$SessionContextInvocationHandler.invoke(JCRProxyFac

Re: jcr:contains is not working properly

sujaypillai — Thu, 19 Jul 2012 03:24:32 GMT

Please share your code so that we can comment on it.

Your query - //* [jcr:contains(., 'load')] seems to be perfect when executed on NodeBrowser.

Re: jcr:contains is not working properly

stockbuyer — Thu, 19 Jul 2012 03:49:20 GMT

Please share your code so that we can comment on it.

Your query - //* [jcr:contains(., 'load')] seems to be perfect when executed on NodeBrowser.

MY Code:

public void searchFile() {
      String xPathQuery = "//* [jcr:contains(., 'load')]";
      try {
         QueryManager queryManager = session.getWorkspace().getQueryManager();
         Query query = queryManager.createQuery(xPathQuery, Query.XPATH);
         QueryResult result = query.execute();
         if (result.getRows().hasNext()) {
            String[] columnNames = result.getColumnNames();
               for(RowIterator iterator = result.getRows(); iterator.hasNext(); )
               {
                   Row row = iterator.nextRow();
                   for ( String columnName : columnNames ) {
                      if (row.getValue(columnName) != null) {
                         System.out.println(columnName + ": " + row.getValue(columnName).getString());
                      }
                      else {
                         System.out.println(columnName + ": NULL");
                      }
                   }
                   System.out.println();
               }
         }
         else {
            System.out.println("No matching records are found");
         }
      }
      catch (RepositoryException e) {
         e.printStackTrace();
         fail("Repository Exception found");
      }
   }

Re: jcr:contains is not working properly

acarpine — Fri, 17 Aug 2012 07:47:35 GMT

Hi stockbuyer,
I don't think the problem is related to the jcr:contains. In my opinion the problem could be caused by the SSL configuration.

Please look at http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Fconcepts%2Fsolr-troubleshooting.html and let us know.

cheers,
andrea