# Oracle JDBC River Configuration Issue

**URL:** <https://discuss.elastic.co/t/oracle-jdbc-river-configuration-issue/2283>\
**Category:** Elasticsearch\
**Created:** [June 10, 2015, 9:01am UTC](https://discuss.elastic.co/t/oracle-jdbc-river-configuration-issue/2283 "2015-06-10T09:01:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shaun\_Wells](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@Shaun\_Wells](https://discuss.elastic.co/u/Shaun_Wells)\
**Post date:** [June 10, 2015, 9:01am UTC](https://discuss.elastic.co/t/oracle-jdbc-river-configuration-issue/2283/1 "2015-06-10T09:01:55Z")

</div>

Hi, I've been playing about with ES 1.4.4 and Logstash.. I've managed to setup a logstash filter to read a csv file containing the results of a query from Oracle.. Now I've got what I want, I would like to automate this process and run further query's against Oracle and pull the data into ES..

I have followed some instructions in regards to setting up a RIVER, I have the following jar file in my plugins/jdbc folder 'elasticsearch-river-jdbc-1.4.0.10.jar'. - restarted ES and can see the driver loaded

loaded [jdbc-1.4.0.10-87c9ce0]

When trying to CURL the following, I get an error and was wondering what this meant..

```
curl -XPUT 'localhost:9200/_river/my_oracle_river/_meta' -d '
{
"type" : "jdbc", 
"jdbc" : {
"url" : jdbc:oracle:owner@//instance:5123/test",
"user": "OWNER",
"password" : "",	
"sql" : "select * from users"
}
}'

```

I receive the following error:

> {"error":"MapperParsingException[failed to parse]; nested: JsonParseException[Unrecognized token 'jdbc': was expecting ('true', 'false' or 'null')\n at [Source: [B@30fe5cf7; line: 1, column: 43]]; ","status":400}

I hear that RIVER support is to end... So what's the alternative to RIVERS for connecting to an ORACLE instance - Any advice/help appreciated.

Thanks.  
Shaun.

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [June 10, 2015, 10:05am UTC](https://discuss.elastic.co/t/oracle-jdbc-river-configuration-issue/2283/2 "2015-06-10T10:05:40Z")

</div>

This is not a river issue. It seems there are syntax problems related to your command line interface executing the curl command.

---

<div class="post-metadata">

**Author:** ![Maarten\_Roosendaal](https://avatars.discourse-cdn.com/v4/letter/m/49beb7/32.png) [@Maarten\_Roosendaal](https://discuss.elastic.co/u/Maarten_Roosendaal)\
**Post date:** [June 10, 2015, 6:49pm UTC](https://discuss.elastic.co/t/oracle-jdbc-river-configuration-issue/2283/3 "2015-06-10T18:49:48Z")

</div>

Hi,

You are missing a " before "jdbc...."  
i use to have "driver": "oracle.jdbc.OracleDriver" as a parameter as well but not sure if it's required

I'build my own 'river' which is basically a program that reads data from a database and bulkindexes that data into elasticsearch. Good practice for getting to know elasticsearch bit more.  
i used this resource amongst some other ones: [http://www.programcreek.com/java-api-examples/index.php?api=org.elasticsearch.action.bulk.BulkRequestBuilder](http://www.programcreek.com/java-api-examples/index.php?api=org.elasticsearch.action.bulk.BulkRequestBuilder)

Cheers,  
Maarten

---

<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, 12:08am UTC](https://discuss.elastic.co/t/oracle-jdbc-river-configuration-issue/2283/4 "2017-07-06T00:08:29Z")

</div>