# Data from mongodb using logstash via jdbc

**URL:** <https://discuss.elastic.co/t/data-from-mongodb-using-logstash-via-jdbc/235825>\
**Category:** Logstash\
**Created:** [June 4, 2020, 5:48pm UTC](https://discuss.elastic.co/t/data-from-mongodb-using-logstash-via-jdbc/235825 "2020-06-04T17:48:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [June 4, 2020, 5:48pm UTC](https://discuss.elastic.co/t/data-from-mongodb-using-logstash-via-jdbc/235825/1 "2020-06-04T17:48:54Z")

</div>

I am trying to create mongodb-elk connection, read data from mongo and insert in to elk. decided to use jdbc because I can use date and only retrive new data every few minutes

here is my jdbc connection setup. it makes the connection with my sample databse but then it errors. I think it has something to do with null field in mongo. but do not know how to fix it. I google it a lot but can't find how to fix it.

```
jdbc{
     jdbc_driver_library => "/usr/share/logstash/logstash-core/lib/jars/mongojdbc1.6.jar"
     jdbc_driver_class => "com.dbschema.MongoJdbcDriver"
     jdbc_connection_string => "jdbc:mongodb://tst908:27072/Jobs"
    jdbc_user => ""
    jdbc_password => ""
    statement => "db.getCollection('jobs').find({})"
}

```

}

```
[INFO] 2020-06-04 12:05:31.310 [[main]<jdbc] jdbc - (0.694380s) db.getCollection('jobs').find({})
[WARN] 2020-06-04 12:05:31.375 [[main]<jdbc] jdbc - Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::OrgLogstash::MissingConverterException: **Missing Converter handling for full class name=org.bson.types.ObjectId, simple name=ObjectId>}**
[INFO] 2020-06-04 12:05:31.943 [LogStash::Runner] runner - Logstash shut down.
```

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [June 4, 2020, 8:47pm UTC](https://discuss.elastic.co/t/data-from-mongodb-using-logstash-via-jdbc/235825/2 "2020-06-04T20:47:43Z")

</div>

use this and it worked

db.getCollection('jobs').find({},{'\_id': false})

---

<div class="post-metadata">

**Author:** ![Matias\_Perrone](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matias_perrone/32/70830_2.png) [@Matias\_Perrone](https://discuss.elastic.co/u/Matias_Perrone)\
**Post date:** [June 25, 2020, 7:26pm UTC](https://discuss.elastic.co/t/data-from-mongodb-using-logstash-via-jdbc/235825/3 "2020-06-25T19:26:12Z")

</div>

Where did you get the "mongojdbc1.6.jar"?

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [June 25, 2020, 8:50pm UTC](https://discuss.elastic.co/t/data-from-mongodb-using-logstash-via-jdbc/235825/4 "2020-06-25T20:50:01Z")

</div>

> [@Matias\_Perrone](#):
>
> mongojdbc1.6.jar

do not remember from where but quick search shows me

[https://github.com/mfyuce/mongodb-jdbc-driver/find/master](https://github.com/mfyuce/mongodb-jdbc-driver/find/master)

---

<div class="post-metadata">

**Author:** ![Matias\_Perrone](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matias_perrone/32/70830_2.png) [@Matias\_Perrone](https://discuss.elastic.co/u/Matias_Perrone)\
**Post date:** [June 25, 2020, 9:10pm UTC](https://discuss.elastic.co/t/data-from-mongodb-using-logstash-via-jdbc/235825/5 "2020-06-25T21:10:32Z")

</div>

Thanks! I also find I new version (2.0) at [http://www.dbschema.com/jdbc-drivers/MongoDbJdbcDriver.zip](http://www.dbschema.com/jdbc-drivers/MongoDbJdbcDriver.zip) (check the repo README.md file)

---

<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:** [July 23, 2020, 9:10pm UTC](https://discuss.elastic.co/t/data-from-mongodb-using-logstash-via-jdbc/235825/6 "2020-07-23T21:10:33Z")

</div>

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