hi all, I am using following logstash.conf file: input { jdbc { jdbc_driver_library => "F:\driver\sqljdbc_6.0\enu\jre8\sqljdbc42.jar" jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver" jdbc_connection_string => "jdbc:sqlserver://local:3333;databaseName=TotalTXN" jd…

[image] sahere37: parameters => {"mine" => "%{s_date}"} I believe you're looking for: parameters => {"mine" => "s_date"} The key/value map supplied by parameters matches a SQL-parameter name to a Event-field name, not a sprtintf template.

Discuss the Elastic Stack

How can use a field in jdbc statement of jdbc streaming

Elastic Stack Logstash

sahere37 (LR) February 27, 2019, 5:01am 3

Many thanks. it works

Topic		Replies	Views
Logstash jdbc_streaming, sql statement Logstash	1	384	March 24, 2019
Jdbc_streaming statement using a field from input? Logstash	1	197	September 18, 2022
Jdbc_streaming filter help Logstash	2	1502	September 4, 2018
Can statement in jdbc_streaming filter using a field from input? Logstash	1	908	October 26, 2017
Problem using jdbc streaming Logstash	1	539	June 19, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

How can use a field in jdbc statement of jdbc streaming

Related topics