Jtds error


#1

file: contacts-index-logstash.conf

input {
jdbc {
jdbc_connection_string => "jdbc:jtds:sqlserver://host:port/database"
jdbc_user => "username"
jdbc_password => "password"
jdbc_validate_connection => true
jdbc_driver_library => "D:\logstash-2.0.0\Easy Search\sqljdbc42.jar"
jdbc_driver_class => "Java::net.sourceforge.jtds.jdbc.Driver"
statement => "my sql statement"
}
}
output {
elasticsearch {
index => "testdb"
document_type => "qa"
hosts => "127.0.0.1:9200"
}
}

i am getting Java::net.sourceforge.jtds.jdbc.Driver not loaded.
i am using LS 2.0.0 and java 1.8


(Mark Walkom) #2

Is that the right path to the JDBC library?


#3

Solved !
thankyou warkolm :blush:


(system) #4