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
– Dhaval Gujarati, Commented Jul 7, 2014 at 7:04
did you perform all the steps mentioned there? github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart — Ashalynd
– Ashalynd, Commented Jul 7, 2014 at 7:11
yess i done all step from download Download MySQL JDBC driver to -XPUT — Dhaval Gujarati
– Dhaval Gujarati, Commented Jul 7, 2014 at 8:33

Ashalynd · Accepted Answer · 2014-07-07 07:15:37Z

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 7, 2014 at 7:15

answered Jul 7, 2014 at 6:57

Ashalynd

12.6k2 gold badges36 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error will be Raised when parse data into elasticsearch from mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related