CODEWITHSUNDEEP
logstashlogstash-configurationlogstash-jdbc
Mahendra kanoujiya
Mahendra kanoujiya

Reputation: 11

[ERROR][logstash.outputs.jdbc ] Unknown setting 'driver_library' for jdbc

I want to Add My CSV File to postgreSQL.but whenever i try to connect it Show Error: [ERROR][logstash.outputs.jdbc ] Unknown setting 'driver_library' for jdbc it is My Config.conf File

input {
  file {
    path => "C:/Users/Desktop/Input.csv"
    start_position => "beginning"
    codec => plain
  }
}
filter {
  csv {
    separator => ","
    columns => ["Column","Metric","Source_Table","Output_Column_Alias","Method"]
  }
}
output {
  jdbc {
    connection_string => "jdbc:postgresql://hostname:5432/Database"
    username => "User"
    password => "Password"
    driver_library => "C:/Users/lib/postgresql-42.5.1.jar"
    driver_class => "org.postgresql.Driver"
    statement => "INSERT INTO CSV_to_Postgresql (Column,Metric,Source_Table,Output_Column_Alias,Method) VALUES (?, ?, ?, ?, ?)"
  }
}```

Upvotes: 0

Views: 318

Answers (1)

Badger
Badger

Reputation: 4072

Use driver_jar_path, not driver_library. The elastic supported plugins use jdbc_driver_library as the name of this option, but the jdbc output is a third party supported plugin which uses different conventions.

Upvotes: 0

Related Questions