# Update Mechanisam for Jdbc plugin and elasticsearch

**URL:** <https://discuss.elastic.co/t/update-mechanisam-for-jdbc-plugin-and-elasticsearch/8650>\
**Category:** Elasticsearch\
**Created:** [August 6, 2012, 3:50pm UTC](https://discuss.elastic.co/t/update-mechanisam-for-jdbc-plugin-and-elasticsearch/8650 "2012-08-06T15:50:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sowmyak](https://avatars.discourse-cdn.com/v4/letter/s/f19dbf/32.png) [@sowmyak](https://discuss.elastic.co/u/sowmyak)\
**Post date:** [August 6, 2012, 3:50pm UTC](https://discuss.elastic.co/t/update-mechanisam-for-jdbc-plugin-and-elasticsearch/8650/1 "2012-08-06T15:50:08Z")

</div>

Hi,

I have a problem using JDBC plugin with elasticsearch and mysql.  
I am able to poll and retrieve the values using Polling.

But, When I am using the method of Updating Mechanisms, I am not able to  
index the values into ElasticSearch.

when I am using -XGET to retrieve the indexes, it is giving me 0 hits.

This is the procedure that I have followed for getting my updates on mysql  
table reflected on elasticsearch index.

Step 1: create table class\_info(rno int, name varchar(100)); //Create a  
table in mysql database  
Step 2 : create table my\_jdbc\_river(\_index varchar(64), \_type varchar(64),  
\_id varchar(64), source\_timestamp timestamp not null default  
current\_timestamp, source\_operation varchar(8), source\_sql varchar(255),  
target\_timestamp timestamp, target\_operation varchar(8) default 'n/a',  
target\_failed boolean, target\_message varchar(255), primary key(\_index,  
\_type, \_id, source\_timestamp, source\_operation));  
//create a river table in mysql database

Step 3: Create a trigger on class\_info table to insert the rows into  
my\_jdbc\_river on insert operation  
delimiter $$

create trigger check\_root after insert on class\_info for each row begin  
insert into my\_jdbc\_river values("index", "type", "id", null, 'create',  
'select \* from check\_es', null, null, true, null); end$$

delimiter ;

I am not sure whether the parameters to insert statement are correct or not.

Step 4: Create a river on ElasticSearch  
curl -XPUT 'localhost:9200/\_river/my\_jdbc\_river/\_meta' -d '{ "type" :  
"jdbc", "jdbc" : { "driver" : "com.mysql.jdbc.Driver", "url" :  
"jdbc:mysql://localhost:3306/testes", "user" : "root", "password"  
: "p00ph34d", "poll" : "300s","rivertable" : true, "interval" :  
"305s" }, "index" : { "index" : "jdbc","type" : "jdbc", "bulk\_size" :  
100,"max\_bulk\_requests" : 30, "bulk\_timeout" : "60s"} }'

And, when i am inserting the values into class\_info they are not being  
indexed in elasticsearch.

Please let me know the correct procedure I am missing anything or  
misunderstood the concept.

Thanks!

--  
View this message in context: [http://elasticsearch-users.115913.n3.nabble.com/Update-Mechanisam-for-Jdbc-plugin-and-elasticsearch-tp4021314.html](http://elasticsearch-users.115913.n3.nabble.com/Update-Mechanisam-for-Jdbc-plugin-and-elasticsearch-tp4021314.html)  
Sent from the ElasticSearch Users mailing list archive at [Nabble.com](http://Nabble.com).

---

<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:17am UTC](https://discuss.elastic.co/t/update-mechanisam-for-jdbc-plugin-and-elasticsearch/8650/2 "2017-07-06T03:17:38Z")

</div>