Grails custom data source properties are not set when injecting the datasource in a service

[gabivis]

Steps to Reproduce define a dataSource in application.groovy (I use tomcat jdbc connection pooling) dataSource { pooled= true username = password = ... properties { ... maxActive=16 testOnBorrow=true testWhileIdle=true
} } Reference the dataSource in a service class MyService { def dataSource def myMethod() { def sql = new Sql(dataSource) ... } } Expected Behaviour The datasource has the same custom properties as the ones set in application.groovy: i.e. testOnBorrow=true, testWhileIdle=true

Actual Behaviour The properties inside the properties block are ignored and so testOnBorrow=false, testWhileIdle=false

Environment Information Grails Version: 3.3.9 JDK Version: 1.8 Container Version (If Applicable): Tomcat

[vsachinv]

@gabivis Did you find any solution for the same out of the box ?

[vsachinv]

@gabivis As work around we have overridden bean like below in project resources.groovy.

  def domainClasses = grailsApplication.getArtefacts(DomainClassArtefactHandler.TYPE)
            .findAll { it.mappingStrategy != "none" && it.mappingStrategy == GrailsDomainClass.GORM }
            .collect { it.getClazz() }

    hibernateConnectionSourceFactory(HibernateFilterConnectionSourceFactory, domainClasses as Class[]) {
        dataSourceConnectionSourceFactory = ref('dataSourceConnectionSourceFactory')
    }

to avoid recreation of another dataSourceConnectionSourceFactory.