Jdbc-streaming plugin seems not working

jdbc_streaming {
jdbc_driver_library => ".............."
jdbc_driver_class => "................."
jdbc_connection_string => "............."
jdbc_user => "........"
jdbc_password => "........"
statement => "SELECT field5 From database2 where field4 =:..."
parameters => {...=>"field2"}
target => "code"
use_cache => "true"
cache_expiration => "5"
cache_size => "100"

}
i make this configuration but still confused about field2val

Yes you can not use the word field2val in the query string. But you still have to provide a parameters mapping - this is because we do not "parse" the query string to extract the possible field names to use.
Consider this:

statement => "select field5 from database2 where field 4 = :field2 and field6 LIKE :like3"
parameters => {"field2" => "field2", "like3" => "%{[field3]}%" }
1 Like

This thread from @Vittorio has been hijacked by @Dror_Bletter and @nano (chaps, in future start a new discussion and link back to this one)

@Dror_Bletter
Please start a new discussion about your useragent trouble so we can better help you with that. Then we can move back to the jdbc streaming trouble.

Hi!

FYI -
I solved the problem by placing the jdbc_streaming in the right place in the logstash configuration (and not on top).

Thanks for all your help!

1 Like

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