001    /**
002     * ========================================
003     * JFreeReport : a free Java report library
004     * ========================================
005     *
006     * Project Info:  http://reporting.pentaho.org/
007     *
008     * (C) Copyright 2000-2007, by Object Refinery Limited, Pentaho Corporation and Contributors.
009     *
010     * This library is free software; you can redistribute it and/or modify it under the terms
011     * of the GNU Lesser General Public License as published by the Free Software Foundation;
012     * either version 2.1 of the License, or (at your option) any later version.
013     *
014     * This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
015     * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
016     * See the GNU Lesser General Public License for more details.
017     *
018     * You should have received a copy of the GNU Lesser General Public License along with this
019     * library; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
020     * Boston, MA 02111-1307, USA.
021     *
022     * [Java is a trademark or registered trademark of Sun Microsystems, Inc.
023     * in the United States and other countries.]
024     *
025     * ------------
026     * $Id: DriverConnectionProvider.java 2725 2007-04-01 18:49:29Z taqua $
027     * ------------
028     * (C) Copyright 2000-2005, by Object Refinery Limited.
029     * (C) Copyright 2005-2007, by Pentaho Corporation.
030     */
031    package org.jfree.report.modules.data.sql;
032    
033    import java.sql.Connection;
034    import java.sql.DriverManager;
035    import java.sql.SQLException;
036    import java.util.Properties;
037    
038    /**
039     * Creation-Date: 07.04.2006, 15:04:26
040     *
041     * @author Thomas Morgner
042     */
043    public class DriverConnectionProvider implements ConnectionProvider
044    {
045      private Properties properties;
046      private String url;
047      private String driver;
048      private transient Connection connection;
049    
050      public DriverConnectionProvider()
051      {
052        this.properties = new Properties();
053      }
054    
055      public String getProperty(final String key)
056      {
057        return properties.getProperty(key);
058      }
059    
060      public Object setProperty(final String key, final String value)
061      {
062        return properties.setProperty(key, value);
063      }
064    
065      public String getUrl()
066      {
067        return url;
068      }
069    
070      public void setUrl(final String url)
071      {
072        this.url = url;
073      }
074    
075      public String getDriver()
076      {
077        return driver;
078      }
079    
080      public void setDriver(final String driver)
081      {
082        this.driver = driver;
083      }
084    
085      public Connection getConnection() throws SQLException
086      {
087        if (url == null)
088        {
089          throw new NullPointerException("URL must not be null when connecting");
090        }
091    
092        if (connection == null)
093        {
094          try
095          {
096            if (driver != null)
097            {
098              Class.forName(driver);
099            }
100          }
101          catch(Exception e)
102          {
103            throw new SQLException("Unable to load the driver", e.getMessage());
104          }
105    
106          connection = DriverManager.getConnection(url, properties);
107        }
108        return connection;
109      }
110    }