# Which is the recommended sysbse jdbc driver for logstash sybase connectivity?

**URL:** <https://discuss.elastic.co/t/which-is-the-recommended-sysbse-jdbc-driver-for-logstash-sybase-connectivity/94223>\
**Category:** Logstash\
**Created:** [July 23, 2017, 4:19am UTC](https://discuss.elastic.co/t/which-is-the-recommended-sysbse-jdbc-driver-for-logstash-sybase-connectivity/94223 "2017-07-23T04:19:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Axe](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Axe](https://discuss.elastic.co/u/Axe)\
**Post date:** [July 23, 2017, 4:19am UTC](https://discuss.elastic.co/t/which-is-the-recommended-sysbse-jdbc-driver-for-logstash-sybase-connectivity/94223/1 "2017-07-23T04:19:59Z")

</div>

I am using JConn3.1(sybase jdbc driver) which is giving error in registring plugin message.Please let me know if any one have tried using sysbase database.

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [July 24, 2017, 12:01pm UTC](https://discuss.elastic.co/t/which-is-the-recommended-sysbse-jdbc-driver-for-logstash-sybase-connectivity/94223/2 "2017-07-24T12:01:34Z")

</div>

There is an issue using sybase at present. There is no Sybase specific adapter we can use and so a MSSQL adapter is used instead, but this adapter uses a MSSQL specific function to get the DB software version while deciding which syntax to support. Sybase does not have this function and so the connection attempt fails.

NOTE: the problem is not with the JDBC driver, it is with Ruby library that sits in between the input plugin code and the JDBC diver code.

---

<div class="post-metadata">

**Author:** ![Axe](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Axe](https://discuss.elastic.co/u/Axe)\
**Post date:** [August 10, 2017, 4:49pm UTC](https://discuss.elastic.co/t/which-is-the-recommended-sysbse-jdbc-driver-for-logstash-sybase-connectivity/94223/3 "2017-08-10T16:49:45Z")

</div>

jtds-1.3.1 works for sybase db connectivity.

---

<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:** [September 7, 2017, 4:50pm UTC](https://discuss.elastic.co/t/which-is-the-recommended-sysbse-jdbc-driver-for-logstash-sybase-connectivity/94223/4 "2017-09-07T16:50:01Z")

</div>

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