title: com.mysql.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library
body: <p>I am getting java version and mysql-connect-java.jar compatibility issue with logstash.</p>
  
  <p>can any one tell me which version of mysql-connect-java.jar is compatible with which version of java?</p>
  
  <p>Error:</p>
  
  <pre><code>com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
  </code></pre>
  
  <p>my current java version is </p>
  
  <pre><code>openjdk version "1.8.0_212"
  OpenJDK Runtime Environment (build 1.8.0_212-8u212-b03-0ubuntu1.16.04.1-b03)
  OpenJDK 64-Bit Server VM (build 25.212-b03, mixed mode)
  </code></pre>
  
  <p>I have tried with below mysql connector jar files but every one fails.</p>
  
  <pre><code>mysql-connector-java-8.0.16.jar
  mysql-connector-java-8.0.15.jar
  mysql-connector-java-6.0.5.jar
  mysql-connector-java-5.1.46.jar
  mysql-connector-java-5.1.4.jar
  </code></pre>
  
  <p>Logstash config file is mysql.conf</p>
  
  <pre><code>input {
      jdbc {
          jdbc_connection_string =&gt; "jdbc:mysql://localhost:3306/prbi"
          jdbc_user =&gt; "root"
          jdbc_password =&gt; ""
          jdbc_driver_library =&gt; "mysql-connector-java-8.0.15.jar" #tried above every jar
          jdbc_driver_class =&gt; "com.mysql.cj.jdbc.Driver" #tried com.mysql.jdbc.Driver too
          schedule =&gt; "* * * * *"
          use_column_value =&gt; true
          tracking_column =&gt; "%{id}"
          clean_run =&gt; true
          statement =&gt; "SELECT * from tmp_j_summaryrepor"
      }
  }
  output {
      elasticsearch {
      hosts =&gt; ['http://localhost:9200']
      index =&gt; "prsummaryreport"
      document_type =&gt; "prsummaryreport"
      document_id =&gt; "%{id}" # It is a Primary Key of table
      }
      stdout { codec =&gt; json_lines } 
  }
  </code></pre>