JDBC input logstash (JTDS support)

Elastic Stack Logstash
1

Any experience using jdbc input with jtds connecting to a SQL server DB ?

I'm having an issue on start that says "are you sure you've included the correct jdbc driver in: jdbc_driver_library? "

jar is in the configured path and Driver name ("net.sourceforge.jtds.jdbc.Driver") is ok (of course jar lib includes the specifierd .class file)

Thank you

2

mind sharing your config?

should work so long as the correct driver is being used and exists within the jar.

3

Config, jtds-1.2.5-spnego.jar includes the class net.sourceforge.jtds.jdbc.Driver.class

jdbc {
jdbc_driver_library => "C:\DeleteMe\jtds-1.2.5-spnego.jar"
jdbc_driver_class => "net.sourceforge.jtds.jdbc.Driver"
jdbc_connection_string => "jdbc:jtds:sqlserver://SERVER:1433;DatabaseName=db;domain=MYDOMAIN"
jdbc_user => "USER"
jdbc_password => "*****"
schedule => " * * * *"
parameters => { "initial_date" => "2015-06-29 00:00:00.000" }
statement => "select EventTime, Value, CounterType from table (nolock) where EventTime > :initial_date and EventTime > :sql_last_start"
type => "stats_DB"
}

4

Anyone has an Idea what the issue can be ?

Using microsoft jdbc driver for SQL server works but I cant use it because a need the domain property in the connection string that jtds supports.

Any ideas ?

5

I'd love to know if anyone has solved this. I need to connect to a Microsoft SQL Server database and have been unable to connect with either the JTDS driver nor the Microsoft driver.