JDBC Connection to SAP HANA


(CB) #1

Below is my config and I am not able to connect to SAP HANA. I have right driver and am able to connect via standalone java program.
input {
jdbc {

    jdbc_connection_string => "jdbc:sap://<host:port>"
    jdbc_user => "<user>"
jdbc_password => "<password>"
    jdbc_driver_library => "C:/tools/lib/SAP_Hana_ngdbc.jar"
    jdbc_driver_class => "com.sap.db.jdbc.Driver"
    statement => "SELECT * from test"
}

}

Error:

connection_retry_attempts_wait_time=>0.5, parameters=>{"sql_last_value"=>1970-01-01 00:00:00 UTC}, last_run_metadata_path=>"C:\Users\/.logstash_jdbc_last_run", use_column_value=>false, tracking_column_type=>"numeric", clean_run=>false, record_last_run=>true, lowercase_column_names=>true>
Error: Java::JavaSql::SQLException: No suitable driver found for jdbc:sap://host:port
Exception: Sequel::DatabaseConnectionError

Command:

logstash -f logstash.conf --debug --log.level=debug --verbose --config.debug


(system) #2

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