Jdbc_static prepared statement error

Elastic Stack Logstash
1

Hello,

I have the below jdbc_static lookup statement but it seems to fail with the error:-
exception=>#<Sequel::Error: Mismatched number of placeholders (2) and placeholder arguments (1) when using placeholder string>, :backt

{
            query => "SELECT b FROM local_table WHERE a = ? OR a = ?"
            prepared_parameters => ["[source][ip]","[destination][ip]"]
            target => "result_array"
            default_hash => {
                "b" => ""
}

Any advice or workaround ?

Thanks in advance!

2

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