Run ALTER SESSION sql when a new connection created in the pool

[Kosala Lakshitha De Silva]

I am trying to specify a data source for quarkus. It works fine. But now I need to run a set the current schema when a connection is created.

I tried the quarkus.datasource.mydatasource.new-connection-sql, but it doesn't seems to work either. Below is my application.properties file. Any help regarding this highly appreciated.

quarkus.datasource.mydatasource.db-kind=oracle

quarkus.datasource.mydatasource.jdbc.driver=oracle.jdbc.driver.OracleDriver

quarkus.datasource.mydatasource.jdbc.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.18.74.140)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SN)))

quarkus.datasource.mydatasource.jdbc.min-size=3

quarkus.datasource.mydatasource.jdbc.max-size=20

quarkus.datasource.mydatasource.username=username

quarkus.datasource.mydatasource.password=password

quarkus.datasource.mydatasource.new-connection-sql=ALTER SESSION SET CURRENT_SCHEMA=MY_SCHEMA

Thank You,

Kosala