DFC DQL Inconsistent query results

I have a small java app utilising DFC & DQL to query a docbase and write out content to the file system.

I have a query to count the objects then a 2nd query simply asks to return all objects of a certain type, cycles through the results and uses getFile to write to the file system.

For some reason, every time I run it it returns different numbers of results. The count is always the same but the 2nd query produces different numbers each time. The queries are the same except for doing a count and returning the values etc.

Any ideas, I'm running 5.3 SP3?

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

mszurap

Hi,

There is a "limitation" that if you open a query result (a collection) then you cannot do complicated tasks, because you can lose your query results (the collection is a database cursor, which is maybe reused meantime if you do getObject or other Dctm calls). So as best practice I recommend you to get only the r_object_id's in your query, put them in a vector, close the collection, and process your object id's after that as you wish. Maybe you need to do some things twice, but it's clean and safe, the Dctm collections (and database resources) are released quicker, and at last: you will not face this strange behaviour.

Mike

All comments

Francois Dauberlieu

Any repeating attributes in your query ?

If yes, did you check in the DQL guide how to properly handle them ?

Basically, the story is that if you don't work it out properly, DQL will return 1 row for every value in your repeating attribute

Can you share with us your DQL query ?

mgrant

The number of rows returned by the 2nd query is either the same or less than the count. Queries are:

SELECT COUNT(*) FROM myobject WHERE(myflag = 1)

and

SELECT * FROM myobject WHERE(myflag = 1)

The code essentiallygets a session as thus:

IDfLoginInfo loginInfo = new DfLoginInfo();
loginInfo.setUser(PropertyFile.getUsername());
loginInfo.setPassword(PropertyFile.getPassword());
loginInfo.setDomain("");

IDfClient dfc = DfClient.getLocalClient();
IDfSession session = dfc.newSession(PropertyFile.getDocBase(),
loginInfo);

executes a query as thus:

DfQuery query = new DfQuery();
query.setDQL(dql);

IDfCollection queryResults = query.execute(session, type);

cycles through the results as thus:

while (queryResults.next()) {

......

idfSysObject.getFile(filePath + "/" + fileName
+ "." + contentType);

......
}

mszurap

Hi,

Mike

Fros

What is the type that you are using? 1 (read query) or 3 (execute)? For big collections the read query does not return a complete result.