# JDBC issue after upgrade to 7.5

**URL:** <https://discuss.elastic.co/t/jdbc-issue-after-upgrade-to-7-5/214096>\
**Category:** Logstash\
**Created:** [January 7, 2020, 4:14pm UTC](https://discuss.elastic.co/t/jdbc-issue-after-upgrade-to-7-5/214096 "2020-01-07T16:14:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ginu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ginu/32/86297_2.png) [@ginu](https://discuss.elastic.co/u/ginu)\
**Post date:** [January 7, 2020, 4:14pm UTC](https://discuss.elastic.co/t/jdbc-issue-after-upgrade-to-7-5/214096/1 "2020-01-07T16:14:39Z")

</div>

Hi all,  
We have a logstash pipeline which is configured to collect data from Vertica Analytic v9.0.1-20190201 ([https://www.vertica.com/](https://www.vertica.com/))... it all worked well with the logstash version 7.4. with the configureation

```
jdbc {
    jdbc_validate_connection => true
    jdbc_connection_string => "jdbc:vertica://xx.xx.xx.xx:5433/myDB"
    jdbc_user => "xxxx"
    jdbc_password => "xxxx"
    jdbc_driver_library => "/opt/vertica/java/lib/vertica-jdbc-9.3.0-0.jar"
    jdbc_driver_class => "com.vertica.jdbc.Driver"
    statement => "SELECT * FROM FOO WHERE event_start > TIMESTAMPADD (n, -15, CURRENT_TIMESTAMP);"
    }

```

But since we upgraded to version 7.5 we are getting errors:  
`Unable to find driver class via URLClassLoader in given driver jcom.vertica.jdbc.Driver and com.vertica.jdbc.Driver`

Any Idea how can we solve this?

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [January 7, 2020, 4:21pm UTC](https://discuss.elastic.co/t/jdbc-issue-after-upgrade-to-7-5/214096/2 "2020-01-07T16:21:16Z")

</div>

Is [this](https://github.com/logstash-plugins/logstash-input-jdbc/issues/355) issue related?

---

<div class="post-metadata">

**Author:** ![ginu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ginu/32/86297_2.png) [@ginu](https://discuss.elastic.co/u/ginu)\
**Post date:** [January 7, 2020, 4:48pm UTC](https://discuss.elastic.co/t/jdbc-issue-after-upgrade-to-7-5/214096/3 "2020-01-07T16:48:29Z")

</div>

Thank you Badger... that helped!

---

<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:** [February 4, 2020, 4:48pm UTC](https://discuss.elastic.co/t/jdbc-issue-after-upgrade-to-7-5/214096/4 "2020-02-04T16:48:46Z")

</div>

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