Anyone knows SQL INSERT ??
my jdbc output config is this :
output {
if([parsedCon] and [parsedSr]){
elasticsearch{
index => "parse"
hosts => "localhost:9200"
}
}
stdout {
codec => rubydebug
}
jdbc {
connection_string => "jdbc:mysql://182.162.136.33:3306/Jecheon"
driver_jar_path => "C:\logstash-6.2.3\logstash-6.2.3\lib\mysql-connector-java-5.1.46\mysql-connector-java-5.1.46/mysql-connector-java-5.1.46-bin.jar"
connection_test => false
username => "****"
password => "****"
statement => "INSERT INTO TB_REN016_020 INPT_VOTG_FIGR VALUES([standard_result][inpt_votg_figr]);"
}
And.. somepart of my Error :
{:exception=>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INPT_VOTG_FIGR VALUES([standard_result][inpt_votg_figr])' at line 1}
And
JDBC - Statement has no parameters. No events will be inserted into SQL as you're not passing any event data. Likely configuration error.