Re: Suggest a better way to access a particular K-V store

[adipro]

Thanks for the reply.

For your reference I'm sharing the code.. Please have a look at it..

```
public Set<String> execQuery(Object... args){
            Set<String> urls = new LinkedHashSet<>();
            Long start = (Long)objects[2];
            Long end = (Long)objects[3];
            int i = 0;
            SqlFieldsQuery query = new SqlFieldsQuery("SELECT * FROM URLS
WHERE PROCESS_APPNAME_ID = ? ORDER BY SCORE LIMIT ?"));
            List queryObj = new ArrayList<>();
            queryObj.add(getGlobalAppId(objects[0].toString()));
            if(start != null && end != null){
                queryObj.add(end-start);
            }
            query.setArgs(queryObj.toArray());
            FieldsQueryCursor<List&lt;?>> cursor =
cacheHolder.getCache().query(query);
            for (List<?> row : cursor) {
                urls.add((String)row.get(1));
                i++;
            }
            return urls;
}
```

Is it that cursor.close() is missed here? What happens if it's not there?



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/