i am receiving the error ORA-01008: not all variables bound when i tried to run my logstash configuration file.I dont have any idea about this error.anyone can explain.
input{
jdbc{
clean_run => true
jdbc_driver_library => "C:/Program Files/SQL Developer 4/jdbc/lib/ojdbc8.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "some connection"
jdbc_user => "user"
jdbc_password => "pwd"
statement => "select * from bucket_truck where updated_at >=: sql_last_value"
tracking_column => "updated_at"
use_column_value => true
schedule => "*/2 * * * *"
}
}
output{
elasticsearch{
hosts =>"http://localhost:9200"
index =>"new1"
document_id =>"%{pmd_widget_id}"
document_type => "_doc"
}
stdout{}
}