Jdbc, for getting mssql to Logstash not working :-(

Unfortunately, I can not able to input mssql data base to logstash...
This is my configuration file:

input {
jdbc {
jdbc_driver_library => "/usr/share/logstash/jdbc_driver/sqljdbc_8.4/enu/mssql-jdbc-8.4.1.jre14.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
# mssql jdbc connection string to our database, mydb
jdbc_connection_string => "jdbc:mssql://;databasename:Morakhasi"
# The user we wish to execute our statement as
jdbc_user => "faridTest"
jdbc_password => "---"
schedule => "* * * * *"
# our query to fetch blog details
#statement => "SELECT * from songs where artist = :favorite_artist"
output {
stdout { codec => rubydebug }
elasticsearch {
hosts => "localhost:9200"
index => "mssql"
document_type => "blogs"

PLEASE PLEASE, Somebody help me... (see the attachment photo)

#statement => "SELECT * from songs where artist = :favorite_artist"

The statement is commented out for one. Do you get data if you uncomment it? Try to execute something simple also to test.

statement => "SELECT TOP 1 * from songs"
1 Like

Thank you so much bro for replying...
It is work now, probably... but it seems have issue with the jdbc driver (see the attachment please


It could be dealing with this current issue. I would try that next.

Thank you so much...

1 Like

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