SQL Server
Oracle
iDB2
MySQL
.NET or J2EE
Isolation level: READ UNCOMMITTED
Multiple transactions per request: one for writes, one for each read.
Isolation level: READ COMMITTED
One transaction per request. Multiple reads in the same transaction.
Acácio Porta Nova wrote:
I'm a bit confused... If the transaction opens in the beginning of everything, why the documentation says that the OutSystems Platform begins a database transaction on its first access to the database? That said, If I have a screen action without any call to the Database, no transaction would be started, right?
André Siébra wrote:
I agree with you André, if your action don't interact with database, no transaction will be started. You easily see this when extracting the source code.