Application: gvSIG desktop

package org.gvsig.h2spatial;

import java.util.ArrayList;

import java.util.List;

import javax.swing.JComboBox;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataServerExplorerParameters;

import org.gvsig.fmap.dal.DataServerExplorerPool;

import org.gvsig.fmap.dal.DataServerExplorerPoolEntry;

import org.gvsig.fmap.dal.DataStore;

import org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorer;

import org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParametersBase;

import org.gvsig.tools.util.LabeledValue;

import org.gvsig.tools.util.LabeledValueImpl;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 *

 * @author jjdelcerro

 */

public class ShutdownCompact extends ShutdownCompactView {

    private static Logger LOGGER = LoggerFactory.getLogger(ShutdownCompact.class);

    public ShutdownCompact() {

        this.initComponents();

    }

    private void initComponents() {

        fillConnections(cboCconnections);

    }

    private void fillConnections(JComboBox combo) {

        DataManager dataManager = DALLocator.getDataManager();

        DataServerExplorerPool pool = dataManager.getDataServerExplorerPool();

        DataServerExplorerParameters params;

        combo.removeAllItems();

        List<DataServerExplorerPoolEntry> entries = new ArrayList<>();

        pool.iterator().forEachRemaining((DataServerExplorerPoolEntry e) -> {

            entries.add(e);

        });

        entries.sort((DataServerExplorerPoolEntry o1, DataServerExplorerPoolEntry o2) -> {

            return StringUtils.compare(o1.getName(), o2.getName());

        });

        for (DataServerExplorerPoolEntry entry : entries) {

            if (StringUtils.equalsIgnoreCase(DataStore.H2SPATIAL_PROVIDER_NAME, entry.getExplorerParameters().getProviderName())) {

                JDBCServerExplorerParametersBase dbParams = (JDBCServerExplorerParametersBase) entry.getExplorerParameters();

                combo.addItem(

                        new LabeledValueImpl<>(entry.getName(), dbParams)

                );

            }

        }

        combo.setSelectedIndex(-1);

    }

    public void shutdownAndCompact() {

        LabeledValue<JDBCServerExplorerParametersBase> value = (LabeledValue<JDBCServerExplorerParametersBase>) this.cboCconnections.getSelectedItem();

        if (value == null) {

            return;

        }

        try {

            DataManager dataManager = DALLocator.getManager();

            JDBCServerExplorer server = (JDBCServerExplorer) dataManager.openServerExplorer(

                    DataStore.H2SPATIAL_PROVIDER_NAME, 

                    value.getValue()

            );

            server.execute("!SHUTDOWN");

        } catch (Exception ex) {

            LOGGER.warn("Can't shutdown/compact database",ex);

        }

    }

}