Testing concurrent transactions

Often the database contains not only data, but also packets / triggers, which provide declarative data integrity.These packages / triggers need to be tested in multi-tasking mode.For testing 100 concurrent transactions, instead of using 100 testers (people), we will use appropriate test tools.We can use special tools for that purpose, or we can make tests on our own in a relatively simple way.This paper will show how to test one database business rule (which we have presented at HROUG 2009: "How to prevent the loop in the hierarchical data structure"),using Java Executors or (for those who do not work with Java) using the DBMS_PARALLEL_EXECUTE package.