logstash jdbc_driver_library问题

mysql问题：

com.mysql.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?

Unable to find driver class via URLClassLoader in given driver jars: com.mysql.jdbc.Driver and com.mysql.jdbc.Driver

 

解决方案：

可以尝试将驱动器即mysql-connector-java-xxxx-bin.jar拷贝到 logstash目录\logstash-core\lib\jars 下，上述问题就可解决。

 

 

oracle问题：

oracle.jdbc.driver.OracleDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library

解决方案：

同理可以尝试将驱动器即ojdbc6.jar拷贝到 logstash目录\logstash-core\lib\jars 下，上述问题就可解决。如果还有问题修改配置

jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"

注意是首字母大写，有两个冒号Java::

 

还有问题可以查看logstash的jdbc连接文件注释说明：

logstash-7.5.0\vendor\bundle\jruby\2.5.0\gems\logstash-input-jdbc-4.3.16\lib\logstash\plugin_mixins\jdbc\jdbc.rb

# JDBC driver library path to third party driver library. In case of multiple libraries being
# required you can pass them separated by a comma.
#
# If not provided, Plugin will look for the driver class in the Logstash Java classpath.
#翻译：如果没有提供，Plugin将在Logstash Java类路径中查找驱动程序类
config :jdbc_driver_library, :validate => :string

# JDBC driver class to load, for exmaple, "org.apache.derby.jdbc.ClientDriver"
# NB per https://github.com/logstash-plugins/logstash-input-jdbc/issues/43 if you are using
# the Oracle JDBC driver (ojdbc6.jar) the correct `jdbc_driver_class` is `"Java::oracle.jdbc.driver.OracleDriver"`
#翻译：Oracle JDBC驱动程序（ojdbc6.jar）正确的“JDBC驱动程序”是“Java::Oracle.JDBC.driver.OracleDriver”`
config :jdbc_driver_class, :validate => :string, :required => true