Not able to config JDBC input


(Pavan R Gowda) #1

Hello everyone, below is my 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 * from 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 I run the config file, I get the following error -

The error reported is: 
  org.apache.derby.jdbc.EmbeddedDriver not loaded

Can anyone please help me resolve it? My current Java version is -

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)

Logstash JDBC input configuration
(Mark Walkom) #2

We don't have much in the way of docs here so I have asked a dev to drop in and comment :slight_smile:


(Suyog Rao) #3

Answered here: https://github.com/logstash-plugins/logstash-input-jdbc/issues/16

We don't have docs because this plugin is still under development and not released as GA.


(system) #4