public class DriverManagerConnectionSource extends ConnectionSourceSkeleton
ConnectionSource
that obtains the Connection in the traditional JDBC manner based on the
connection URL.
Note that this class will establish a new Connection for each call to
getConnection(). It is recommended that you either use a JDBC
driver that natively supported Connection pooling or that you create
your own implementation of ConnectionSource that taps into whatever
pooling mechanism you are already using. (If you have access to a JNDI
implementation that supports DataSources, e.g. within
a J2EE application server, see JNDIConnectionSource). See
below for a configuration example that uses the
commons-dbcp
package from Apache.
Sample configuration:
<connectionSource class="org.apache.log4j.jdbc.DriverManagerConnectionSource">
<param name="driver" value="com.mysql.jdbc.Driver" />
<param name="url" value="jdbc:mysql://localhost:3306/mydb" />
<param name="username" value="myUser" />
<param name="password" value="myPassword" />
</connectionSource>
If you do not have another connection pooling mechanism
built into your application, you can use the
commons-dbcp
package from Apache:
<connectionSource class="org.apache.log4j.jdbc.DriverManagerConnectionSource">
<param name="driver" value="org.apache.commons.dbcp.PoolingDriver" />
<param name="url" value="jdbc:apache:commons:dbcp:/myPoolingDriver" />
</connectionSource>
Then the configuration information for the commons-dbcp package goes into
the file myPoolingDriver.jocl and is placed in the classpath. See the
commons-dbcp
documentation for details.repositoryHSQL_DIALECT, MSSQL_DIALECT, MYSQL_DIALECT, ORACLE_DIALECT, POSTGRES_DIALECT, UNKNOWN_DIALECT| Constructor and Description |
|---|
DriverManagerConnectionSource() |
| Modifier and Type | Method and Description |
|---|---|
void |
activateOptions() |
Connection |
getConnection()
Obtain a
Connection for use. |
String |
getDriverClass()
Returns the name of the driver class.
|
String |
getUrl()
Returns the url.
|
void |
setDriverClass(String driverClass)
Sets the driver class.
|
void |
setUrl(String url)
Sets the url.
|
discoverConnnectionProperties, getOverriddenSupportsGetGeneratedKeys, getPassword, getSQLDialectCode, getUser, setOverriddenSupportsGetGeneratedKeys, setPassword, setUser, supportsBatchUpdates, supportsGetGeneratedKeysgetLogger, getLoggerRepository, getNonFloodingLogger, resetErrorCount, setLoggerRepositoryclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitsetLoggerRepositorypublic void activateOptions()
public Connection getConnection() throws SQLException
ConnectionSourceConnection for use. The client is
responsible for closing the Connection when it is no
longer required.SQLException - if a Connection could not be
obtainedConnectionSource.getConnection()public String getUrl()
public void setUrl(String url)
url - The url to setpublic String getDriverClass()
public void setDriverClass(String driverClass)
driverClass - The driver class to setCopyright © 2002-2018 Apache Software Foundation. All Rights Reserved.
Apache Logging, Apache Log4j, Log4j, Apache Chainsaw, Chainsaw, Apache, the Apache feather logo, the Apache Logging project logo, and the Apache Log4j logo are trademarks of The Apache Software Foundation.