HikariConfig pool for Oracle

Question

I want to configure HikariConfig pool for Oracle:

Properties props = new Properties();
        props.setProperty("dataSourceClassName",     "oracle.jdbc.driver.OracleDriver");
        props.setProperty("dataSource.user",         bundle.getString("db.user"));
        props.setProperty("dataSource.password",     bundle.getString("db.password"));
        props.setProperty("dataSource.databaseName", "xe");

        config = new HikariConfig(props);
        ds = new HikariDataSource(config);

But I got this error

Exception in thread "main" java.lang.RuntimeException: java.lang.ClassCastException: Cannot cast oracle.jdbc.driver.OracleDriver to javax.sql.DataSource
    at com.zaxxer.hikari.util.UtilityElf.createInstance(UtilityElf.java:93)
    at com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:339)
    at com.zaxxer.hikari.pool.PoolBase.<init>(PoolBase.java:118)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:106)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
    at 

Brash

Answer 1

you are trying to set driver to datasouce class.

This is how I do,

        HikariConfig config = new HikariConfig();
        config.setMaximumPoolSize(10);
        config.setMinimumIdle(5);
        config.setDriverClassName("org.hsqldb.jdbc.JDBCDriver");
        config.setJdbcUrl("jdbc:hsqldb:hsql://localhost/");
        config.addDataSourceProperty("user", "SA");
        config.addDataSourceProperty("password", "");

        HikariDataSource ds = new HikariDataSource(config);
        System.out.print("Data source created");
        Connection conn = ds.getConnection();

Altair