Logstash-input-jdbc plugin Error: Unknown setting 'use_column_value' for jdbc

Elastic Stack Logstash
1

Hi,
I am trying to use the option available with the jdbc input plugin and getting the below error:
Unknown setting 'use_column_value' for jdbc {:level=>:error}
Unknown setting 'tracking_column' for jdbc {:level=>:error}

The config file is created as given below, please help me here to understand where i am going wrong.

input {
jdbc {
jdbc_driver_library => "ojdbc6.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:username/passwd@oraclehostname:1521/SID"
jdbc_user => "username"
jdbc_password => "passwd"
clean_run => true
last_run_metadata_path => "/integbuild/logstash-2.1.1/conf"
statement => "SELECT
SBJ.SUBJ_name as Subject,
WFR.WORKFLOW_NAME as WorkflowName,
STL.mapping_name as MappingName,
WFR.START_TIME as StartTime,
WFR.END_TIME as EndTime,
decode (RUN_STATUS_CODE,1 , 'Succeeded',
2,'Disabled',
3,'Failed',
4,'Stopped',
5,'Aborted',
6,'Running',
15,'Terminated') as Status,
--SERVER_NAME,
--WFR.RUN_ERR_CODE as RunErrCode,
--WFR.RUN_ERR_MSG as RunErrMsg,
STL.FIRST_ERROR_CODE as FirstErrCode,
STL.FIRST_ERROR_MSG as FirstErrMsg,
STL.LOG_FILE as LogFile,
WFR.WORKFLOW_RUN_ID
from INFAREP_DEV15.OPB_WFLOW_RUN WFR
inner join infarep_dev15.opb_subject SBJ
on WFR.SUBJECT_ID = SBJ.SUBJ_ID
inner join INFAREP_DEV15.opb_sess_task_log STL
on STL.workflow_run_id = WFR.WORKFLOW_RUN_ID
where WFR.WORKFLOW_RUN_ID > :sql_last_value
--START_TIME>= sysdate-2 and END_TIME<=sysdate
order by SUBJ_name,WORKFLOW_NAME,mapping_name,start_time,status"

          use_column_value => true
          tracking_column => WORKFLOW_RUN_ID
    }

}

Regards,
Asrar

2

The use_column_value option hasn't been in place since the start. It was added in the Logstash 2.2 time frame. Check the jdbc input documentation for your version of Logstash (if you've upgraded the plugin yourself things get a bit more complicated).

3

Hi Magnus,
Yes that was in my mind, I will update the plugin and try.

Regards,
Asrar