JDBC driver classpath not mapped even i mentioned


(Murugan Mani) #1

Im getting this error even thought i set my driver paths in classpath of jdk(/etc/profile.d/jdk.sh) as export CLASSPATH=$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/db2jcc_license_cisuz.jar:$JAVA_HOME/lib/db2jcc4.jar

Error:
{:timestamp=>"2017-01-30T10:51:50.856000-0600", :message=>"Pipeline aborted due to error", :exception=>#<LogStash::ConfigurationError: com.ibm.db2.jcc.DB2Driver not loaded. :jdbc_driver_library is not set, are you sure you included
the proper driver client libraries in your classpath?>, :backtrace=>["/opt/logstash/indexer/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/plugin_mixins/jdbc.rb:156:in prepare_jdbc_connection'", "/opt/logstash/indexer/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/inputs/jdbc.rb:167:inregister'", "/opt/logstash/indexer/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:330:in start_inputs'", "org/jruby/RubyArray.java:1613:ineach'", "/opt/logstash/indexer/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:329:in start_inputs'", "/opt/logstash/indexer/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:180:instart_workers'", "/opt/logstash/indexer/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:136:in run'", "/opt/logstash/indexer/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/agent.rb:465:instart_pipeline'"], :level=>:error}
{:timestamp=>"2017-01-30T10:51:53.858000-0600", :message=>"stopping pipeline", :id=>"main"}

FYI, the rb file states
def setup_jdbc_config
# 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.**
** 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"`
config :jdbc_driver_class, :validate => :string, :required => true

(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.