logstash - Not able to config JDBC input -


below configuration -

input {     jdbc {            jdbc_driver_class => "org.apache.derby.jdbc.embeddeddriver"               jdbc_connection_string => "jdbc:derby://localhost:3306/test"            jdbc_user => "root"            jdbc_password => "password"            statement => "select * user"                              }       }  filter {            #csv {                 #columns => ["cdatetime", "address", "district", "beat", "grid", "crimedescr", "ucr_ncic_code",                 #                                   "latitude","longitude"]                           #separator => ","              }        #}  output {           elasticsearch { host => localhost protocol => http index => test user => pavan  password => password  }           stdout { codec => rubydebug }         } 

when run config file, following error -

the error reported is:    org.apache.derby.jdbc.embeddeddriver not loaded 

can please me resolve it? current java version -

java version "1.8.0_45" java(tm) se runtime environment (build 1.8.0_45-b14) java hotspot(tm) 64-bit server vm (build 25.45-b02, mixed mode) 

any reference links jdbc input configuration appreciated.


Comments