Connection Pool size

[Michael Patalano]

Is there any documentation for rundeck on setting connection pool sizes? All I could find from various github issues were the following:

dataSource.pooled=true

dataSource.properties.removeAbandoned=true

dataSource.properties.removeAbandonedTimeout=300

dataSource.properties.testOnBorrow=true

[Greg Zapp]

Hi Michael,

I just had a look and couldn't find anything myself either oddly enough.. Rundeck comes bundled with and utilizes the Apache Tomcat JDBC Connection Pool though, so all of those settings should be applicable: https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html .

[Reiner Acuña]

Hi Michael,

Maybe a good idea is to add some "advanced parameters" to documentation.

Also, take a look:

https://www.codepedia.org/ama/tomcat-jdbc-connection-pool-configuration-for-production-and-development/

Thanks for your feedback!

[Michael Patalano]

I've looked on that page and anytime I set `dataSource.properties.removeAbandonedTimeout=300` (or even the default value) and some of other properties, I get NullPointerExceptions when starting up rundeck. Similar when setting maxActive, maxIdle, etc.

[Michael Patalano]

```
[2019-10-30 15:38:21.769]  WARN AnnotationConfigEmbeddedWebApplicationContext --- [           main] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'requestMappingHandlerMapping' defined in org.springframework.web.servlet.config.annotation.DelegatingWebMvcConfiguration: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'grailsInterceptorMappedInterceptor': Cannot create inner bean '(inner bean)#57ce8f63' of type [org.grails.plugins.web.interceptors.GrailsInterceptorHandlerInterceptorAdapter] while setting constructor argument; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name '(inner bean)#57ce8f63': Unsatisfied dependency expressed through method 'setInterceptors' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'controllerBaseInterceptor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'uiPluginService': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pluginService': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'frameworkService': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'executionService': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'storageService': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authRundeckStorageTree': Cannot resolve reference to bean 'rundeckStorageTree' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'rundeckStorageTree': Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.dtolabs.rundeck.core.storage.StorageTree]: Factory method 'createTree' threw exception; nested exception is java.lang.NullPointerException

[2019-10-30 15:38:21.819] ERROR SpringApplication --- [           main] Application startup failed

```

[Michael Patalano]

This was an issue with a completely different argument in this config file that shouldn't have been there. Odd that it only caused issues some times, but definitely fixed my problem.

https://github.com/rundeck/rundeck/issues/5436

[Reiner Acuña]

Good news then, Michael.

Regards!