Logstash query no output data

[hustlercoder (Andrei Borcea)]

Hi there i had some trouble with my logstash configuration.Basically i create a conf file with a basic jdbc connection to a postgresql database.
I also had other 3 files...4 in total...2 works 2 no...but i cant explain why.
input {
jdbc {
type=>"temp_products"
jdbc_connection_string => "jdbc:postgresql://ip/DB"
jdbc_user => "user"
jdbc_password => "pass"
jdbc_validate_connection => true
jdbc_driver_library => "/usr/share/logstash/postgresql_42_2_5.jar"
jdbc_driver_class => "org.postgresql.Driver"
statement=> "select * from product_template where id=95181"
}
}
output {
if [type]=="temp_products"{
stdout { codec => json_lines }
}
}
When i run logstash the query run..i can se the log about the execution in console but no result no output as defined in the output section.

[guyboertje]

Please post all 4 configs, stating which works and which does not.