# JDBC Driver: how use the \_job mentioned in the doc?

**URL:** <https://discuss.elastic.co/t/jdbc-driver-how-use-the--job-mentioned-in-the-doc/12840>\
**Category:** Elasticsearch\
**Created:** [July 18, 2013, 11:18am UTC](https://discuss.elastic.co/t/jdbc-driver-how-use-the--job-mentioned-in-the-doc/12840 "2013-07-18T11:18:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pierre\_Vincent\_Ledou](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pierre_vincent_ledou/32/1368_2.png) [@Pierre\_Vincent\_Ledou](https://discuss.elastic.co/u/Pierre_Vincent_Ledou)\
**Post date:** [July 18, 2013, 11:18am UTC](https://discuss.elastic.co/t/jdbc-driver-how-use-the--job-mentioned-in-the-doc/12840/1 "2013-07-18T11:18:43Z")

</div>

Hi there,

I have setup a river to get a Mysql table:

{  
"type": "jdbc",  
"jdbc": {  
"strategy": "simple",  
"autocommit": true,  
"poll": "1m",  
"driver": "com.mysql.jdbc.Driver",  
"url": "jdbc:mysql://localhost:1234/dbname",  
"user": "",  
"password": "",  
"sql": "SELECT log\_id as \_id, site\_id, channel\_id, entry\_id,  
member\_id, type, action, url, ip, user\_agent, DATE\_FORMAT(date\_log,  
'%Y-%m-%dT%TZ') as date\_log, site\_embed FROM statistics\_buffer"  
},  
"index": {  
"index": "myindex",  
"type": "stats-downloads"  
}  
}

It's working great, but it runs the river on all the table on every poll,  
making a huge traffic on my db server (I have more than 2millions rows in  
that table). So I see that I could add a \_job column to my table. I thought  
that the river would right something in it when poll is completed, but the  
column remains null.

Is it possible to ask to the river to write something in that column, like  
that I can filter on that column on the next run?

Cheers,

Pv

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<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, 2:25am UTC](https://discuss.elastic.co/t/jdbc-driver-how-use-the--job-mentioned-in-the-doc/12840/2 "2017-07-06T02:25:45Z")

</div>

Closed on July 6, 2017, 2:25am UTC