    001    //$HeadURL$
    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
    037    package org.deegree.ogcwebservices.csw;
    038
    039    import java.sql.Connection;
    040    import java.sql.DriverManager;
    041    import java.sql.SQLException;
    042    import java.util.MissingResourceException;
    043    import java.util.Properties;
    044    import java.util.ResourceBundle;
    045
    046    import org.deegree.framework.log.ILogger;
    047    import org.deegree.framework.log.LoggerFactory;
    048
    049    /**
    050     *
    051     * <code>DatabaseConnection</code>
    052     *
    053     * @author <a href="mailto:buesching@lat-lon.de">Lyn Buesching</a>
    054     * @author last edited by: $Author:$
    055     *
    056     * @version $Revision:$, $Date:$
    057     *
    058     */
    059    public class CSW202PropertiesAccess {
    060
    061        private static final ILogger LOG = LoggerFactory.getLogger( CSW202PropertiesAccess.class );
    062
    063        private static final String BUNDLE_NAME = "org.deegree.ogcwebservices.csw.csw202";
    064
    065        private static final ResourceBundle RESOURCE_BUNDLE = ResourceBundle.getBundle( BUNDLE_NAME );
    066
    067        static {
    068            try {
    069                Class.forName( getString( "db.driver" ) );
    070            } catch ( ClassNotFoundException e ) {
    071                LOG.logError( "Could not find driver for postgres in the classpath! ", e );
    072            }
    073        }
    074
    075        public static Connection getConnection()
    076                                throws SQLException {
    077            Properties props = new Properties();
    078            props.setProperty( "user", getString( "db.user" ) );
    079            props.setProperty( "password", getString( "db.password" ) );
    080            return DriverManager.getConnection( getString( "db.url" ), props );
    081        }
    082
    083        /**
    084         *
    085         * @param key
    086         * @return the string from the properties file
    087         */
    088        public static String getString( String key ) {
    089            try {
    090                return RESOURCE_BUNDLE.getString( key );
    091            } catch ( MissingResourceException e ) {
    092                return '!' + key + '!';
    093            }
    094        }
    095
    096    }