Mailing-List: contact commons-dev-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Developers List" <commons-dev@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of flamefew@gmail.com designates
 64.233.162.207 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=e6CwF9TAr6FAQFUQHvSVhUGryPX5rDprQFCjiVxsMpmzWcocGbRZZ5SZj/fXd6bGrfU0Q5lmrSEsps8aZ46XkB0JRJfP8peKOnoFlWjl8ePwWfeJEi/1CXHghx0xlRASaIX47JzSx3tmg6SMOJvwsKAuZovw639N/pZKjCogX/M=
Message-ID: <31cc37360508031035112f3b9e@mail.gmail.com>
Date: Wed, 3 Aug 2005 13:35:42 -0400
From: Henri Yandell <flamefew@gmail.com>
To: Jakarta Commons Developers List <commons-dev@jakarta.apache.org>
Subject: [dbutils] SystemDataSource
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Just had need to hack together a simple DataSource class and wondered
if it would fit nicely in dbutils. Name is either SystemDataSource
(after SystemClassLoader) or DriverManagerDataSource, it uses Java -D
properties and the DriverManager, so is very lightweight and something
nice to start with before moving up to a container that supplies a
real DataSource.

I imagine there are MockDataSources out there that are similar too for
unit testing, but nothing in DbUtils yet.

(code follows, it's pretty dumb)

public class SystemDataSource implements DataSource {

    private String driver =3D System.getProperty("jdbc.driver");
    private String username =3D System.getProperty("jdbc.user");
    private String password =3D System.getProperty("jdbc.password");
    private String uri =3D System.getProperty("jdbc.uri");

    public SystemDataSource() {
        DbUtils.loadDriver(driver);
    }

    public Connection getConnection() throws SQLException {
        return DriverManager.getConnection(this.uri, this.username,
this.password);
    }

    public Connection getConnection(String username, String password)
throws SQLException {
        return DriverManager.getConnection(this.uri, username, password);
    }

    public PrintWriter getLogWriter() throws SQLException {
        return DriverManager.getLogWriter();
    }

    public void setLogWriter(PrintWriter logWriter) throws SQLException {
        DriverManager.setLogWriter(logWriter);
    }

    public void setLoginTimeout(int timeout) throws SQLException {
        DriverManager.setLoginTimeout(timeout);
    }

    public int getLoginTimeout() throws SQLException {
        return DriverManager.getLoginTimeout();
    }

}

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org