Configure HikariCp dataSource with HikariConfig in mybatis in xml mapper configuration

Question

I am trying to configure HikariCp in mybatis using xml configuration

I want to know hoe to set the hikariCongig object in object in the mapper configuration.

my config looks like this :

<environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="com.xyz.config.HikariCPDataSourceFactory" >
                <property name="jdbcUrl" value="jdbc:postgresql://localhost:5432/beta-prod-db" />
                <property name="username" value="postgres" />
                <property name="password" value="${password}" />
                <property name="poolName" value="test"/>
                <property name="maxPoolSize" value="20" />
                <property name="registerMbeans" value="true"/>
                <property name="minimumIdle" value="5"/>
            </dataSource>
        </environment>

HikariCPDataSourceFactory.java

public class HikariCPDataSourceFactory extends PooledDataSourceFactory {
    public HikariCPDataSourceFactory() {
        //HikariConfig hikariConfig = new HikariConfig();
        this.dataSource = new HikariDataSource();
    }
}

i dont find any online article hat shows how to set the hikariConfig object in hikarIDataSource object through xml configuration.

using Spring i can crearte a bean for hikariConfig and pass it as a parameter in hikariDataSource object , but here i am not using spring so need to find a way with xml.

Without hikariConfig object if i try to get the HikariPoolMXBean object from datSource i get the exception org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.IllegalArgumentException: dataSource or dataSourceClassName or jdbcUrl is required.

HikariCP 1.4.0 MBean InstanceNotFoundException

this article says it only works when i set the hikariConfig Object

See if answers help https://stackoverflow.com/questions/23172643/how-to-set-up-datasource-with-spring-for-hikaricp/24500712#24500712 — user7294900, Jun 06 '21 at 14:47

score 0 · Answer 1 · answered Jun 19 '21 at 08:26

i couldnt find a way to configure the hikariConfig in xml Here is the workaround i used that works well for me.

  HikariDataSource hikariDataSource = null;
  HikariConfig hikariConfig = new HikariConfig();
  dataSource.copyStateTo(hikariConfig);
  hikariDataSource = new HikariDataSource(hikariConfig);

once i get the dataSource object i copy the state to a hikariConfig object and create new dataSource object using it. Also we can make it singleton so only one instance is created.

Configure HikariCp dataSource with HikariConfig in mybatis in xml mapper configuration

1 Answers1