# Logstash, MongoDB and JDBC/UnityJDBC

**URL:** <https://discuss.elastic.co/t/logstash-mongodb-and-jdbc-unityjdbc/62082>\
**Category:** Logstash\
**Created:** [October 3, 2016, 2:57pm UTC](https://discuss.elastic.co/t/logstash-mongodb-and-jdbc-unityjdbc/62082 "2016-10-03T14:57:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DooGZ](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/doogz/32/12272_2.png) [@DooGZ](https://discuss.elastic.co/u/DooGZ)\
**Post date:** [October 3, 2016, 2:57pm UTC](https://discuss.elastic.co/t/logstash-mongodb-and-jdbc-unityjdbc/62082/1 "2016-10-03T14:57:55Z")

</div>

Hi,

Any tips on how to use JDBC to import MongoDB to ES?  
MongoDB: test

Tried using **mongo-java-driver** from [http://mongodb.github.io/mongo-java-driver/3.3/driver/getting-started/installation-guide/](http://mongodb.github.io/mongo-java-driver/3.3/driver/getting-started/installation-guide/)  
Downloaded these files:  
bson-3.3.0.jar  
mongodb-driver-core-3.3.0.jar  
mongo-java-driver-3.3.0.jar

Configuration:  
input {  
jdbc {  
jdbc\_driver\_library =\> "driver/mongodb/mongo-java-driver-3.3.0.jar"  
jdbc\_driver\_class =\> "mongodb.jdbc.MongoDriver"  
jdbc\_connection\_string =\> "jdbc:mongo://192.168.1.50:27017/test"  
jdbc\_user =\> "user"  
jdbc\_password =\> "pass"  
}  
}

**Output:**  
logstash -f mongodb2.conf  
Settings: Default pipeline workers: 4  
←[31mPipeline aborted due to error {:exception=\>"LogStash::ConfigurationError",  
:backtrace=\>["C:/Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bu  
ndle/jruby/1.9/gems/logstash-input-jdbc-3.1.0/lib/logstash/plugin\_mixins/jdbc.rb  
:159:in `prepare_jdbc_connection'", "C:/Users/Michael/Downloads/logstash-2.4.0/l ogstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.1.0/lib/logstas h/inputs/jdbc.rb:187:in`register'", "C:/Users/Michael/Downloads/logstash-2.4.0/  
logstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstas  
h/pipeline.rb:330:in `start_inputs'", "org/jruby/RubyArray.java:1613:in`each'",  
"C:/Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1  
.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:329:in `start_inputs'" , "C:/Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/ 1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:180:in`start\_workers  
'", "C:/Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jrub  
y/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:136:in `run'", "C:/ Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/ge ms/logstash-core-2.4.0-java/lib/logstash/agent.rb:491:in`start\_pipeline'"], :le  
vel=\>:error}←[0m  
stopping pipeline {:id=\>"main"}  
The signal HUP is in use by the JVM and will not work correctly on this platform

Also tried using **UnityJDBC** driver with this configuration:  
input {  
jdbc {  
jdbc\_driver\_library =\> "C:/Program Files/UnityJDBC/mongodb\_unityjdbc\_full.jar"  
jdbc\_driver\_class =\> "mongodb.jdbc.MongoDrivers"  
jdbc\_connection\_string =\> "jdbc:mongo://192.168.1.50:27017/test"  
jdbc\_user =\> "user"  
jdbc\_password =\> "pass"  
}  
}

**Output:**  
logstash -f mongodb.conf  
Settings: Default pipeline workers: 4  
←[31mPipeline aborted due to error {:exception=\>"LogStash::ConfigurationError",  
:backtrace=\>["C:/Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bu  
ndle/jruby/1.9/gems/logstash-input-jdbc-3.1.0/lib/logstash/plugin\_mixins/jdbc.rb  
:159:in `prepare_jdbc_connection'", "C:/Users/Michael/Downloads/logstash-2.4.0/l ogstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.1.0/lib/logstas h/inputs/jdbc.rb:187:in`register'", "C:/Users/Michael/Downloads/logstash-2.4.0/  
logstash-2.4.0/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstas  
h/pipeline.rb:330:in `start_inputs'", "org/jruby/RubyArray.java:1613:in`each'",  
"C:/Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1  
.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:329:in `start_inputs'" , "C:/Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/ 1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:180:in`start\_workers  
'", "C:/Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jrub  
y/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:136:in `run'", "C:/ Users/Michael/Downloads/logstash-2.4.0/logstash-2.4.0/vendor/bundle/jruby/1.9/ge ms/logstash-core-2.4.0-java/lib/logstash/agent.rb:491:in`start\_pipeline'"], :le  
vel=\>:error}←[0m  
stopping pipeline {:id=\>"main"}  
The signal HUP is in use by the JVM and will not work correctly on this platform

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [October 3, 2016, 9:09pm UTC](https://discuss.elastic.co/t/logstash-mongodb-and-jdbc-unityjdbc/62082/2 "2016-10-03T21:09:14Z")

</div>

Don't you need to use `\` on windows? Also I don't think you can use spaces in paths for the driver?

---

<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 6, 2017, 4:36am UTC](https://discuss.elastic.co/t/logstash-mongodb-and-jdbc-unityjdbc/62082/3 "2017-07-06T04:36:00Z")

</div>