title: Connection Pool using HikariCP for SnowFlake
body: <p>I am trying to test connection pool using HikariCP against SnowFlake.</p>
  <p>I have kept the pool size and idle size, both, set to 5. However I observed that while getting a connection, every time its creating a new connection. For example , If i make 8 connection, i could see 8 test sql query being executed on Snowflake (I checked it in history.). My expectation was it should not create more that 5 (pool size) connection and this is justified by only 5 test sql query on snowflake.</p>
  <p>Does anyone have any clue?</p>
  <p><strong>Configuration:</strong>
  micronaut:
  application:
  name: mnsfpoc
  netty:
  default:
  allocator:
  max-order: 3</p>
  <p>datasources:
  default:
  url: jdbc:snowflake://xxx.azure.snowflakecomputing.com/?warehouse=xx&amp;db=xx&amp;schema=xx&amp;role=xx
  username: xxxx
  password: xxxx
  driverClassName: net.snowflake.client.jdbc.SnowflakeDriver
  maximum-pool-size: 5
  minimum-idle: 5
  pool-name: mnsfconn-pool
  connection-test-query: select 3</p>
  <p><strong>Code to get connection:</strong></p>
  <p>@Singleton
  public class RestDao extends BaseDao {</p>
  <pre><code>@Inject
  private DataSource dataSource;
  
  public String greet(String name) throws Exception {
      Connection conn1 = dataSource.getConnection();
      close(conn1);
      return &quot;Hello &quot; + name + &quot;!!&quot;;
  }
  </code></pre>
  <p>}</p>
  <p>Thanks
  Rakhs</p>