What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?

Joe Sam Shirah

The answer depends on both your code and the DBMS. If the program does not explicitly set the isolation level, the DBMS default is used. You can determine the default using DatabaseMetaData.getDefaultTransactionIsolation() and the level for the current Connection with Connection.getTransactionIsolation(). If the default is not appropriate for your transaction, change it with Connection.setTransactionIsolation(int level). See also: How does one manage concurrency issues with JDBC?