# Error registering plugin for logstash output jdbc **URL:** \ **Category:** Logstash\ **Created:** [March 13, 2019, 2:36pm UTC](https://discuss.elastic.co/t/error-registering-plugin-for-logstash-output-jdbc/172170 "2019-03-13T14:36:35Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![elkha](https://avatars.discourse-cdn.com/v4/letter/e/c77e96/32.png) [@elkha](https://discuss.elastic.co/u/elkha)\ **Post date:** [March 13, 2019, 2:36pm UTC](https://discuss.elastic.co/t/error-registering-plugin-for-logstash-output-jdbc/172170/1 "2019-03-13T14:36:35Z")
Hi , I am trying to pull data from file and send the result to JDBC oracle , i installed the plugin logstash-output-jdbc succefully but when i run the conf file i am getting the following error : [2019-03-13T15:02:34,812][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified [2019-03-13T15:02:34,833][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"6.5.4"} [2019-03-13T15:02:42,637][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>10, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50} [2019-03-13T15:02:42,666][INFO][logstash.outputs.jdbc] JDBC - Starting up [2019-03-13T15:02:42,713][ERROR][logstash.pipeline] Error registering plugin {:pipeline\_id=\>"main", :plugin=\>"#LogStash::OutputDelegator:0x4e20ad95", :error=\>"missing class name (`com.zaxxer.hikari.HikariDataSource')", :thread=>"#"} [2019-03-13T15:02:42,720][ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline_id=>"main", :exception=>#, :backtrace=\>["org/jruby/javasupport/JavaPackage.java:127:in `const_missing'", "D:/ELK-6.5.4/logstash-6.5.4/vendor/bundle/jruby/2.3.0/gems/logstash-output-jdbc-5.4.0/lib/logstash/outputs/jdbc.rb:146:in`setup\_and\_test\_pool!'", "D:/ELK-6.5.4/logstash-6.5.4/vendor/bundle/jruby/2.3.0/gems/logstash-output-jdbc-5.4.0/lib/logstash/outputs/jdbc.rb:127:in `register'", "org/logstash/config/ir/compiler/OutputStrategyExt.java:102:in`register'", "org/logstash/config/ir/compiler/AbstractOutputDelegatorExt.java:46:in `register'", "D:/ELK-6.5.4/logstash-6.5.4/logstash-core/lib/logstash/pipeline.rb:242:in`register\_plugin'", "D:/ELK-6.5.4/logstash-6.5.4/logstash-core/lib/logstash/pipeline.rb:253:in `block inregister_plugins'", "org/jruby/RubyArray.java:1734:in`each'", "D:/ELK-6.5.4/logstash-6.5.4/logstash-core/lib/logstash/pipeline.rb:253:in `register_plugins'", "D:/ELK-6.5.4/logstash-6.5.4/logstash-core/lib/logstash/pipeline.rb:594:in`maybe\_setup\_out\_plugins'", "D:/ELK-6.5.4/logstash-6.5.4/logstash-core/lib/logstash/pipeline.rb:263:in `start_workers'", "D:/ELK-6.5.4/logstash-6.5.4/logstash-core/lib/logstash/pipeline.rb:200:in`run'", "D:/ELK-6.5.4/logstash-6.5.4/logstash-core/lib/logstash/pipeline.rb:160:in `block in start'"], :thread=\>"#\"} [2019-03-13T15:02:42,741][ERROR][logstash.agent] Failed to execute action {:id=\>:main, :action\_type=\>LogStash::ConvergeResult::FailedAction, :message=\>"Could not execute action: PipelineAction::Create, action\_result: false", :backtrace=\>nil} ---
**Author:** ![yaauie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yaauie/32/23363_2.png) [@yaauie](https://discuss.elastic.co/u/yaauie)\ **Post date:** [March 13, 2019, 11:51pm UTC](https://discuss.elastic.co/t/error-registering-plugin-for-logstash-output-jdbc/172170/2 "2019-03-13T23:51:34Z")
I assume that you're using [@theangryangel's `logstash-output-jdbc` plugin](https://github.com/theangryangel/logstash-output-jdbc)? If so, I think that the error message indicates that the `driver_class` you have specified `com.zaxxer.hikari.HikariDataSource'` cannot be found on your classpath. Is the trailing single-quote in that value intentional? ---
**Author:** ![elkha](https://avatars.discourse-cdn.com/v4/letter/e/c77e96/32.png) [@elkha](https://discuss.elastic.co/u/elkha)\ **Post date:** [March 14, 2019, 9:46am UTC](https://discuss.elastic.co/t/error-registering-plugin-for-logstash-output-jdbc/172170/3 "2019-03-14T09:46:01Z")
Yes I am using that plugin ! In the output cmd the quote exist : ![errror](https://us1.discourse-cdn.com/elastic/original/3X/b/b/bb2ecafaa6d3fefd7f17af55d324ed6ffbf2d165.png) This is my conf output : output { jdbc { driver\_jar\_path =\> "D:\ELK-6.5.4\logstash-6.5.4\vendor\jar\jdbc\ojdbc8.jar" driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver" connection\_string =\> "jdbc:oracle:thin:@host:1521/service" username =\> "User\_REPORT" password =\> "userpass" statement =\> ["INSERT INTO WEBSERVICELOGSFRPROD (ID\_INDEX, SCORE, SOURCE, VAL3, STH, VAL2, VAL1, MESSAGE, TYPE, CLIENT2, PATH, TIMESTAMP, FIRSTIP, VERSION, HOST, CLIENT, HTTP, STH3, USERR, STH2) VALUES('1', '1', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)","%{val3}", "%{sth}","%{val2}", "%{val1}","%{message}", "%{type}", "%{client2}" , "%{path}" , "@timestamp" , "%{firstip}" , "@version" , "%{host}" , "%{client}" , "%{http}" , "%{sth3}" , "%{user}" , "%{sth2}"] } stdout { } } ---
**Author:** ![yaauie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yaauie/32/23363_2.png) [@yaauie](https://discuss.elastic.co/u/yaauie)\ **Post date:** [March 14, 2019, 1:41pm UTC](https://discuss.elastic.co/t/error-registering-plugin-for-logstash-output-jdbc/172170/4 "2019-03-14T13:41:19Z")
How did you install the above plugin? It appears to be having trouble loading one of its dependencies, but it has specific instructions for installation here: [https://github.com/theangryangel/logstash-output-jdbc/blob/master/README.md#installation](https://github.com/theangryangel/logstash-output-jdbc/blob/master/README.md#installation) ---
**Author:** ![elkha](https://avatars.discourse-cdn.com/v4/letter/e/c77e96/32.png) [@elkha](https://discuss.elastic.co/u/elkha)\ **Post date:** [March 15, 2019, 1:51pm UTC](https://discuss.elastic.co/t/error-registering-plugin-for-logstash-output-jdbc/172170/5 "2019-03-15T13:51:15Z")
Thank you , it works ! 🙂 I reinstalled the plugin gem file from this URL [https://rubygems.org/gems/logstash-output-jdbc/versions/5.4.0](https://rubygems.org/gems/logstash-output-jdbc/versions/5.4.0) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 12, 2019, 1:51pm UTC](https://discuss.elastic.co/t/error-registering-plugin-for-logstash-output-jdbc/172170/6 "2019-04-12T13:51:17Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.