Hi fellow developers,
I have written documentation about the 'Multiple DB Connections for Multiple Threads' feature. This is the new way in which DB Access operates in OpenPetra since trunk Rev. 2989 (September 28th, 2015).
The changed approach makes it possible to reliably open multiple DB Connections for multiple Threads and to execute SQL commands in parallel on independent DB Transactions! While this is a non-breaking change, it is important for you to understand the changes that were made, why they were made, what different behaviour you must now expect from DB Access in OpenPetra, and what the all-new options for running parallel (not pseudoparallel!) DB access in different Threads are!
Please read the following OpenPetra wiki article if you are doing any database-related development in OpenPetra:
It is important to understand that the new feature doesn't do away with the existing 'Co-ordinated DB Access' feature. The latter feature is needed everywhere where we don't deliberately start a new Thread for parallel DB Access (that is, in most situations in OpenPetra)! Rather, the ability to work with multiple parallel DB Connections opens up the way of true parallel DB command execution, and not just pseudoparallel execution, and for independent DB Transactions (both independent in their IsolationLevels and the timings of starting, committing and rolling back).