ListDatabasesAction.java

package org.objectweb.jonas.webapp.jonasadmin.service.db;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Iterator;

import javax.management.ObjectName;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.objectweb.jonas.jmx.J2eeObjectName;
import org.objectweb.jonas.jmx.JonasManagementRepr;
import org.objectweb.jonas.webapp.jonasadmin.JonasBaseAction;
import org.objectweb.jonas.webapp.jonasadmin.WhereAreYou;

public class ListDatabasesAction extends JonasBaseAction {

// --------------------------------------------------------- Public Methods
    public ActionForward executeAction(ActionMapping pMapping, ActionForm pForm
            , HttpServletRequest pRequest, HttpServletResponse pResponse)
    throws IOException, ServletException {

        // Force the node selected in tree
        m_WhereAreYou.selectNameNode(getTreeBranchName(DEPTH_SERVER) + WhereAreYou.NODE_SEPARATOR
                + "services" + WhereAreYou.NODE_SEPARATOR + "database", true);

        // no Form used
        try {
            // Use JDBCResource MBean
            String domainName = m_WhereAreYou.getCurrentDomainName();
            String serverName = m_WhereAreYou.getCurrentJonasServerName();
            ObjectName on = J2eeObjectName.JDBCResource(domainName, serverName);
            String[] jdbcDataSources = (String[]) JonasManagementRepr.getAttribute(on, "jdbcDataSources");
            ArrayList al = new ArrayList();
            if (jdbcDataSources.length != 0) {
                String jdbcDataSourceON = null;
                ObjectName jdbcDataSourceObjectName = null;
                String sName = null;
                String sJndiName = null;
                int iJdbcConOpen;
                for (int i = 0; i < jdbcDataSources.length; i++) {
                    jdbcDataSourceON = jdbcDataSources[i];
                    jdbcDataSourceObjectName = ObjectName.getInstance(jdbcDataSourceON);
                    sName = (String) getStringAttribute(jdbcDataSourceObjectName, "name");
                    sJndiName = (String) getStringAttribute(jdbcDataSourceObjectName, "jndiName");
                    iJdbcConOpen = getIntegerAttribute(jdbcDataSourceObjectName, "currentOpened ");
                    al.add(new DatasourceItem(sName, sJndiName, iJdbcConOpen, true));
                }

                Collections.sort(al, new DatasourceItemByNameComparator());
            }
            // Set list in the request
            pRequest.setAttribute("listDatabases", al);
        } catch (Throwable t) {
            addGlobalError(t);
            saveErrors(pRequest, m_Errors);
            return (pMapping.findForward("Global Error"));
        }
        // Forward to the jsp.
        return (pMapping.findForward("Databases"));
    }
}

---