# Logstash-input-jdbc plugin Error: Unknown setting 'use\_column\_value' for jdbc

**URL:** <https://discuss.elastic.co/t/logstash-input-jdbc-plugin-error-unknown-setting-use-column-value-for-jdbc/49579>\
**Category:** Logstash\
**Created:** [May 9, 2016, 6:35pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-plugin-error-unknown-setting-use-column-value-for-jdbc/49579 "2016-05-09T18:35:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pandith\_asrar](https://avatars.discourse-cdn.com/v4/letter/p/ecccb3/32.png) [@pandith\_asrar](https://discuss.elastic.co/u/pandith_asrar)\
**Post date:** [May 9, 2016, 6:35pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-plugin-error-unknown-setting-use-column-value-for-jdbc/49579/1 "2016-05-09T18:35:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [May 9, 2016, 7:31pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-plugin-error-unknown-setting-use-column-value-for-jdbc/49579/2 "2016-05-09T19:31:44Z")

</div>

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).

---

<div class="post-metadata">

**Author:** ![pandith\_asrar](https://avatars.discourse-cdn.com/v4/letter/p/ecccb3/32.png) [@pandith\_asrar](https://discuss.elastic.co/u/pandith_asrar)\
**Post date:** [May 9, 2016, 7:51pm UTC](https://discuss.elastic.co/t/logstash-input-jdbc-plugin-error-unknown-setting-use-column-value-for-jdbc/49579/3 "2016-05-09T19:51:15Z")

</div>

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

Regards,  
Asrar

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:58am UTC](https://discuss.elastic.co/t/logstash-input-jdbc-plugin-error-unknown-setting-use-column-value-for-jdbc/49579/4 "2017-07-06T04:58:30Z")

</div>