# Oracle jdbc driver

**URL:** <https://discuss.elastic.co/t/oracle-jdbc-driver/140829>\
**Category:** Logstash\
**Created:** [July 20, 2018, 4:08am UTC](https://discuss.elastic.co/t/oracle-jdbc-driver/140829 "2018-07-20T04:08:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![seungtae](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seungtae/32/71413_2.png) [@seungtae](https://discuss.elastic.co/u/seungtae)\
**Post date:** [July 20, 2018, 4:08am UTC](https://discuss.elastic.co/t/oracle-jdbc-driver/140829/1 "2018-07-20T04:08:54Z")

</div>

Hello. I have an issue about jdbc filter for oracle. Who knows about this issue?

```
filter{
    jdbc_streaming {
			jdbc_driver_library => "/usr/share/logstash/vendor/jar/jdbc/ojdbc6.jar"
			jdbc_driver_class => "java::oracle.jdbc.driver.OracleDriver"
			jdbc_connection_string => "jdbc:oracle://192.168.2.41:3306/"
	
			jdbc_user => " ****"
			jdbc_password => " ****"

			statement => "SELECT CID, OTC2_CID FROM TB_REN016_002 WHERE LORA_DEVID = :LoraID 
                                                     and PORT = :port AND ACTIVITY = 0 LIMIT 1;"
			parameters => {
				"LoraID" => "LoraID"
				"port" => "Port"
			}

			target => "matchingCid"	
		}
}

```

> [ERROR] 2018-07-20 13:03:26.252 [[main]-pipeline-manager] pipeline - Error registering plugin {:pipeline\_id=\>"main", :plugin=\>"#\<LogStash::FilterDelegator:0x24febe23 @metric\_events\_out=org.jruby.proxy.org.logstash.instrument.metrics.counter.LongCounter$Proxy2 - name: out value:0, @metric\_events\_in=org.jruby.proxy.org.logstash.instrument.metrics.counter.LongCounter$Proxy2 - name: in value:0, @metric\_events\_time=org.jruby.proxy.org.logstash.instrument.metrics.counter.LongCounter$Proxy2 - name: duration\_in\_millis value:0, @id="cf38f4ec2c267be8a5f388cda5eb94dbc27fab847f35c92fa6d0c9747507e90a", @klass=LogStash::Filters::JdbcStreaming, @metric\_events=#\<LogStash::Instrument::NamespacedMetric:0x4bf93bd8 @metric=#\<LogStash::Instrument::Metric:0x47769623 @collector=#\<LogStash::Instrument::Collector:0x371b929a @agent=nil, @metric\_store=#\<LogStash::Instrument::MetricStore:0x66c52dfc @store=#\<Concurrent:🗺0x00000000000fac entries=3 default\_proc=nil\>, @structured\_lookup\_mutex=#Mutex:0x6460fd07, @fast\_lookup=#\<Concurrent:🗺0x00000000000fb0 entries=119 default\_proc=nil\>\>\>\>, @namespace\_name=[:stats, :pipelines, :main, :plugins, :filters, :cf38f4ec2c267be8a5f388cda5eb94dbc27fab847f35c92fa6d0c9747507e90a, :events]\>, @filter=\<LogStash::Filters::JdbcStreaming jdbc\_driver\_library=\>"/usr/share/logstash/vendor/jar/jdbc/ojdbc6.jar", jdbc\_driver\_class=\>"java::oracle.jdbc.driver.OracleDriver", jdbc\_connection\_string=\>"jdbc:oracle://192.168.2.41:3306/", jdbc\_user=\>"SWMS", jdbc\_password=\>, statement=\>"SELECT CID, OTC2\_CID FROM TB\_REN016\_002 WHERE LORA\_DEVID = :LoraID and PORT = :port AND ACTIVITY = 0 LIMIT 1;", parameters=\>{"LoraID"=\>"LoraID", "port"=\>"Port"}, target=\>"matchingCid", id=\>"cf38f4ec2c267be8a5f388cda5eb94dbc27fab847f35c92fa6d0c9747507e90a", enable\_metric=\>true, periodic\_flush=\>false, jdbc\_validate\_connection=\>false, jdbc\_validation\_timeout=\>3600, tag\_on\_failure=\>["\_jdbcstreamingfailure"], tag\_on\_default\_use=\>["\_jdbcstreamingdefaultsused"], use\_cache=\>true, cache\_expiration=\>5.0, cache\_size=\>500\>\>", :error=\>"java::oracle.jdbc.driver.OracleDriver not loaded", :thread=\>"#\<Thread:0x7cb06714@/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:246 run\>"}  
> [ERROR] 2018-07-20 13:03:26.253 [[main]-pipeline-manager] pipeline - Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\<Sequel::AdapterNotFound: java::oracle.jdbc.driver.OracleDriver not loaded\>, :backtrace=\>["/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/sequel-5.5.0/lib/sequel/adapters/jdbc.rb:44:in `load_driver'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-filter-jdbc_streaming-1.0.3/lib/logstash/plugin_mixins/jdbc_streaming.rb:47:in `prepare\_jdbc\_connection'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-filter-jdbc\_streaming-1.0.3/lib/logstash/filters/jdbc\_streaming.rb:194:in `prepare_connected_jdbc_cache'", "/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-filter-jdbc_streaming-1.0.3/lib/logstash/filters/jdbc_streaming.rb:116:in `register'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:341:in `register_plugin'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:352:in `block in register\_plugins'", "org/jruby/RubyArray.java:1734:in `each'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:352:in `register\_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:736:in `maybe_setup_out_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:362:in `start\_workers'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:289:in `run'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:249:in `block in start'"], :thread=\>"#\<Thread:0x7cb06714@/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:246 run\>"}  
> [ERROR] 2018-07-20 13:03:26.269 [Ruby-0-Thread-1: /usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/stud-0.0.23/lib/stud/task.rb:22] agent - Failed to execute action {:id=\>:main, :action\_type=\>LogStash::ConvergeResult::FailedAction, :message=\>"Could not execute action: LogStash::PipelineAction::Create/pipeline\_id:main, action\_result: false", :backtrace=\>nil}

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [July 23, 2018, 1:11pm UTC](https://discuss.elastic.co/t/oracle-jdbc-driver/140829/2 "2018-07-23T13:11:27Z")

</div>

> [@seungtae](#):
>
> :exception=\>#\<Sequel::AdapterNotFound: java::oracle.jdbc.driver.OracleDriver not loaded

> `jdbc_driver_class => "java::oracle.jdbc.driver.OracleDriver"`

remove the `java::` bit.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 20, 2018, 1:11pm UTC](https://discuss.elastic.co/t/oracle-jdbc-driver/140829/3 "2018-08-20T13:11:30Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.