    @Test
    public void testSimpleAddApi() throws Exception {

        API api = new API();
        api.setContext("/simple");
        api.setDescription("Simple API");
        api.setName("Simple");
        registryService.add(api);

        ClientDataSource dataSource = getDataSource();

        try (Connection connection = dataSource.getConnection()) {
            try (Statement statement = connection.createStatement()) {
                try (ResultSet resultSet =
                        statement.executeQuery("select * from VINEYARD.API where name='Simple'")) {
                    resultSet.next();
                    Assert.assertNotNull(resultSet.getString("ID"));
                    Assert.assertEquals(resultSet.getString("NAME"), "Simple");
                    Assert.assertEquals(resultSet.getString("DESCRIPTION"), "Simple API");
                    Assert.assertEquals(resultSet.getString("CONTEXT"), "/simple");
                    Assert.assertFalse(resultSet.next());
                }
            }
        }
    }