DQL query result returns back a List of Map (List<Map>).

Each row in the list i.e. each Map entry designates a row obtained as DQL execution result. And each key-pair in the Map represents the attribute of that item.

e.g. Executing the following query Select title, object_name,r_modify_date  FROM dm_document where FOLDER ('/Test') gives me back the following 3 items (Result Item 1, Result Item 2, and Result Item 3).

Here is what the operation output looks like from an API:-

[

      // Row 1/Result Item 1
       {

            title= Updated_Name678_title,                         // Attribute title of Result Item 1

            object_name=Updated_Name678,                          // Attribute object_name of Result Item 1

            r_modify_date=Mon Nov 24 12:57:37 IST 2008            // Attribute r_modify_date of Result Item 1

      },

 

      // Row 2/Result Item 2

      {     title=,

            object_name=jacorb.jar,

            r_modify_date=Wed Mar 18 15:33:56 IST 2009

      },

 

      // Row 3/Result Item 3

      {

title=,

object_name=TestDoc1.txt,

r_modify_date=Wed Mar 24 20:06:17 IST 2010

}

]

 

Looks like you are using workbench for the operation.

Can you instead try using API invocation instead of workbench. There is a limited support for complex types through workbench and process context and it looks like List<Map> doesn't comes under the supported list. API invocation should however, work perfectly fine in this case.

Hi Jean,

By SOAP UI you mean SOAP Endpoint invocation? Also, that means you are using client jar adobe-connectorforemcdocumentum-client.jar for the purpose, correct?

An example invocation code looks like:-

// Obtain Service Client Factory from LiveCycle Server details.
Properties ConnectionProps = new Properties();
ConnectionProps.setProperty("DSC_DEFAULT_SOAP_ENDPOINT", "http://lcseever:8080");
ConnectionProps.setProperty("DSC_TRANSPORT_PROTOCOL", "SOAP");
ConnectionProps.setProperty("DSC_SERVER_TYPE", "JBoss");
ConnectionProps.setProperty("DSC_CREDENTIAL_USERNAME", "username");
ConnectionProps.setProperty("DSC_CREDENTIAL_PASSWORD", "password");

ServiceClientFactory serviceClientFactory = ServiceClientFactory.createInstance(ConnectionProps);

// Create Documentum Client object.
EMCDocumentumContentRepositoryConnectorServiceClient dctmClient = new EMCDocumentumContentRepositoryConnectorServiceClient(serviceClientFac tory);

// Create Login Settings Object with Documentum Login details
LoginSettings loginSettings = new LoginSettings(LoginMode.USER_CREDENTIALS, "dctmUserName", "dctmPassword", null);
                
String repositoryName = "DocbaseName";

// Invoke executeDQLQuery
List<Map> resultMap = dctmClient.executeDQLQuery(loginSettings, repositoryName, queryString);

If yes, Can you try using EJB Endpoint invocation method instead? For more information on EJB and SOAP invocations in LiveCycle ES2 take a look at:- http://help.adobe.com/en_US/livecycle/9.0/programLC/help/000495.html#1 548279

thanks for the code

Hi Dhanesh,

Can you please start a new thread for the same discussion as both of the issues are no where related. It would be easy to track them later on.

You can start it under the same category i.e. "LiveCycle Connectors for ECM ES"

Thanks and Regards,

Raghu