MssqlConnectionConfiguration schema option.

[omuralcin-ge]

Feature Request

I searched it on Github and Stackoverflow but I didn't find anything about this feature. I am using MSSQL database and I want to create schema for each tenants. While I was designing per-schema multitenancy for mssql database I needed to add new schema name to connections of the each tenants like postgresql above :

protected PostgresqlConnectionConfiguration.Builder getPostgresqlConnectionConfigurationBuilder(String schema) {
    return PostgresqlConnectionConfiguration
            .builder()
            .username(dbUser)
            .password(dbPassword)
            .host(dbHost)
            .port(dbPort)
            .database(dbName)
            .schema(schemaName);
}

There is a schema option for PostgresqlConnectionConfiguration at the r2dbc-postgresql for this work but r2dbc-mssql doesn't provide schema option yet.So I couldn't add schema name to my mssql connection config.

Please add new feature for schema option to MssqlConnectionConfiguration class.

Best Regards.

[mp911de]

Care to elaborate? As far as I know, there's no direct support to set the namespace (owner namespace) through a driver other than logging into the database with an according user. Does the JDBC SQL Server driver have such an option?

[omuralcin-ge]

@mp911de I guess it's about user functionality not JDBC session for mssql. I found this answer about the JDBC schema option for mssql at the SO.

[omuralcin-ge]

@mp911de do you have an idea for this situation?

[mp911de]

The schema is a MS SQL-specific behavior that cannot be set through the driver/client. While Postgres allows setting a session variable to tell the session in which schema to look for a database object, but SQL Server doesn't support that.

The only thing I found so far is the default schema for a user but that is nothing we can affect from a driver side.

Therefore, I'm closing this ticket because it isn't actionable.