# JDBC driver classpath not mapped even i mentioned

**URL:** <https://discuss.elastic.co/t/jdbc-driver-classpath-not-mapped-even-i-mentioned/73250>\
**Category:** Logstash\
**Created:** [January 30, 2017, 5:10pm UTC](https://discuss.elastic.co/t/jdbc-driver-classpath-not-mapped-even-i-mentioned/73250 "2017-01-30T17:10:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gmmurugan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gmmurugan/32/12488_2.png) [@gmmurugan](https://discuss.elastic.co/u/gmmurugan)\
**Post date:** [January 30, 2017, 5:10pm UTC](https://discuss.elastic.co/t/jdbc-driver-classpath-not-mapped-even-i-mentioned/73250/1 "2017-01-30T17:10:52Z")

</div>

**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:in`register'", "/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:in`each'", "/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:in`start\_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:in`start\_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
```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 27, 2017, 5:11pm UTC](https://discuss.elastic.co/t/jdbc-driver-classpath-not-mapped-even-i-mentioned/73250/2 "2017-02-27T17:11:30Z")

</div>

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