# Logstash JDBC input - no suitable driver

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-input-no-suitable-driver/120701>\
**Category:** Logstash\
**Created:** [February 20, 2018, 6:04pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-no-suitable-driver/120701 "2018-02-20T18:04:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![db2oracle](https://avatars.discourse-cdn.com/v4/letter/d/77aa72/32.png) [@db2oracle](https://discuss.elastic.co/u/db2oracle)\
**Post date:** [February 20, 2018, 6:04pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-no-suitable-driver/120701/1 "2018-02-20T18:04:46Z")

</div>

Hi All

Does Logstash JDBC plugin ONLY support certain JDBC drivers - and that is fixed in code somehow.

Using an input configuration for Mysql - I get past an error relating to no suitable driver - but I am  
trying to use a Progress openedge type 4 jdbc driver (We use same with our Java applications) and  
I get no suitable driver.

So the below has the correct type 4 driver jar, correct Class name, correct URL.

It looks like either the plugin does not register the library or does not understand the jdbc\_connection\_string - regardless of what I do.

So I wondered if the plugin was actually coded to look for only specific types of jdbc URL etc.

e.g.

input {  
jdbc {  
id =\> "pro114"  
jdbc\_connection\_string =\> "jdbc:datadirect:openedge://localhost:1111;databaseName=hr;EncryptionMethod=ssl;validateServerCertificate=true"  
jdbc\_user =\> "USER"  
jdbc\_password =\> "PASSWORD"  
jdbc\_driver\_library =\> "/usr/share/logstash/jar/openedge.jar"  
jdbc\_driver\_class =\> "com.ddtek.jdbc.openedge.OpenEdgeDriver"  
#schedule =\> "\*/1 \* \* \* \*"  
statement =\> "SELECT \* from pub.opgohead;"  
}  
}

---

<div class="post-metadata">

**Author:** ![Rami.Atieyeh](https://avatars.discourse-cdn.com/v4/letter/r/41988e/32.png) [@Rami.Atieyeh](https://discuss.elastic.co/u/Rami.Atieyeh)\
**Post date:** [February 21, 2018, 7:05am UTC](https://discuss.elastic.co/t/logstash-jdbc-input-no-suitable-driver/120701/2 "2018-02-21T07:05:14Z")

</div>

I think that might be the case.  
I am trying to connect to a different database engine via JDBC, and I am getting the same error.  
See: [FileMaker jdbc input error](https://discuss.elastic.co/t/filemaker-jdbc-input-error/120599)

---

<div class="post-metadata">

**Author:** ![db2oracle](https://avatars.discourse-cdn.com/v4/letter/d/77aa72/32.png) [@db2oracle](https://discuss.elastic.co/u/db2oracle)\
**Post date:** [February 23, 2018, 10:30am UTC](https://discuss.elastic.co/t/logstash-jdbc-input-no-suitable-driver/120701/3 "2018-02-23T10:30:08Z")

</div>

Hi Rami

I have found the issue for Progress but may be applicable to yours.  
If you are using a type 4 jdbc driver - put the jar file into the logstash-core/libs/jar/... Folder.

It seems to ignor in the core loading it - however you still need the entry to point to a valid file.

This then registered the driver and I was able to move on.

thanks

Kevin

---

<div class="post-metadata">

**Author:** ![Rami.Atieyeh](https://avatars.discourse-cdn.com/v4/letter/r/41988e/32.png) [@Rami.Atieyeh](https://discuss.elastic.co/u/Rami.Atieyeh)\
**Post date:** [February 23, 2018, 11:15am UTC](https://discuss.elastic.co/t/logstash-jdbc-input-no-suitable-driver/120701/4 "2018-02-23T11:15:27Z")

</div>

Hi Kevin,  
Your solution worked for me.  
Thank you!!

---

<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:** [March 23, 2018, 11:15am UTC](https://discuss.elastic.co/t/logstash-jdbc-input-no-suitable-driver/120701/5 "2018-03-23T11:15:31Z")

</div>

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