I installed the elasticsearch-river-jdbc/1.3.2 by downloading the zip from https://github.com/jprante/elasticsearch-river-jdbc/downloads and installed by 'sudo ./bin/plugin -url file:///home/randel/elasticsearch-river-jdbc/elasticsearch-river-jdbc-1.3.2.zip -install river-jdbc'
Than I checked what JVM version is installed: 1.6 and downloaded the jdbc4-PostgreSQL driver from http://jdbc.postgresql.org/download.html. I copied it to /usr/share/elasticsearch/plugins/river-jdbc as well as /usr/share/elasticsearch/lib/.
Restarting shows:
[2013-01-04 16:48:44,222][INFO ][node ] [Hyperstorm] {0.20.2}[11710]: initializing ...
[2013-01-04 16:48:44,231][INFO ][plugins ] [Hyperstorm] loaded [jdbc-river], sites []
[2013-01-04 16:48:46,144][INFO ][node ] [Hyperstorm] {0.20.2}[11710]: initialized
[2013-01-04 16:48:46,144][INFO ][node ] [Hyperstorm] {0.20.2}[11710]: starting ...
[2013-01-04 16:48:46,217][INFO ][transport ] [Hyperstorm] bound_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish_address {inet[/46.163.73.84:9300]}
[2013-01-04 16:48:49,244][INFO ][cluster.service ] [Hyperstorm] new_master [Hyperstorm][CVLc5UcwS2qJSlSh3Ibu3A][inet[/46.163.73.84:9300]], reason: zen-disco-join (elected_as_master)
[2013-01-04 16:48:49,273][INFO ][discovery ] [Hyperstorm] elasticsearch/CVLc5UcwS2qJSlSh3Ibu3A
[2013-01-04 16:48:49,289][INFO ][http ] [Hyperstorm] bound_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish_address {inet[/46.163.73.84:9200]}
[2013-01-04 16:48:49,289][INFO ][node ] [Hyperstorm] {0.20.2}[11710]: started
[2013-01-04 16:48:49,325][INFO ][gateway ] [Hyperstorm] recovered [0] indices into cluster_state
but when I issue:
curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.postgresql.Driver",
"url" : "jdbc.postgresql://localhost:5432/testdb",
"user" : "",
"password" : "",
"sql" : "select * from infolist"
}
}'
I get:
{"ok":true,"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_version":1}
and in the log:
[2013-01-04 16:50:15,466][INFO ][cluster.metadata ] [Hyperstorm] [_river] creating index, cause [auto(index api)], shards [1]/[1], mappings []
[2013-01-04 16:50:16,789][INFO ][cluster.metadata ] [Hyperstorm] [_river] update_mapping [my_jdbc_river] (dynamic)
[2013-01-04 16:50:16,808][INFO ][river.jdbc ] [Hyperstorm] [jdbc][my_jdbc_river] starting JDBC connector: URL [jdbc.postgresql://localhost:5432/testdb], driver [org.postgresql.Driver], sql [select * from infolist], river table [false], indexing to [jdbc]/[jdbc], poll [1h]
[2013-01-04 16:50:16,839][INFO ][cluster.metadata ] [Hyperstorm] [jdbc] creating index, cause [api], shards [5]/[1], mappings []
[2013-01-04 16:50:17,030][INFO ][cluster.metadata ] [Hyperstorm] [_river] update_mapping [my_jdbc_river] (dynamic)
[2013-01-04 16:50:17,030][ERROR][river.jdbc ] No suitable driver found for jdbc.postgresql://localhost:5432/testdb
java.sql.SQLException: No suitable driver found for jdbc.postgresql://localhost:5432/testdb
at java.sql.DriverManager.getConnection(DriverManager.java:640)
at java.sql.DriverManager.getConnection(DriverManager.java:200)
at org.elasticsearch.river.jdbc.SQLService.getConnection(SQLService.java:103)
at org.elasticsearch.river.jdbc.JDBCRiver$JDBCConnector.run(JDBCRiver.java:194)
at java.lang.Thread.run(Thread.java:679)
What is going wrong here? The driver is readable by everyone. Do I need to rename it or something?