Error in JDBC connection using logstash

Question

I am trying to get my sqlserver table into Elasticsearch using Logstash. For that i have created below configuration file.

input {
  jdbc { 
    jdbc_connection_string => "jdbc:sqlserver://xxx.xxx.x.xxx:1433/DB_name"
    jdbc_user => "devuser"
    jdbc_password => "devuser"
    jdbc_driver_library => "D:/Mssqljdbc/sqljdbc4-2.0.jar"
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    statement => "SELECT * FROM sample"
    }
  }
output {
  stdout { codec => json_lines }
  elasticsearch {
  hosts => "localhost"
  index => "testmigrate"
  document_type => "data"
  }
}

then i am using bin\logstash -f sqltable.conf to execute it. But i am getting

Error: Java::ComMicrosoftSqlserverJdbc::SQLServerException: The port number 1433/DB_name is not valid.

i checked i am able to ping the particular ip address and the port is also openbut still i am getting the same error. Please help

Ironman · Accepted Answer · 2018-05-17 10:05:10Z

1

After a bit of digging i did a small change and it worked for me. I added databaseName in front of the DB_name.

input {
  jdbc { 
    jdbc_connection_string => "jdbc:sqlserver://xxx.xxx.x.xxx:1433;databaseName=DB_name"
    jdbc_user => "devuser"
    jdbc_password => "devuser"
    jdbc_driver_library => "D:/Mssqljdbc/sqljdbc4-2.0.jar"
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    statement => "SELECT * FROM sample"
    }
  }
output {
  stdout { codec => json_lines }
  elasticsearch {
  hosts => "localhost"
  index => "testmigrate"
  document_type => "data"
  }
}

It is quite strange i didn't found this in any of the documentation.

answered May 17, 2018 at 10:05

Ironman

1,4102 gold badges21 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in JDBC connection using logstash

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related