JDBC polling not working


(Abhishek Jajoria) #1

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
        }
        }

}


(Jörg Prante) #2

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
        }
        }

}


(Abhishek Jajoria) #3

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 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
        }
        }

}


(system) #4