# How to access river?

**URL:** <https://discuss.elastic.co/t/how-to-access-river/8844>\
**Category:** Elasticsearch\
**Created:** [August 24, 2012, 1:11pm UTC](https://discuss.elastic.co/t/how-to-access-river/8844 "2012-08-24T13:11:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bibero](https://avatars.discourse-cdn.com/v4/letter/b/d2c977/32.png) [@Bibero](https://discuss.elastic.co/u/Bibero)\
**Post date:** [August 24, 2012, 1:11pm UTC](https://discuss.elastic.co/t/how-to-access-river/8844/1 "2012-08-24T13:11:42Z")

</div>

Hi,  
I'm new to elasticsearch, so my problem is very basic. I'm trying to access  
oracle database via river object. I've already created two different rivers  
on elasticsearch server, but I have no idea how to access them. Here is the  
list of my rivers:

D:\>curl -X POST [http://localhost:9200/\_river/\_search?pretty&q=\*](http://localhost:9200/_river/_search?pretty&q=*)  
{  
"took" : 2,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 1,  
"successful" : 1,  
"failed" : 0  
},  
"hits" : {  
"total" : 6,  
"max\_score" : 1.0,  
"hits" : [ {  
"\_index" : "\_river",  
"\_type" : "my\_river\_1",  
"\_id" : "\_meta",  
"\_score" : 1.0, "\_source" : { "type" : "jdbc", "jdbc" : {  
"driver" : "oracle.jdbc.OracleDriver", "url" :  
"jdbc:oracle:thin:@//hostname:1521/service", "user" : "username",  
"password" : "userpass", "sql" : "select 1 from dual" }}  
}, {  
"\_index" : "\_river",  
"\_type" : "my\_river\_1",  
"\_id" : "\_status",  
"\_score" : 1.0, "\_source" :  
{"ok":true,"node":{"id":"1IPVVy9uRa2u7mRVlPZrKA","name":"Nathaniel  
Essex","transport\_address":"inet[/10.132.7.185:9300]"}}  
}, {  
"\_index" : "\_river",  
"\_type" : "my\_river\_1",  
"\_id" : "\_custom",  
"\_score" : 1.0, "\_source" :  
{"jdbc":{"version":1,"digest":"Cl6/6IfJ4FSO1JtXdmochH4booTba2Vq9HClavrMk6s="}}  
}, {  
"\_index" : "\_river",  
"\_type" : "my\_river\_2",  
"\_id" : "\_meta",  
"\_score" : 1.0, "\_source" : { "type" : "jdbc", "jdbc" : {  
"driver" : "oracle.jdbc.OracleDriver", "url" :  
"jdbc:oracle:thin:@//hostname:1521/service", "user" : "username",  
"password" : "userpass", "sql" : "select 2 from dual" }}  
}, {  
"\_index" : "\_river",  
"\_type" : "my\_river\_2",  
"\_id" : "\_status",  
"\_score" : 1.0, "\_source" :  
{"ok":true,"node":{"id":"1IPVVy9uRa2u7mRVlPZrKA","name":"Nathaniel  
Essex","transport\_address":"inet[/10.132.7.185:9300]"}}  
}, {  
"\_index" : "\_river",  
"\_type" : "my\_river\_2",  
"\_id" : "\_custom",  
"\_score" : 1.0, "\_source" :  
{"jdbc":{"version":1,"digest":"rqxKjWSzm3pVCn7FeO1+8NMWrmofY7F0OWr12tkYekM="}}  
} ]  
}  
}

Can anyone explain me how to access my\_river\_2?

Best regards,  
Lukasz

--

---

<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, 3:15am UTC](https://discuss.elastic.co/t/how-to-access-river/8844/2 "2017-07-06T03:15:12Z")

</div>