Advanced Configuration
Change Virtuoso's Default Transaction Isolation Level
Use the following instructions to change Virtuoso's default transaction isolation level:
1.
Login to the machine that hosts your Virtuoso Universal Server.
2.
Use a text editor to open the virtuoso.ini file that appears in the ~/virtuoso/db sub-directory.
3 Locate the [Parameter] section of the file.
For example:
[Parameters] ServerPort = 1111 DisableUnixSocket = 1 ;SSLServerPort = 2111 . . .
4.
Locate the DefaultIsolation parameter.
5.
Pass the numeric value that represents the isolation level that you want to set.
For example:
DefaultIsolation = 2
Isolation levels are --
| Numeric Value | Isolation Level |
| 1 | READ UNCOMMITTED |
| 2 | READ COMMITTED |
| 3 | REPEATABLE READ |
| 4 | SERIALIZABLE |
6.
Save your changes and exit the file.
7.
Restart or reinitialize your Virtuoso server.
