io.hyperfoil.tools.horreum.server.JDBCConnectionInterceptor Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of horreum-backend Show documentation

The newest version!

package io.hyperfoil.tools.horreum.server;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import jakarta.enterprise.context.ApplicationScoped;

import io.agroal.api.AgroalPoolInterceptor;
import io.hyperfoil.tools.horreum.svc.Roles;
import io.quarkus.logging.Log;

@ApplicationScoped
public class JDBCConnectionInterceptor implements AgroalPoolInterceptor {

    @Override
    public void onConnectionCreate(Connection connection) {
        try (Statement statement = connection.createStatement()) {
            statement.execute("SELECT set_config('horreum.userroles', '" + Roles.HORREUM_SYSTEM + "', false)");
        } catch (SQLException e) {
            Log.warnv(e, "Unable to set default role " + Roles.HORREUM_SYSTEM + " on the JDBC connection.");
        }
    }
}