# JDBC Driver to be used to crawl the data from IBM db2 database

**URL:** <https://discuss.elastic.co/t/jdbc-driver-to-be-used-to-crawl-the-data-from-ibm-db2-database/243338>\
**Category:** Logstash\
**Created:** [July 31, 2020, 10:55am UTC](https://discuss.elastic.co/t/jdbc-driver-to-be-used-to-crawl-the-data-from-ibm-db2-database/243338 "2020-07-31T10:55:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohan\_vel](https://avatars.discourse-cdn.com/v4/letter/m/49beb7/32.png) [@Mohan\_vel](https://discuss.elastic.co/u/Mohan_vel)\
**Post date:** [July 31, 2020, 10:55am UTC](https://discuss.elastic.co/t/jdbc-driver-to-be-used-to-crawl-the-data-from-ibm-db2-database/243338/1 "2020-07-31T10:55:26Z")

</div>

Hi All,

I have created a logstash configuration file to crawl the data from IBM Db2. I am getting an issue that JDBC driver libirary is not loaded. Here i am using logstash version 7.7.1.

**Configuration file**

```auto
        input {
        jdbc {
        jdbc_driver_library => ""
        jdbc_driver_class => "com.ibm.db2.jcc.DB2Driver"
        jdbc_connection_string => "jdbc:db2://11:1:1:1:9000/RTEWQSD"
        jdbc_user => "ddddddd"
        jdbc_password => "dddddd"
        statement => "select * from dddddd"
        }
        }
        output {
        stdout { codec => rubydebug }
        }

```

 ![db2drivererr](https://us1.discourse-cdn.com/elastic/original/3X/8/5/8586674ced448a157c809022eafe1e2682534630.png)

Could please some one suggest what is the proper driver should i use to crawl the  
data from IBM DB2 database?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Mohan\_vel](https://avatars.discourse-cdn.com/v4/letter/m/49beb7/32.png) [@Mohan\_vel](https://discuss.elastic.co/u/Mohan_vel)\
**Post date:** [August 11, 2020, 2:45pm UTC](https://discuss.elastic.co/t/jdbc-driver-to-be-used-to-crawl-the-data-from-ibm-db2-database/243338/2 "2020-08-11T14:45:26Z")

</div>

Hi Guys,

Any update on the above mentioned issue?

---

<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:** [September 8, 2020, 2:45pm UTC](https://discuss.elastic.co/t/jdbc-driver-to-be-used-to-crawl-the-data-from-ibm-db2-database/243338/3 "2020-09-08T14:45:29Z")

</div>

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