001    //$HeadURL: svn+ssh://developername@svn.wald.intevation.org/deegree/base/trunk/resources/eclipse/files_template.xml $
002    /*----------------------------------------------------------------------------
003     This file is part of deegree, http://deegree.org/
004     Copyright (C) 2001-2009 by:
005     - Department of Geography, University of Bonn -
006     and
007     - lat/lon GmbH -
008    
009     This library is free software; you can redistribute it and/or modify it under
010     the terms of the GNU Lesser General Public License as published by the Free
011     Software Foundation; either version 2.1 of the License, or (at your option)
012     any later version.
013     This library is distributed in the hope that it will be useful, but WITHOUT
014     ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
015     FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
016     details.
017     You should have received a copy of the GNU Lesser General Public License
018     along with this library; if not, write to the Free Software Foundation, Inc.,
019     59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
020    
021     Contact information:
022    
023     lat/lon GmbH
024     Aennchenstr. 19, 53177 Bonn
025     Germany
026     http://lat-lon.de/
027    
028     Department of Geography, University of Bonn
029     Prof. Dr. Klaus Greve
030     Postfach 1147, 53001 Bonn
031     Germany
032     http://www.geographie.uni-bonn.de/deegree/
033    
034     e-mail: info@deegree.org
035     ----------------------------------------------------------------------------*/
036    package org.deegree.portal.cataloguemanager.control;
037    
038    import java.io.IOException;
039    import java.sql.Connection;
040    
041    import org.deegree.enterprise.control.ajax.AbstractListener;
042    import org.deegree.enterprise.control.ajax.ResponseHandler;
043    import org.deegree.enterprise.control.ajax.WebEvent;
044    import org.deegree.io.DBConnectionPool;
045    
046    /**
047     * TODO add class documentation here
048     * 
049     * @author <a href="mailto:name@deegree.org">Andreas Poth</a>
050     * @author last edited by: $Author: admin $
051     * 
052     * @version $Revision: $, $Date: $
053     */
054    public class TestDBConnectionListener extends AbstractListener {
055    
056        /*
057         * (non-Javadoc)
058         * 
059         * @see
060         * org.deegree.enterprise.control.ajax.AbstractListener#actionPerformed(org.deegree.enterprise.control.ajax.WebEvent
061         * , org.deegree.enterprise.control.ajax.ResponseHandler)
062         */
063        public void actionPerformed( WebEvent event, ResponseHandler resp )
064                                throws IOException {
065    
066            String url = (String) event.getParameter().get( "url" );
067            String db = (String) event.getParameter().get( "db" );
068            String user = (String) event.getParameter().get( "user" );
069            String password = (String) event.getParameter().get( "pw" );
070            String sid = (String) event.getParameter().get( "sid" );
071            String driver = null;
072            String database = null;
073            if ( db.equalsIgnoreCase( "postgres" )) {
074                driver = "org.postgresql.Driver";
075                database = "jdbc:postgresql://" + url + '/' + sid;
076            } else if ( db.equalsIgnoreCase( "oracle" )) {
077                driver = "oracle.jdbc.OracleDriver";
078                database = "jdbc:oracle:thin:@" + url + ':' + sid;
079            } else {
080                resp.writeAndClose( "ERROR: not supported database type" );
081                return;
082            }
083    
084            DBConnectionPool pool = DBConnectionPool.getInstance();
085            Connection conn = null;
086            try {
087                conn = pool.acquireConnection( driver, database, user, password );
088            } catch ( Exception e ) {
089                resp.writeAndClose( "ERROR: " + e.getMessage() );
090                return;
091            } finally {
092                try {
093                    if ( conn != null ) {
094                        pool.releaseConnection( conn, driver, url, user, password );
095                    }
096                } catch ( Exception e ) {
097                    // do nothing
098                }
099            }
100            if ( doesSchemaExist( conn ) ) {
101                resp.writeAndClose( false, new Boolean( true ) );
102            } else {
103                resp.writeAndClose( false, new Boolean( false ) );
104            }
105        }
106    
107        /**
108         * @return
109         */
110        private boolean doesSchemaExist( Connection conn ) {
111            return false;
112        }
113    
114    }