@Test
    public void shouldHandleMultipleExecuteAndQueryOperations(TestContext context) {
        Async async = context.async();
        IJdbcComponent component = new JdbcClientComponentImpl(rule.vertx(), null, null); // Other two params aren't used.
        IJdbcClient client = component.createStandalone(options);
        client.connect(explodeOnFailure(context, async, connectionResult -> {
                System.out.println("Successfully connected!");
                IJdbcConnection connection = connectionResult;
                String sql = "DELETE FROM APIMAN\n" +
                        "     WHERE CITY='Newtown'";
                connection.execute(
                        explodeOnFailure(context, async, onSuccess -> {
                            connection.query(
                                    explodeOnFailure(context, async, queryResult -> {
                                            context.assertEquals(4, queryResult.getNumColumns());

                                            queryResult.next();

                                            // Assert Seychelles
                                            context.assertEquals(1, queryResult.getInteger(0));
                                            context.assertEquals("Seychelles", queryResult.getString(1));
                                            context.assertEquals("Victoria", queryResult.getString(2));
                                            context.assertEquals(new DateTime("1976-06-29T00:00:00.000"), queryResult.getDateTime(3));

                                            queryResult.next();
                                            // Assert Miami, US
                                            context.assertEquals(3, queryResult.getInteger(0));
                                            context.assertEquals("United States", queryResult.getString(1));
                                            context.assertEquals("Miami", queryResult.getString(2));
                                            context.assertEquals(new DateTime("1896-07-28T00:00:00.000"), queryResult.getDateTime(3));

                                            async.complete();
                                    }), "SELECT * FROM APIMAN;");
                        }), sql);
        }));
    }
@author Marc Savy {@literal <msavy@redhat.com>}
gateway/platforms/vertx3/vertx3/src/test/java/io/apiman/gateway/platforms/vertx3/components/jdbc/suitetests/NestedQueryTest.java