Connection pool without using Spring Framework

Camunda 7 Topics Discussion & Questions
1

Following up on an earlier post here https://forum.camunda.io/t/async-jobs-taking-time-in-the-order-of-seconds/39441

We are using Google Guice DI so we do not want to use spring framework at this time. However we are seeing latency issues when submitting workflows to the Process Engine even do it asynchronously. We belive it could be because do not have the right JDBC connection pool setting. What is the best way to configure Connection pool without Spring.

I have used Oracle UCP for connection pooling but do not seem to get any benefits. I am doing it the right way.

import oracle.ucp.jdbc.PoolDataSource;
import oracle.ucp.jdbc.PoolDataSourceFactory;


 PoolDataSource poolDataSource = PoolDataSourceFactory.getPoolDataSource();
        poolDataSource.setConnectionFactoryClassName(CONN_FACTORY_CLASS_NAME);
        poolDataSource.setURL(camundaDatabaseConfig.getJdbcUrl());
        poolDataSource.setUser(camundaDatabaseConfig.getUsername());
        poolDataSource.setPassword(camundaDatabaseConfig.getPassword());
        poolDataSource.setConnectionPoolName("JDBC_UCP_POOL");

        poolDataSource.setInitialPoolSize(200);

        poolDataSource.setMinPoolSize(200);

        poolDataSource.setMaxPoolSize(200);
        connection = poolDataSource.getConnection();
        PooledDataSource pooledDataSource= org.apache.ibatis.datasource.pooled.PooledDataSourceFactory.get
        log.debug("Connection established {}", connection.isClosed());
        processEngineConfiguration = new TicketingProcessEngineConfiguration(injector);
        processEngineConfiguration
                .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE)
                .setProcessEngineName(camundaConfig.getProcessEngineName())
                .setJdbcMaxActiveConnections(camundaDatabaseConfig.getJdbcMaxActiveConnections())
                .setJdbcMaxIdleConnections(camundaDatabaseConfig.getJdbcMaxIdleConnections())
                .setHistory(HISTORY_NONE)
                //                .setJdbcUrl(camundaDatabaseConfig.getJdbcUrl())
                //                .setJdbcUsername(camundaDatabaseConfig.getUsername())
                //                .setJdbcPassword(camundaDatabaseConfig.getPassword())
                .setDataSource(poolDataSource)
2