# JDBC polling not working

**URL:** <https://discuss.elastic.co/t/jdbc-polling-not-working/8225>\
**Category:** Elasticsearch\
**Created:** [June 26, 2012, 10:27am UTC](https://discuss.elastic.co/t/jdbc-polling-not-working/8225 "2012-06-26T10:27:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abhishek\_Jajoria](https://avatars.discourse-cdn.com/v4/letter/a/b5e925/32.png) [@Abhishek\_Jajoria](https://discuss.elastic.co/u/Abhishek_Jajoria)\
**Post date:** [June 26, 2012, 10:27am UTC](https://discuss.elastic.co/t/jdbc-polling-not-working/8225/1 "2012-06-26T10:27:03Z")

</div>

Hi Jörg Prante  
\*  
\*  
thank you for your jdbc river plugin  
I have installed the plugin it is working fine but the updation and  
deletion is not working in the index.  
It adds the new row as document in the elasticsearch but when I update a  
table it doesn't update the index.  
{

- \_index: \_river
- \_type: my\_jdbc\_river
- \_id: \_meta
- \_score: 1
- \_source: {
  - type: jdbc
  - jdbc: {
    - driver: com.mysql.jdbc.Driver
    - url: jdbc:mysql://localhost:3306/test
    - user: root
    - password: root
    - sql: select \* from test.`table`
    - poll: 10s  
}

  - index: {
    - index: jdbc
    - type: jdbc  
}  
}

}

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [June 27, 2012, 5:10pm UTC](https://discuss.elastic.co/t/jdbc-polling-not-working/8225/2 "2012-06-27T17:10:19Z")

</div>

Hi,

this is probably the case because the index/type/id set is still the same,  
that is, the updates are triggered only when ES should index different  
objects.  
Do you need updates value-based? I can add this feature, no problem.

Best regards,

Jörg

On Tuesday, June 26, 2012 12:27:03 PM UTC+2, jajoria abhishek wrote:

> Hi Jörg Prante  
> \*  
> \*  
> thank you for your jdbc river plugin  
> I have installed the plugin it is working fine but the updation and  
> deletion is not working in the index.  
> It adds the new row as document in the elasticsearch but when I update a  
> table it doesn't update the index.  
> {
> 
> - \_index: \_river
> - \_type: my\_jdbc\_river
> - \_id: \_meta
> - \_score: 1
> - \_source: {
> - type: jdbc
> - jdbc: {
> - driver: com.mysql.jdbc.Driver
> - url: jdbc:mysql://localhost:3306/test
> - user: root
> - password: root
> - sql: select \* from test.`table`
> - poll: 10s  
> }
> 
> - index: {
> - index: jdbc
> - type: jdbc  
> }  
> }
> 
> }

---

<div class="post-metadata">

**Author:** ![Abhishek\_Jajoria](https://avatars.discourse-cdn.com/v4/letter/a/b5e925/32.png) [@Abhishek\_Jajoria](https://discuss.elastic.co/u/Abhishek_Jajoria)\
**Post date:** [June 28, 2012, 5:37am UTC](https://discuss.elastic.co/t/jdbc-polling-not-working/8225/3 "2012-06-28T05:37:49Z")

</div>

I would be highly obliged if you add this feature  
It would be nice if the index gets updated based on the change in id in  
table and also deletion can occur when any row gets deleted through  
polling and handshaking .

On Wed, Jun 27, 2012 at 10:40 PM, Jörg Prante [joergprante@gmail.com](mailto:joergprante@gmail.com) wrote:

> Hi,
> 
> this is probably the case because the index/type/id set is still the same,  
> that is, the updates are triggered only when ES should index different  
> objects.  
> Do you need updates value-based? I can add this feature, no problem.
> 
> Best regards,
> 
> Jörg
> 
> On Tuesday, June 26, 2012 12:27:03 PM UTC+2, jajoria abhishek wrote:
> 
> > Hi Jörg Prante  
> > \*  
> > \*  
> > thank you for your jdbc river plugin  
> > I have installed the plugin it is working fine but the updation and  
> > deletion is not working in the index.  
> > It adds the new row as document in the elasticsearch but when I update a  
> > table it doesn't update the index.  
> > {
> > 
> > - \_index: \_river
> > - \_type: my\_jdbc\_river
> > - \_id: \_meta
> > - \_score: 1
> > - \_source: {
> > - type: jdbc
> > - jdbc: {
> > - driver: com.mysql.jdbc.Driver
> > - url: jdbc:mysql://localhost:3306/\*\*test
> > - user: root
> > - password: root
> > - sql: select \* from test.`table`
> > - poll: 10s  
> > }
> > 
> > - index: {
> > - index: jdbc
> > - type: jdbc  
> > }  
> > }
> > 
> > }

---

<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, 3:22am UTC](https://discuss.elastic.co/t/jdbc-polling-not-working/8225/4 "2017-07-06T03:22:15Z")

</div>