title: How to configure datasource with HikariCP in Spring @Configuration class?
body: <p>I'm trying to configure HikariCP datasource in Spring @Configuration class[Database being oracle]. But it's not working.</p>
  
  <p>I searched in the internet and found that HikariCP datasource needs to be configured with constructor. I have tried this [the way it's mentioned in their github webpage], but it still not working. Please help me in solving this problem.</p>
  
  <pre><code>private HikariDataSource dataSource() {
      final HikariDataSource ds = new HikariDataSource();
      ds.setMaximumPoolSize(100); 
      ds.setDataSourceClassName("oracle.jdbc.driver.OracleDriver"); 
      ds.addDataSourceProperty("url", "jdbc:oracle:thin:@localhost:1521:XE"); 
      ds.addDataSourceProperty("user", "username");
      ds.addDataSourceProperty("password", "password");
      ds.addDataSourceProperty("cachePrepStmts", true); 
      ds.addDataSourceProperty("prepStmtCacheSize", 250); 
      ds.addDataSourceProperty("prepStmtCacheSqlLimit", 2048); 
      ds.addDataSourceProperty("useServerPrepStmts", true);
      return ds;
  } 
  </code></pre>