title: Hikaricp log messages in tomcat 8
body: <p>I have installed JNDI Hikaricp 2.4.1 oracle pool connection in tomcat 8.0.28. It works well, but I want to see all log level messages from Hikaricp. Now I only see INFO messages. How can I configure this in tomcat. I don't know a lot how tomcat and hikaricp log system works. This is my configuration:</p>
  
  <p>I have added in $CATALINA_HOME\lib:</p>
  
  <pre><code>HikariCP-2.4.1.jar
  javassist-3.20.0-GA.jar
  slf4j-api-1.7.12.jar
  slf4j-jdk14-1.7.12.jar
  ojdbc6.jar
  </code></pre>
  
  <p>I have added in $CATALINA_HOME\conf\server.xml:</p>
  
  <pre><code>&lt;GlobalNamingResources&gt;
    &lt;Resource name="jdbc/OracleHikari" auth="Container"
      factory="com.zaxxer.hikari.HikariJNDIFactory"
      type="javax.sql.DataSource"
      maximumPoolSize="5"
      connectionInitSql="SELECT 1 FROM dual"
      dataSource.implicitCachingEnabled="true" 
      dataSource.user="xxx"
      dataSource.password="yyy"
      dataSourceClassName="oracle.jdbc.pool.OracleDataSource"
      dataSource.url="jdbc:oracle:thin:@.... "
    /&gt;
  &lt;/GlobalNamingResources&gt;
  </code></pre>
  
  <p>I have added in $CATALINA_HOME\conf\context.xml:</p>
  
  <pre><code>&lt;Context&gt;
    &lt;ResourceLink
      name="jdbc/OracleHikari"
      global="jdbc/OracleHikari"
      type="javax.sql.DataSource"
    /&gt;
  &lt;/Context&gt;
  </code></pre>
  
  <p>I suppose that I have to add something in $CATALINA_HOME\conf\logging.properties, but I don't know what. I have tested with:</p>
  
  <pre><code>com.zaxxer.hikari.apache.juli.AsyncFileHandler.level = FINE
  com.zaxxer.hikari.apache.juli.AsyncFileHandler.directory = 
     ${catalina.base}/logs
  com.zaxxer.hikari.apache.juli.AsyncFileHandler.prefix = manager.
  </code></pre>
  
  <p>but doesn't work.</p>
  
  <p>Thanks</p>