Sorry
I have an app that performs data replications from db2 to oracle.
There is a base class that handles the connections, queries and data updates.
Each data replication relies on this base class to perform the work by only supplying the connection strings and sql
They work fine from different directories when run simultaneously.
However; I have a seperate app that dynamicly loads the classes by name according to the windows task scheduler. It provides the log maintenance, error reporting etc and the dynamicly loadable classes are stored in a single location.
While one class is performing the data replications, and another class is created, the processes of the previously executing class are disrupted by its properties being changed by the newly created class.
Example:
Class A Has it's destination data base query and source database query set. The method runs to fill a local dataset from the destination database.
Meanwhile, Class B loads, setting its query properties
Then Class A executes its method to find the changes from the source database but incorrectly queries the source database of Class B.
Probably too much detail... sorry, but I hoep it helps
![[monkey]](/data/assets/smilies/monkey.gif "[monkey] [monkey]")
