Error will be Raised when parse data into elasticsearch from mysql

Question

curl -XPUT localhost:9200/_river/my_jdbc_river/_meta -d 
           "{
                "type" : "jdbc",
                      "jdbc" : 
                       {
                        "driver" : "com.mysql.jdbc.Driver",
                        "url" : "jdbc:mysql://localhost:3306/springtest",
                        "user" : "root",
                        "password" : "root",
                        "sql" : "select * from register",
                        "index" : "my_register", 
                        "type" : "my_register_type" 
                       }
           }"

the connection successfull but error tab will generated like

error: NoClassSettingsException[Failed to load class with value [jdbc]]; nested:   
ClassNotFoundException[jdbc];

please see if my new try for connection this is also gave me same error bro — Dhaval Gujarati, Jul 07 '14 at 07:04
did you perform all the steps mentioned there? https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart — Ashalynd, Jul 07 '14 at 07:11
yess i done all step from download Download MySQL JDBC driver to -XPUT — Dhaval Gujarati, Jul 07 '14 at 08:33

Ashalynd · Answer 1 · 2014-07-07T07:15:37.567

0

I presume you need to add

"driver": "com.mysql.jdbc.Driver"

to your jdbc definition.

Also, check that you have done all the steps mentioned there: https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart

(especially pp.4 and 5, related to registering MySQL driver with your ElasticSearch instance)

edited Jul 07 '14 at 07:15

answered Jul 07 '14 at 06:57

Ashalynd

12,363
2
34
37

Error will be Raised when parse data into elasticsearch from mysql

1 Answers1