# Elasticssearch 1.7.5 and spring-data-elasticsearch 1.3.2

**URL:** <https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750>\
**Category:** Elasticsearch\
**Created:** [March 8, 2016, 10:10am UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750 "2016-03-08T10:10:46Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![prashanthrd](https://avatars.discourse-cdn.com/v4/letter/p/50afbb/32.png) [@prashanthrd](https://discuss.elastic.co/u/prashanthrd)\
**Post date:** [March 8, 2016, 10:10am UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/1 "2016-03-08T10:10:46Z")

</div>

Hi friends,

I tested a java application with elasticsearch (1.7.5) and spring-data-elasticsearch(1.3.2). When I run the java application, I don't get any data.

SpringElasticsearchExample s = (SpringElasticsearchExample) ctx.getBean("mainBean");  
System.out.println("Find all merchants");  
s.findAllMerchants();

public void findAllMerchants() {  
Iterable userList = repository.findAll();  
for(User dto : userList){  
System.out.println("values1= " + dto.getUserName());  
}

# OUTPUT

values1= 0

But when query from commandLine, I get data. Can anyone please help me with this.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 8, 2016, 7:17pm UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/2 "2016-03-08T19:17:58Z")

</div>

Did you index data? Can you see them in elasticsearch?

---

<div class="post-metadata">

**Author:** ![prashanthrd](https://avatars.discourse-cdn.com/v4/letter/p/50afbb/32.png) [@prashanthrd](https://discuss.elastic.co/u/prashanthrd)\
**Post date:** [March 9, 2016, 5:49am UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/3 "2016-03-09T05:49:42Z")

</div>

Yes, when I search from commandLine in elasticsearch, I am able to see the data. But from Spring Data I am not able to get the data. Please suggest how to do.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 9, 2016, 6:11am UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/4 "2016-03-09T06:11:27Z")

</div>

I don't know. I'm not using Spring data.

May be a bad configuration in your annotations? Wrong index? Wrong type?

How did you insert your data? With Spring data?

---

<div class="post-metadata">

**Author:** ![prashanthrd](https://avatars.discourse-cdn.com/v4/letter/p/50afbb/32.png) [@prashanthrd](https://discuss.elastic.co/u/prashanthrd)\
**Post date:** [March 9, 2016, 6:52am UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/5 "2016-03-09T06:52:21Z")

</div>

I am using Logstash to pull data from MySQL and insert data into elasticsearch. I want to use Spring-data-elasticsearch api to connect to Elasticsearch and query the data.

What is the best way to connect to elasticsearch from Java & Spring application to search the elasticsearch store. ?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 9, 2016, 7:18am UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/6 "2016-03-09T07:18:58Z")

</div>

If you want to use spring-data, use spring-data.

But without knowing your code (annotations basically), index name, type name, I really can't help.

If you want to use Spring (not specifically spring data), you could try also [https://github.com/dadoonet/spring-elasticsearch](https://github.com/dadoonet/spring-elasticsearch)

---

<div class="post-metadata">

**Author:** ![prashanthrd](https://avatars.discourse-cdn.com/v4/letter/p/50afbb/32.png) [@prashanthrd](https://discuss.elastic.co/u/prashanthrd)\
**Post date:** [March 9, 2016, 7:36am UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/7 "2016-03-09T07:36:34Z")

</div>

Here is my Domain class

```auto
import org.springframework.data.elasticsearch.annotations.Document;

@Document(indexName = "test_for_175_index", type = "book_type")
public class BookElasticDTO {

	private String id;
	private String book_id;
	private int totalBooks,totalActiveBooks,totalPendingBooks,totalInActiveBooks,totalRejectedBooks,totalDeActivatedBooks;

// getter and setter methods

```

```auto
import org.springframework.data.elasticsearch.repository.ElasticsearchRepository;
import com.pn.dtos.elasticsearch.report.BoookElasticDTO;

public interface BookElasticRepository extends ElasticsearchRepository<BookElasticDTO, Long> {
	
}

```

```auto
@Configuration
public class SpringElasticsearchExample {
	
	private final Logger logger = LoggerFactory.getLogger(getClass());

	@Autowired
	private BookElasticRepository repository;
	
	@Autowired
	private ElasticsearchTemplate template;
	
	public static void main(String[] args) throws URISyntaxException, Exception {
        ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
        try {

        	 System.out.println("Load context");
        	 SpringElasticsearchExample s = (SpringElasticsearchExample) ctx.getBean("mainBean");
        	 System.out.println("Find all books");
        	 s.findAllBooks();

        	} finally {
        		             ctx.close();
        		      }
    	}

        public void findAllBooks() {
        			System.out.println(repository.count());
        			if(repository.exists(9L)){
        			 System.out.println("It exists");	
        			}
        			
        			BookElasticDTO dt = repository.findOne(9L);
        			System.out.println("Value = " + dt.getTotalActiveBooks());
        			
        			SearchQuery query = new NativeSearchQueryBuilder().withQuery(QueryBuilders.termQuery("book_id", "9")).build();
        			FacetedPage<BookElasticDTO> bookList = repository.search(query);
        			System.out.println("data = " + bookList.getContent());
        			
        			}
	}

```

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 9, 2016, 7:52am UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/8 "2016-03-09T07:52:54Z")

</div>

Please format you code. I did it for you here.

What gives a:

```auto
curl "localhost:9200/test_for_175_index/book_type/_search?pretty&size=1"

```

And what is the output of your application?

---

<div class="post-metadata">

**Author:** ![prashanthrd](https://avatars.discourse-cdn.com/v4/letter/p/50afbb/32.png) [@prashanthrd](https://discuss.elastic.co/u/prashanthrd)\
**Post date:** [March 9, 2016, 10:15am UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/9 "2016-03-09T10:15:35Z")

</div>

I identified the mistake, it was the mismatch between domain name fields and query parameters fields. Its working now...

---

<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 5, 2017, 11:09pm UTC](https://discuss.elastic.co/t/elasticssearch-1-7-5-and-spring-data-elasticsearch-1-3-2/43750/10 "2017-07-05T23:09:57Z")

</div>