public static void main(String[] args)
    {
        BasicConfigurator.configure();
        Connection connection = null;
        Statement statement = null;
        ResultSet rs = null;
        try
        {
            ConfigurationHandler.init();
            Collection<Configuration> configurations =  ConfigurationHandler.getConfigurations();
            for (Configuration configuration : configurations)
                System.out.println(configuration);

            String sql = "SELECT CONFIGURATIONS.*, DS_CONFIGURATION_CATEGORY_LIST (CONFIGURATION_ID) AS CATEGORIES FROM CONFIGURATIONS";
            connection = ConnectionHandler.getConnection("default");
            statement = connection.createStatement();
            rs = statement.executeQuery(sql);
            while (rs != null && rs.next()) {
                System.out.println("configuration [" + rs.getString("PATH") + "]: " + rs.getString("CATEGORIES"));
            }
            if (rs != null)
                rs.close();

        }
        catch (Exception ex) {System.out.println("Exception in main: " + ex);}
        finally {
            if (statement != null) {
                try {
                    statement.close();
                }
                catch(SQLException sqlex) {System.out.println("Exception closing statement: " + sqlex);}
            }
            if (connection != null) {
                try {
                    connection.close();
                }
                catch(SQLException sqlex) {System.out.println("Exception closing connection: " + sqlex);}
            }
            ConnectionHandler.destroy();
        }
    }