# How to use logstash-input-plugin for sequel unsupported DB

**URL:** <https://discuss.elastic.co/t/how-to-use-logstash-input-plugin-for-sequel-unsupported-db/27931>\
**Category:** Logstash\
**Created:** [August 24, 2015, 9:20am UTC](https://discuss.elastic.co/t/how-to-use-logstash-input-plugin-for-sequel-unsupported-db/27931 "2015-08-24T09:20:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kikuchan](https://avatars.discourse-cdn.com/v4/letter/k/9e8a1a/32.png) [@kikuchan](https://discuss.elastic.co/u/kikuchan)\
**Post date:** [August 24, 2015, 9:20am UTC](https://discuss.elastic.co/t/how-to-use-logstash-input-plugin-for-sequel-unsupported-db/27931/1 "2015-08-24T09:20:22Z")

</div>

hi.  
I have to use HiRDB(RDB),but I could not connect HiRDB by logstash-input-plugin.  
When I tried to connect HiRDB by logstash-input-plugin, I used the following config file.

## ・config file

input {  
jdbc {  
jdbc\_driver\_library =\> "C:/win32app/hitachi/hirdb\_s/CLIENT/UTL/pdjdbc4.jar  
jdbc\_driver\_class =\> "JP.co.Hitachi.soft.HiRDB.JDBC.HiRDBDriver"  
jdbc\_connection\_string =\> "jdbc:hitachi.hirdb://DBID=port,DBHOST=hostname"  
jdbc\_user =\> "user"  
jdbc\_password =\> "pass"  
statement =\> "SELECT \* FROM TABLE  
}  
}

filter {}

output { stdout { codec =\> rubydebug } }

* * *

I have the following error.

## ・Error

## Error： JP.co.Hitachi.soft.HiRDB.JDBC.HiRDBDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library? You may be interested in the '--configtest' flag which you can use to validate logstash'ss configuration before you choose to restart a running system.

I had been looking for Error message,so I found the error message in the following file.

## ・file

## logstash-1.5.3\vendor\bundle\jruby\1.9\gems\logstash-input-jdbc-1.0.0\lib\logstash\plugin\_mixins\jdbc.rb

I tried to look at the contents of this file, the error seemed to occur in parts of the following source code.

## ・source coude

begin  
Sequel::JDBC.load\_driver(@jdbc\_driver\_lass)  
rescue Sequel::AdapterNotFound =\> e  
message = if @jdbc\_driver\_library.nil?  
":jdbc\_driver\_library is not set, are you sure included the proper driver client libraries in your classpath?

## else "Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library? end raise LogStash::ConfigurationError, "#{e}. #{message}" end

I looked at "Sequel" and I found the reason.  
HiRDB is not supported by Sequel.  
[http://sequel.jeremyevans.net/](http://sequel.jeremyevans.net/)

How to use logstash-input-plugin for Sequel unsupported DB?  
please help me.

---

<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:** [July 6, 2017, 5:31am UTC](https://discuss.elastic.co/t/how-to-use-logstash-input-plugin-for-sequel-unsupported-db/27931/2 "2017-07-06T05:31:08Z")

</div>