Why in C3P0ConnectionProvider.getConnection() every connection object setting the same isolation level value again for every transaction?
If Connection.getTransactionIsolation() is already set to READ COMMITTED then why it is again setting the same READ COMMITTED value to that connection object?
Because of that after enabling the SQL auditing this statement logging the unnecessary sql statement of “alter session set isolation_level = read committed”.
Is there any specific reason if not then Is possible to modify code like :
if ( isolation != null && c.getTransactionIsolation()!=isolation.intValue() ) {
c.setTransactionIsolation( isolation.intValue() );
}