# Class loading failure with Logstash 2.1.0: oracle.sql.STRUCT

**URL:** <https://discuss.elastic.co/t/class-loading-failure-with-logstash-2-1-0-oracle-sql-struct/36189>\
**Category:** Logstash\
**Created:** [December 2, 2015, 3:11pm UTC](https://discuss.elastic.co/t/class-loading-failure-with-logstash-2-1-0-oracle-sql-struct/36189 "2015-12-02T15:11:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jrahkonen](https://avatars.discourse-cdn.com/v4/letter/j/8e8cbc/32.png) [@jrahkonen](https://discuss.elastic.co/u/jrahkonen)\
**Post date:** [December 2, 2015, 3:11pm UTC](https://discuss.elastic.co/t/class-loading-failure-with-logstash-2-1-0-oracle-sql-struct/36189/1 "2015-12-02T15:11:14Z")

</div>

Hi,

I have installed Logstash 2.1.0 on Windows from the zip file and I have tried to read data from Oracle through the input-jdbc plugin. I got it almost to work thanks to this discussion [Logstash JDBC input Oracle settings](https://discuss.elastic.co/t/logstash-jdbc-input-oracle-settings/26996).

However, I can't write data into ElasticSearch. This is the beginning of the error message:

```
Failed to load class 'oracle.sql.STRUCT$Access4JacksonDeserializerffec0bcb'
: com.fasterxml.jackson.module.afterburner.ser.BeanPropertyAccessor {:class=>"Jr
Jackson::ParseError", :backtrace=>["com/jrjackson/JrJacksonBase.java:78:in `gene
rate'",

```

Am I missing something from my installation?

---

<div class="post-metadata">

**Author:** ![jrahkonen](https://avatars.discourse-cdn.com/v4/letter/j/8e8cbc/32.png) [@jrahkonen](https://discuss.elastic.co/u/jrahkonen)\
**Post date:** [December 3, 2015, 11:59am UTC](https://discuss.elastic.co/t/class-loading-failure-with-logstash-2-1-0-oracle-sql-struct/36189/2 "2015-12-03T11:59:30Z")

</div>

Problem solved. I had placed ojdbc6.jar into \bin directory as

`jdbc_driver_library => "ojdbc6.jar"`

Logstash.bat that is also in \bin did find ojdbc6.jar and process started, but later when the Jackson parser was needing oracle.sql.STRUCT class from ojdbc6.jar it was not found. Using absolute path solved the issue

`jdbc_driver_library => "c:/logstash-2.0.0/bin/ojdbc6.jar"`

---

<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:20am UTC](https://discuss.elastic.co/t/class-loading-failure-with-logstash-2-1-0-oracle-sql-struct/36189/3 "2017-07-06T05:20:09Z")

</div>

Closed on July 6, 2017, 5:20am UTC