{"action":"closed","issue":{"url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/705","labels_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/705/labels{/name}","comments_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/705/comments","events_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/705/events","html_url":"https://github.com/jprante/elasticsearch-jdbc/issues/705","id":118897953,"number":705,"title":"Does elasticsearch-jdbc can handle notify events ?","user":{"login":"mickaelperrin","id":5844226,"avatar_url":"https://avatars.githubusercontent.com/u/5844226?v=3","gravatar_id":"","url":"https://api.github.com/users/mickaelperrin","html_url":"https://github.com/mickaelperrin","followers_url":"https://api.github.com/users/mickaelperrin/followers","following_url":"https://api.github.com/users/mickaelperrin/following{/other_user}","gists_url":"https://api.github.com/users/mickaelperrin/gists{/gist_id}","starred_url":"https://api.github.com/users/mickaelperrin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mickaelperrin/subscriptions","organizations_url":"https://api.github.com/users/mickaelperrin/orgs","repos_url":"https://api.github.com/users/mickaelperrin/repos","events_url":"https://api.github.com/users/mickaelperrin/events{/privacy}","received_events_url":"https://api.github.com/users/mickaelperrin/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-25T18:36:47Z","updated_at":"2015-11-30T16:49:49Z","closed_at":"2015-11-30T16:49:49Z","body":"Hi,\r\n\r\nI aim to use elasticsearch-jdbc to do real-time synchronisation of a PostgreSQL database with an ES cluster.\r\n\r\nI wrote a little python script that listen to PostgreSQL for notify events. When an event is thrown, I launch ES-jdbc with a specific query in the JSON config, mainly with the ID of the ROW to be indexed/updated in ES.\r\n\r\nHowever, this works only for the first item as the SQL query is not updated while ES-jdbc is running.\r\n\r\nI was wondering if there was some ways to use ES-jdbc this way (using notify events effectively). Mainly, what I would like to achieve is : \r\n- Establish a persistent connection with DB to avoid connect/reconnect for each query.\r\n- Give a specific query to run on the DB to fetch Data for each notify event.\r\n\r\nThanks for your advices,"}}