Example NoSQLHandle queryIterable

[dario-vega]

I love simplification. No more need for 2 loops for SELECT queries and other technical benefits.

If you take a look at the Oracle NoSQL SDK for Java CHANGELOG.md, you will see:

[5.3.4] 2022-06-16)

• added a new method in NoSQLHandle queryIterable to return the results of a query in an iterable/iterator format. The returned QueryIterableResult should be used in a try-with-resources statement to ensure proper closing of resources.
• updated NoSQLHandle and QueryRequest interfaces to extend AutoClosable

See the difference here:

Previous code

    private static void readDemo(NoSQLHandle serviceHandle) {
        QueryRequest queryRequest = new QueryRequest().setStatement("SELECT * FROM demo");
        try {
            do {
                QueryResult queryResult = serviceHandle.query(queryRequest);
                /* process current set of results */
                List<MapValue> results = queryResult.getResults();
                for (MapValue qval : results) {
                    System.out.println( qval.toString());
                }
            } while (!queryRequest.isDone());
         } finally {
            queryRequest.close();
         }
    }

New code

    private static void readDemo(NoSQLHandle serviceHandle) {
        QueryRequest queryRequest = new QueryRequest().setStatement("SELECT * FROM demo");
        try (QueryIterableResult results = serviceHandle.queryIterable(queryRequest)) {
                for (MapValue qval : results) {
                    System.out.println( qval.toString());
                }
         }
    }