# Jdbc River with Postgres sql giving problem

**URL:** <https://discuss.elastic.co/t/jdbc-river-with-postgres-sql-giving-problem/12617>\
**Category:** Elasticsearch\
**Created:** [July 2, 2013, 2:13pm UTC](https://discuss.elastic.co/t/jdbc-river-with-postgres-sql-giving-problem/12617 "2013-07-02T14:13:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![RaazTripathi](https://avatars.discourse-cdn.com/v4/letter/r/8491ac/32.png) [@RaazTripathi](https://discuss.elastic.co/u/RaazTripathi)\
**Post date:** [July 2, 2013, 2:13pm UTC](https://discuss.elastic.co/t/jdbc-river-with-postgres-sql-giving-problem/12617/1 "2013-07-02T14:13:51Z")

</div>

Hello there i am new to elastic search i am using elasticsearch0.90.0 version . i installed jdbc river plugin and then trying to make river with this command

curl -XPUT [http://192.168.1.184:9200/\_river/test\_raaz\_river/\_meta](http://192.168.1.184:9200/_river/test_raaz_river/_meta) -d '  
{  
"type":"jdbc",  
"jdbc": {  
"strategy":"simple",  
"poll":"1m",  
"driver":"org.postgresql.Driver",  
"url" : "jdbc:postgresql://192.168.1.105/:5432/saral2",  
"user":"laitkor",  
"password":"m2n1shlko",  
"sql":"select id as \_id,mo from testde",  
"fetchsize":100  
},  
"index":{  
"index":"rshi",  
"type":"mark",  
"versioning":true,  
"bulk\_size":1000,  
"acknowledge" : false  
}  
}'

this command return result ok .

when i am trying command  
curl -XGET 'localhost:9200/\_river/test\_raaz\_river/\_meta'

it gives result

{"\_index":"\_river","\_type":"test\_raaz\_river","\_id":"\_meta","\_version":1,"exists":true, "\_source" :  
{  
"type":"jdbc",  
"jdbc": {  
"strategy":"simple",  
"poll":"1m",  
"driver":"org.postgresql.Driver",  
"url" : "jdbc:postgresql://192.168.1.105/:5432/saral2",  
"user":"laitkor",  
"password":"m2n1shlko",  
"sql":"select id as \_id,mo from testde",  
"fetchsize":100  
},  
"index":{  
"index":"rshi",  
"type":"mark",  
"versioning":true,  
"bulk\_size":1000,  
"acknowledge" : false  
}  
}}

My question is this why i am not able to fetch data is it fine or it should return something else .

Thanks in advance for help

---

<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, 2:28am UTC](https://discuss.elastic.co/t/jdbc-river-with-postgres-sql-giving-problem/12617/2 "2017-07-06T02:28:39Z")

</div>