# Searching data

**URL:** <https://discuss.elastic.co/t/searching-data/23939>\
**Category:** Elasticsearch\
**Created:** [June 18, 2015, 7:38pm UTC](https://discuss.elastic.co/t/searching-data/23939 "2015-06-18T19:38:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![thidalgo](https://avatars.discourse-cdn.com/v4/letter/t/898d66/32.png) [@thidalgo](https://discuss.elastic.co/u/thidalgo)\
**Post date:** [June 18, 2015, 7:38pm UTC](https://discuss.elastic.co/t/searching-data/23939/1 "2015-06-18T19:38:42Z")

</div>

Trying out Elasticsearch for possible use in our projects.

I got through the installation and went down the route of using the jdbc river so that I can just quickly create some indexes to see how things will work.

I created the river with the following:

{

"type":"jdbc",

"schedule" : "0 0-59 0-23 ? \* \*",

"jdbc": {

"driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver",

"url":"jdbc:sqlserver://127.0.0.1;databaseName=mydatabase",

"user":"myusername","password":"mypassword",

"sql":"select \* from dbo.mytableorview",

"index":"myindexname",

"type":"mytypename"

}

That seemed to go ok. I then sent

[http://localhost:9200/\_count?pretty](http://localhost:9200/_count?pretty)' -d '

and the results are:

{  
"count": 57164,  
"\_shards": {  
"total": 8,  
"successful": 8,  
"failed": 0  
}  
}

OK, so it seems like some documents were imported via the river.

Now I'm trying to search anything using Sense and the following command:

GET myindexname/mytypename/\_search

and I receive:

{  
"took": 1,  
"timed\_out": false,  
"\_shards": {  
"total": 5,  
"successful": 5,  
"failed": 0  
},  
"hits": {  
"total": 0,  
"max\_score": null,  
"hits": []  
}  
}

can anyone shed some light on where I'm going wrong?

Thanks

---

<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:06am UTC](https://discuss.elastic.co/t/searching-data/23939/2 "2017-07-06T00:06:39Z")

</div>