Re: Problems in using RDB DocumentStore on mariadb

[Julian Reschke]

On 11.10.2024 11:06, Raffaele Gambelli wrote:

I've notifced this code in RDBDocumentStore:

int isolation = con.getTransactionIsolation();
        String isolationDiags = RDBJDBCTools.isolationLevelToString(isolation);
        if (isolation != Connection.TRANSACTION_READ_COMMITTED) {
            LOG.info("Detected transaction isolation level " + isolationDiags + " is 
"
                    + (isolation < Connection.TRANSACTION_READ_COMMITTED ? "lower" : 
"higher") + " than expected "
                    + 
RDBJDBCTools.isolationLevelToString(Connection.TRANSACTION_READ_COMMITTED)
                    + " - check datasource configuration");
        }

Now the default isolation level for MariaDB is REPEATABLE_READ so it will be 
logged that log, I'm asking if there is some known restriction  or strong 
recomendation in using READ_COMMITTED? I believe not because it is only an info 
log but why does it is expected?

Thanks,
...

I believe it's the lightest isolation level we need, thus we recommend it.

I don't recall where it can be set? Maybe in the JDBC URL?

Best regards, Julian