What is the supported jdbc driver to connect sybase 16.0 from logstash 7.20

Elastic Stack Logstash
1

Hi,

Iam trying to connect to sybase database by using below mentioned details in conf file but it is giving error as
"[ERROR][logstash.inputs.jdbc ] Unable to connect to database. Tried 1 times {:error_message=>"Java::JavaSql::SQLException: No suitable driver found for jdbc:sybase://Hostname:PORT"}
{ rufus-scheduler intercepted an error:
job:
Rufus::Scheduler::CronJob "* * * * *" {}
error:
2016
Sequel::DatabaseConnectionError
Java::JavaSql::SQLException: No suitable driver found for jdbc:sybase://Hostname:PORT
java.sql.DriverManager.getConnection(java/sql/DriverManager.java:689)
java.sql.DriverManager.getConnection(java/sql/DriverManager.java:247)
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)
"

Conf file details :
jdbc_connection_string => "jdbc:sybase://Hostname:PORT"
jdbc_user => "user"
jdbc_password => "passwd"
jdbc_driver_library => "/opt/logstash/ELK/drivers/jconn3.jar"
jdbc_driver_class => "com.sybase.jdbc3.jdbc.SybDriver"

Is there any error in connection string ? pls help me in getting connectivity.

Thanks in advance

2

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