{"action":"closed","issue":{"url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/426","labels_url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/426/labels{/name}","comments_url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/426/comments","events_url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/426/events","html_url":"https://github.com/jprante/elasticsearch-river-jdbc/issues/426","id":53098219,"number":426,"title":"Issue when using river with postgresql jdbc ","user":{"login":"anuhabi","id":10292704,"avatar_url":"https://avatars.githubusercontent.com/u/10292704?v=3","gravatar_id":"","url":"https://api.github.com/users/anuhabi","html_url":"https://github.com/anuhabi","followers_url":"https://api.github.com/users/anuhabi/followers","following_url":"https://api.github.com/users/anuhabi/following{/other_user}","gists_url":"https://api.github.com/users/anuhabi/gists{/gist_id}","starred_url":"https://api.github.com/users/anuhabi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anuhabi/subscriptions","organizations_url":"https://api.github.com/users/anuhabi/orgs","repos_url":"https://api.github.com/users/anuhabi/repos","events_url":"https://api.github.com/users/anuhabi/events{/privacy}","received_events_url":"https://api.github.com/users/anuhabi/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2014-12-30T07:22:12Z","updated_at":"2015-01-02T23:40:59Z","closed_at":"2015-01-02T23:40:59Z","body":"Hi,\r\ni liked your plugin. it work fine with mysql for most of the use cases. \r\n1) I'm encountering an issue when i created a river using postgresql jdbc to connect Greenplum.\r\n2) When i try to create a feeder with same driver i get class not found exception\r\n\r\n\r\nLog Message\r\n------------------\r\n[vddu-pdi-cent4] [2014-12-22 16:36:32,426][INFO ][index.shard.service      ] [PDIES-Pasta-N4] [pdi-simpleindex][4] updating refresh_interval from [-1000] to [1s]\r\n**[vddu-pdi-cent4] [2014-12-22 16:36:32,440][ERROR][river.jdbc.RiverPipeline ] java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc4.Jdbc4Statement.setQueryTimeout(int) is not yet implemented.\r\n[vddu-pdi-cent4] java.io.IOException: java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc4.Jdbc4Statement.setQueryTimeout(int) is not yet implemented.\r\n[vddu-pdi-cent4] \tat org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:341)\r\n**[vddu-pdi-cent4] \tat org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fetch(SimpleRiverFlow.java:209)\r\n[vddu-pdi-cent4] \tat org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.execute(SimpleRiverFlow.java:139)\r\n[vddu-pdi-cent4] \tat org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipeline.java:88)\r\n[vddu-pdi-cent4] \tat org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:66)\r\n[vddu-pdi-cent4] \tat org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:30)\r\n[vddu-pdi-cent4] \tat java.util.concurrent.FutureTask.run(FutureTask.java:262)\r\n[vddu-pdi-cent4] \tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\r\n[vddu-pdi-cent4] \tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\r\n[vddu-pdi-cent4] \tat java.lang.Thread.run(Thread.java:745)\r\n[vddu-pdi-cent4] Caused by: java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc4.Jdbc4Statement.setQueryTimeout(int) is not yet implemented.\r\n[vddu-pdi-cent4] \tat org.postgresql.Driver.notImplemented(Driver.java:751)\r\n[vddu-pdi-cent4] \tat org.postgresql.jdbc2.AbstractJdbc2Statement.setQueryTimeout(AbstractJdbc2Statement.java:666)\r\n[vddu-pdi-cent4] \tat org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.execute(SimpleRiverSource.java:380)\r\n[vddu-pdi-cent4] \tat org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:320)\r\n[vddu-pdi-cent4] \t... 9 more\r\n[vddu-pdi-cent4] [2014-12-22 16:36:32,441][INFO ][river.jdbc.RiverMetrics  ] pipeline org.xbib.elasticsearch.plugin.jdbc.RiverPipeline@33f037dd complete: river jdbc/my_jdbc_river_test metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics: elapsed 0 seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s\r\n\r\n-------\r\n\r\nJDBC Plugin Version: 1.4.0.3.Beta1 installed in all the nodes.\r\nPostgres JDBC Driver: 9.1-903 JDBC 4 and tried other versions as well.\r\nES: 1.4.1\r\nJava: 1.7.0_67\r\nOS: CentOS\r\nNodes: 5\r\nMasters: 1\r\nData Nodes: 5\r\n\r\n\r\ncurl -XPOST '10.98.34.27:9200/_river/my_jdbc_river_test/_meta' -d '\r\n{\r\n  \"type\": \"jdbc\",\r\n  \"jdbc\": {\r\n    \"driver\" : \"org.postgresql.Driver\",\r\n    \"url\": \"jdbc:postgresql://localhost:5432/warehouse\",\r\n    \"user\": \"read_warehousedb\",\r\n    \"password\": \"******\",\r\n    \"sql\": \"select asupid as uid, sn as uname from asup.geninfo\",\r\n    \"index\": \"simpleindex\",\r\n    \"type\": \"simpleindex-mapping\",\r\n    \"index_settings\": {\r\n      \"index\": {\r\n        \"number_of_shards\": 5\r\n      }\r\n    }\r\n}\r\n}\r\n'\r\n\r\ncan you shed some light? thank you in advance and appreciate the support.\r\n"}}