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 }