Sql insert

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.

It looks like the plugin should be configured like this:

statement => [
  "INSERT INTO TB_REN016_020 INPT_VOTG_FIGR VALUES (?, ?)",
  "%{standard_result}",
  "%{inpt_votg_figr}"
]

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