I create a connected datastore object in a servlet and then pass the connected datastore object to a method in a different servelet to perform an operation. I frequently get DKException "[IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010 "
If the same datastore object is not property synchronized in a multithreading scenario, the following error is likely to occur when performing operations on the datastore:
DKException
[IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
This is a classic symptom of a threading problem. Most likely, the same datastore instance is used by multiple threads at the same time.
Either strictly synchronize your access to the datastore object or have each thread use its own separate connected DKDatastoreICM object.
Using separate datastore objects is the safest solution.
[{"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"DB2 Information Integrator for Content","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"8.1;8.2;8.3;8.4","Edition":"All Editions;Edition Independent","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Usage","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"","label":"UNIX"},{"code":"","label":"Windows NT"},{"code":"","label":"Windows XP"},{"code":"","label":"Windows 2003"},{"code":"","label":"Windows Vista"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"},{"code":"","label":"UNIX"},{"code":"","label":"Windows NT"},{"code":"","label":"Windows Vista"}],"Version":"8.1;8.2;8.3;8.4","Edition":"All Editions;Edition Independent","Line of Business":{"code":"LOB45","label":"Automation"}}]