access to the session

adam_bo_ — Mon, 16 Jul 2012 09:06:48 GMT

Hi all,

I have created a seam validator:

public void validateSAPNumber(FacesContext context, UIComponent component,
        Object value) {

    String messageString = null;
	Integer size = 1;

	String SAPNumber = (String) value;
	String DocId = navigationContext.getCurrentDocument().getId();

	String query = String.format("SELECT * FROM Document WHERE sap:SAPNumber = '%s' AND ecm:uuid != '%s'", SAPNumber, DocId);
    try {
	  DocumentModelList docs = documentManager.query(query);
	  size = docs.size();
    } catch (Exception e) {
    	messageString = "label.org.nuxeo.adambo.sap.SAPNumberActionsBean";
    }
	
	if (size>0) {
        FacesMessage message = new FacesMessage(
                FacesMessage.SEVERITY_ERROR, ComponentUtils.translate(
                        context, "label.org.nuxeo.adambo.sap.SAPNumberActionsBean"),
                null);
        context.addMessage(null, message);
        throw new ValidatorException(message);
    }
}

and it works but only with a user permissions scope. The problem is that the "query" method uses a "FilteresQuery" class. I guess it is necessary to use the "createQuery" method of the "Session" class, but how get access to it? The simple conversion of the documentManager to a "Session" class is not possible.

Re: access to the session

adam_bo_ — Mon, 16 Jul 2012 16:22:50 GMT

Ok, I have realised the Query method in this way:

    try {
    	String repoName = documentManager.getRepositoryName();
    	LocalSession lsession = new LocalSession();
    	lsession.connect(repoName, null);
    	Session session = lsession.getSession();
    	
    	Query compiledQuery = session.createQuery(query, Query.Type.NXQL);
    	
        QueryResult results = compiledQuery.execute();
        DocumentModelList dms = results.getDocumentModels();

        return dms;
        
    } catch (Exception e) {
        throw new ClientException("Failed to execute query.", e);
    }

I am not sure that it is the best and simplest solution, but it works. Maybe it will help someone else.

Best regards

topic access to the session in Nuxeo Forum

access to the session

Re: access to the session