Wanted to create a read-only transaction using jConnector. Expect Mariadb to return a java.sql.SQLException when there is an update statement within a read only transaction

See the code below.

1. Mariadb commits the the statement and return success
connection.setAutoCommit(false);
connection.setReadOnly(true);
– do an update statement
connection.commit();

2. Mariadb returns an exception, 'set transaction read only' is sent to Mariadb prior to starting an update statement.

connection.createStatement().execute("set transaction read only")
– do an update statement //Cause Mariadb to return a SqlException