Thanks a lot. It works fine ! I have just one last question concerning the
CMIS connector used with Alfresco to get all internal metadata affected to
a document by Alfresco. I used this kind of cmis query : select * from
cmis:document where cmis:name in ('doc.pdf') which doesn't work. So you
advised me to use trunk to commit my application in order to be able to use
the query but I cannot use trunk because of the internet restriction in my
enterprise.
So I'd like to know if it exists another query expression that enables me
to do what I want.Baptiste 2014-08-11 9:53 GMT+02:00 Karl Wright <[email protected]>: > Hi Baptiste, > > See > http://manifoldcf.apache.org/release/trunk/en_US/how-to-build-and-deploy.html#Configuring+a+MySQL+database > . > > The instructions are similar to configuration of PostgreSQL, except that > the properties.xml property > org.apache.manifoldcf.databaseimplementationclass should be set to > "org.apache.manifoldcf.core.database.DBInterfaceMySQL". > > Karl > > > On Mon, Aug 11, 2014 at 3:05 AM, Baptiste Berthier <[email protected]> > wrote: > >> Thanks for your answer. I have just one question. I have configured >> ManifoldCF to run on PostgreSQL but now I would like to run it on MySQL. I >> found a lot of documentation to configure it On Postgresql but nothing >> about the eventual possibility to configure it on MySQL. Is it possible to >> configure ManifoldCF on Mysql ? >> >> Baptiste >> 2014-08-08 14:10 GMT+02:00 Karl Wright <[email protected]>: >> >>> Hi Baptiste, >>> >>> The patch is not complete; other changes need to be made as well to fix >>> the ticket. But if you are using trunk, you do not need to apply any >>> patch; it's already committed. >>> >>> Thanks, >>> Karl >>> >>> >>> >>> On Fri, Aug 8, 2014 at 7:36 AM, Baptiste Berthier <[email protected] >>> > wrote: >>> >>>> >>>> Hi, >>>> >>>> I follow the answer of Karl Wright mentionned at >>>> https://issues.apache.org/jira/i#browse/CONNECTORS-1002 with this >>>> content : >>>> >>>> So I understand that the internal metadata does not make it through >>>> from Alfresco into CMIS. >>>> >>>> The CMIS connector working against an Alfresco repository depends >>>> completely on Alfresco's implementation of CMIS. It is not clear how >>>> complete Alfresco's implementation is. The CMIS connector code seems like >>>> it would definitely pick up most properties, PROVIDED they are explicitly >>>> mentioned in the CMIS query you provide: >>>> >>>> //properties >>>> >>>> List<Property<?>> properties = document.getProperties(); >>>> >>>> String id = StringUtils.EMPTY; >>>> >>>> for (Property<?> property : properties) { >>>> >>>> String propertyId = property.getId(); >>>> >>>> if(CmisRepositoryConnectorUtils.existsInSelectClause(cmisQuery, >>>> propertyId)){ >>>> >>>> if (propertyId.endsWith(Constants.PARAM_OBJECT_ID)) >>>> >>>> id = (String) property.getValue(); >>>> >>>> This is from roughly line 1129 of CMISRepositoryConnector.java. If >>>> you can't figure out what is going on, you can modify this code to add >>>> System.out.println() statements that should shed some light on the problem. >>>> >>>> Please also note that the CMIS connector may not be resilient against >>>> changes to the query string. To be sure, you may want to delete your old >>>> job and create a new job with the changed query string, to be sure >>>> everything that needs to be recrawled actually gets reprocessed. I will >>>> create a different ticket to cover that issue. >>>> >>>> I have modified the code in ManifoldCF but when I compile with ant in >>>> the folder apache-manifoldcf-1.6.1\connector\cmis, I have the following >>>> error in >>>> CMISRepositoryConnector.java : >>>> >>>> "error : cannot find symbol >>>> >>>> [javac] >>>> if(CmisRepositoryConnectorUtils.existsInSelectClause(cmisQuery, >>>> propertyId)){ >>>> >>>> [javac] symbol : variable cmisQuery >>>> >>>> [javac] location : class CmisRepositoryConnector >>>> >>>> [javac] 1 error >>>> >>>> Build failed >>>> >>>> I don't know what I have to do to correct this error which appears >>>> during compilation. >>>> >>>> Thanks for your answer >>>> >>>> Baptiste >>>> >>>> >>> >> >
