Testing Competing Transactions in an Oracle Database using Java Parallel Programming

U bazama podataka često rješavamo složena poslovna pravila. Naročito su kompleksna ona rješenja koja moraju dobro raditi u višekorisničkoj okolini. U ovom radu prikazali smo jedno takvo (naše) rješenje (pisano pomoću Oracle PL/SQL pohranjenih procedura), koje sprečava pojavu petlje (u hijerarhijskoj strukturi podataka) u višekorisničkoj okolini. Za testiranje tog rješenja trebali bismo imati veliki broj testera (osoba), koji bi testiranje trebali paralelno raditi duže vrijeme (nekoliko sati). Zbog toga smo napravili Java paralelni program, koji se temelji na Java executorima (postoje još od Jave 5). Kroz taj Java program lako je pokrenuti npr. stotinjak (ili više) paralelnih Java dretvi, koje pokreću konkurentne sesije baze podataka.In databases, we often handle complex business rules. Particularly complex are those solutions that need to work well in a multiuser environment. In this paper, we have presented one such (our) solution (written using Oracle PL / SQL stored procedures), which prevents the appearance of a loop (in a hierarchical data structure) in a multiuser environment. To test this solution, we should have a large number of testers (persons), who should work in parallel for a long time (several hours). Because of this, we created a Java parallel program, based on Java executors (they have existed since Java 5). It is easy to run through this Java program e.g. one hundred (or more) parallel Java threads that run concurrent database sessions