# \[Logstash\] \[JDBC\] \[mongoDB\] MissingConverterException for date fields

**URL:** https://discuss.elastic.co/t/logstash-jdbc-mongodb-missingconverterexception-for-date-fields/175242
**Category:** Logstash
**Created:** [April 3, 2019, 4:04pm UTC](https://discuss.elastic.co/t/logstash-jdbc-mongodb-missingconverterexception-for-date-fields/175242 "2019-04-03T16:04:45Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![zaratustra689](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zaratustra689/32/43118_2.png) [@zaratustra689](https://discuss.elastic.co/u/zaratustra689)
#### Post date: [April 3, 2019, 4:04pm UTC](https://discuss.elastic.co/t/logstash-jdbc-mongodb-missingconverterexception-for-date-fields/175242/1 "2019-04-03T16:04:45Z")

</div>

Hello!

I was trying to connect **mongoDB** with **Logstash** , but when a collection has **fields with dates** , Logstash logs show me this error and does not create the index or input data.

I'm using **Logstash version 6.7.0**

```auto
[WARN][logstash.inputs.jdbc] Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::OrgLogstash::MissingConverterException: Missing Converter handling for full class name=java.util.Date, simple name=Date>}

```

In the input's section of the _logstash.conf_ file I am using JDBC plugin and connecting it to my mongoDB.  
The query I'm running retrieves the following data example:  
Query:

```auto
db.guides.find({_id: false}) # exclude id

```

Collection data example

```auto
{ "_id" : someid, 
  "organization" : "central", 
  "course" : "central/2000-k20000", 
  "slug" : "colegio/mumuki-guia-fundamentos-primeros-programas", 
  "updated_at" : ISODate("2019-03-29T20:03:39.403Z"), 
  "created_at" : ISODate("2019-03-29T20:03:39.194Z"), 
  "language" : { "name" : "gobstones" }, 
  "name" : "Primeros Programas", 
  "parent" : { "type" : "Lesson", 
                "name" : "Primeros Programas", 
                "position" : 1, 
                "chapter" : { "id" : 97, 
                              "name" : "Fundamentos" 
                            } 
              } 
}

```

The thing is that the fields **"created\_at"** and **"updated\_at"** contains dates, and Logstash or JDBC plugin (I'm not sure) are failing showing me the error above...

So when I run the query in the following way:

```auto
db.guides.find({_id: false, created_at: false, updated_at: false}) # exclude id, and date fields

```

The query is correctly run and the data reach elasticseach and kibana, creating the indices.

Any ideas about this?

Note: MongoDB driver and connector I am using are [these](https://www.dbschema.com/jdbc-drivers/MongoDbJdbcDriver.zip).

---

<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: [May 1, 2019, 4:04pm UTC](https://discuss.elastic.co/t/logstash-jdbc-mongodb-missingconverterexception-for-date-fields/175242/2 "2019-05-01T16:04:49Z")

</div>

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