IBM Support

How to apply NOLOCK in api query on IBM Filenet Content Manager

How To


Summary

String sqlQuery = "SELECT [This],* FROM [Folder] WHERE ([This] INSUBFOLDER '+ path + "') AND ([FolderName] = '" + refNo + "')";
SearchSQL sql = new SearchSQL(sqlQuery);
SearchScope scope = new SearchScope(objectStore);
IndependentObjectSet set = scope.fetchObjects(sql, null, null,false);

Example use NoLock
SELECT * FROM Person.Contact WITH (NOLOCK) WHERE ContactID < 20
If we would like to use Filenet API (Java) to query in ICN Plugin Service..." How can we apply NOLOCK in api query on above?

There is no NOLOCK option in the Content Platform Engine(CPE) SQL syntax, but there is also no need for any such option.
The CPE API is completely stateless.  Each command completes, and commits it's transaction before returning to the caller.  So SQL DB resources are never left in a locked state after a call to the Content Engine(CE) API. 
Additionally, the CE SQL syntax is read only (no INSERT/UPDATE/DELETE) so there is not a transaction in the first place for CE API queries.  They are read only queries that don't take locks.

Document Location

Worldwide


[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5,2,x;5.3.x","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
FileNet Content Manager

Software version:
5,2,x, 5.3.x

Document number:
885913

Modified date:
28 April 2025

UID

ibm10885913

Manage My Notification Subscriptions