|
|
Commons DBCP example source code file (release-notes-1.1.xml)
This example Commons DBCP source code file (release-notes-1.1.xml) is included in the DevDaily.com
"Java Source Code
Warehouse" project. The intent of this project is to help you "Learn Java by Example" TM.
The Commons DBCP release-notes-1.1.xml source code
<?xml version="1.0"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<document>
<properties>
<title>Release notes for Commons-DBCP 1.1
<author email="dev@commons.apache.org">Commons Documentation Team
<revision>$Id: release-notes-1.1.xml 561230 2007-07-31 04:17:09Z rahul $
</properties>
<body>
<section name="Release notes for Commons-DBCP 1.1">
<p>
There were a lot changes since the 1.0 release on 12 Aug 2002.
<ul>
<li>All existing features can now be configured by JNDI Context providers (Tomcat)
<br/>
<li>The double close() of a pooled connection is more effectively blocked
(you may experience more "Already closed" SQLExceptions)</li>
<br/>
<li>Prepared statement pooling is now implemented in BasicDataSource
(set poolPreparedStatements=true, maxOpenPreparedStatements=xxx)</li>
<br/>
<li>Access to the underlying connection is blocked by default
You can access the underlying connection by setting
accessToUnderlyingConnectionAllowed=true and by using the following construct:
Connection dconn = ((DelegatingConnection) conn).getInnermostDelegate();</li>
<br/>
<li>New minIdle parameter for a minimum number of idle connections ready for use
<br/>
<li>New connection default properties: defaultCatalog and defaultTransactionIsolation
<br/>
<li>Missing driverClassName will now give the following error "No suitable driver"
<br/>
<li>Bad validationQuery will produce a meaningful SQLException
<br/>
<li>UML Class and sequence diagrams, configuration documentation
<br/>
<li>The following issues were resolved since v1.0: (see Bugzilla for complete description)
<table>
<tr>| ID | Date | Sev | State | Summary | |
<tr> 6934 | 2003-09-20 | Blo | DUPL | SQLTransformer.java - infinite loop in getConnection |
<tr> 7038 | 2002-03-18 | Nor | FIXE | DBCP does not build under JDK 1.4 |
<tr> 7727 | 2002-04-20 | Maj | FIXE | Infinite loop (stack overflow) in BasicDataSource |
<tr> 7728 | 2002-04-20 | Maj | FIXE | BasicDataSource cannot use many JDBC drivers |
<tr> 8620 | 2002-04-29 | Nor | INVA | Closed Connection Exception on setAutoCommit |
<tr> 9073 | 2002-07-20 | Nor | FIXE | BasicDataSource - invalid connections are not checked |
<tr> 9850 | 2002-07-20 | Nor | FIXE | No way to get at SQLException if connection to database fail |
<tr>10592 | 2002-07-20 | Nor | DUPL | dataSource.getConnection never returns in Tomcat using DBCP |
<tr>10614 | 2002-07-20 | Nor | FIXE | DBCP connection pooling broken in Tomcat-4.1.7 (regression) |
<tr>10688 | 2002-07-20 | Min | FIXE | Version in the Manifest |
<tr>10969 | 2002-07-20 | Maj | FIXE | BasicDataSource defaults are unusable |
<tr>11507 | 2002-08-06 | Nor | INVA | Cleanup dead connections |
<tr>12047 | 2002-11-01 | Nor | INVA | validationQuery + MSSQL |
<tr>12400 | 2002-11-07 | Nor | WORK | same connections |
<tr>12409 | 2002-11-01 | Blo | FIXE | Connection can be closed twice |
<tr>12733 | 2003-02-06 | Nor | FIXE | [DBCP][PATCH]Statement.getResultSet() doesn't return null if |
<tr>12869 | 2002-11-01 | Maj | FIXE | Abandoned Connections are never closed |
<tr>13077 | 2002-11-07 | Enh | FIXE | Jdbc2PoolDataSource issues |
<tr>13129 | 2002-11-01 | Nor | FIXE | CPDSConnectionFactory prints invalid error messages |
<tr>13155 | 2002-10-30 | Nor | DUPL | unexpected "exausted pool" error |
<tr>13235 | 2002-11-16 | Blo | FIXE | referenced UserPassKey instances get erroneously returned to |
<tr>13930 | 2003-03-06 | Enh | FIXE | Adding connection parameters to BasicDataSourceFactory |
<tr>13988 | 2003-03-17 | Enh | DUPL | permission error makes connection loop |
<tr>14267 | 2003-04-28 | Maj | INVA | DBCP doesn't work on Tomcat 4.1.12 and Oracle JDBC driver |
<tr>14592 | 2002-11-15 | Enh | INVA | DBCP must be robust against e.g. database shutdowns |
<tr>14663 | 2003-05-14 | Nor | REMI | Tomcat5 server hangs when trying to get the database connect |
<tr>15123 | 2003-08-21 | Maj | FIXE | Incorrect stack trace shown when abandoned connections are c |
<tr>15539 | 2003-02-06 | Maj | DUPL | Strange Result Set on output |
<tr>16283 | 2003-02-01 | Nor | WONT | Inproper use of Exception |
<tr>16581 | 2003-03-06 | Maj | FIXE | Deadlock in AbandonedObjectPool when firewall closes connect |
<tr>16629 | 2003-03-06 | Nor | FIXE | org.apache.commons.dbcp.jdbc2pool.Jdbc2PoolDataSource: setti |
<tr>16987 | 2003-08-11 | Maj | FIXE | race condition in PoolableConnection.close() |
<tr>17015 | 2003-03-06 | Nor | FIXE | GenericObjectPool.invalidateObject() doesn't work with Aband |
<tr>17200 | 2003-03-06 | Maj | FIXE | DBCP: org.apache.commons.dbcp.cpdsadapter.PooledConnectionIm |
<tr>17301 | 2003-04-08 | Nor | WONT | NPE in Oracle driver when using DBCP PoolingDataSource |
<tr>17456 | 2003-04-08 | Enh | FIXE | BasicDataSource should use commons-logging |
<tr>17635 | 2003-03-06 | Min | FIXE | PoolableConnectionFactory-Construction declared to throw Exc |
<tr>17677 | 2003-05-31 | Maj | INVA | Pooled connection architecture vulnerable to double use |
<tr>17678 | 2003-04-01 | Maj | FIXE | DBCP Fails silently in many cases |
<tr>17680 | 2003-03-13 | Maj | INVA | PoolableConnection.reallyClose() doesn't decrement active co |
<tr>17911 | 2003-04-07 | Maj | WONT | Problem with getConnection() and Informix |
<tr>18012 | 2003-08-26 | Enh | FIXE | BasicDataSource doesn't include PreparedStmt Pooling |
<tr>18483 | 2003-04-08 | Nor | WONT | AbandonedObjectPool.removeAbandoned never cleans up the trac |
<tr>18502 | 2003-03-30 | Blo | INVA | java.lang.ClassNotFoundException: org.apache.commons.pool.St |
<tr>18550 | 2003-08-25 | Enh | FIXE | Add defaultTransactionIsolation to BasicDataSource |
<tr>18834 | 2003-04-08 | Nor | FIXE | Jdbc2PoolDataSource throws a RuntimeException when database |
<tr>18905 | 2003-08-11 | Nor | FIXE | Couldn't get connection (Jdbc2PoolDataSource) |
<tr>18921 | 2003-08-11 | Enh | FIXE | Per User methods not working in Jdbc2PoolDataSource |
<tr>18982 | 2003-04-13 | Maj | INVA | Binary distribution missing package |
<tr>19374 | 2003-08-11 | Nor | FIXE | Potential for DelegateStatement, DelegateResultSet to be lef |
<tr>19614 | 2003-08-13 | Maj | FIXE | Poor performance under load |
<tr>19615 | 2003-05-02 | Maj | INVA | Unecessary global synchronized in AbandonedObjectPool method |
<tr>19706 | 2003-08-26 | Enh | WONT | Add Initial Commons Logging to DBCP |
<tr>20649 | 2003-08-11 | Cri | INVA | deadlock when acquiring connections from a pool |
<tr>21132 | 2003-08-11 | Cri | DUPL | Broken pipe despite validation query set |
<tr>21182 | 2003-08-21 | Nor | INVA | [dbcp] removing a webapp does not force connections closed |
<tr>21229 | 2003-08-11 | Nor | FIXE | ConnectionFactory throws SQLException but implementations do |
<tr>21273 | 2003-08-11 | Nor | FIXE | Memory-leak like behaviour in DBCP due to warnings chained t |
<tr>21418 | 2003-08-11 | Min | FIXE | Example code |
<tr>21453 | 2003-08-11 | Maj | INVA | NullPointerException in DBCP when used for client-server ap |
<tr>21458 | 2003-08-11 | Nor | FIXE | Statements and connections don't implement equals()/hashCode |
<tr>21748 | 2003-08-11 | Nor | FIXE | BasicDataSource.close() throws NPE |
<tr>22078 | 2003-08-12 | Nor | FIXE | [DBCP] testOnBorrow fails if setAutoCommit() throws an excep |
<tr>22079 | 2003-08-13 | Nor | FIXE | [DBCP] if connection closed twice *closed* connection is ret |
<tr>22214 | 2003-08-11 | Maj | FIXE | Delegating ResultSet causing NPE |
<tr>22229 | 2003-08-13 | Cri | FIXE | Foul connection causes livelock of all pool operations |
<tr>22598 | 2003-08-21 | Enh | FIXE | minIdle Functionality for DBCP via Patches Posted for common |
<tr>22736 | 2003-08-29 | Maj | INVA | validationQuery parameter hangs getConnection method. |
<tr>22750 | 2003-08-27 | Nor | FIXE | BasicDataSource always sets testOnBorrow if given a validati |
<tr>22776 | 2003-09-20 | Nor | WONT | DBCP should not be writing messages to stderr or stdout |
<tr>23066 | 2003-09-13 | Maj | FIXE | DriverManager.getConnection() throws DbcpException |
<tr>23081 | 2003-09-20 | Nor | FIXE | DBCP - Bad DB Validation Query Hangs Everything |
<tr>23138 | 2003-09-13 | Nor | FIXE | getDelegate no longer useful since v1.7 of PoolingDataSource |
<tr>23157 | 2003-09-20 | Enh | FIXE | add defaultCatalog to BasicDataSource |
<tr>23185 | 2003-09-21 | Nor | WONT | PoolableConnection.close() won't allow multiple close |
<tr>23291 | 2003-09-20 | Nor | FIXE | impossible to turn off all validation tests when a validatio |
<tr>23293 | 2003-09-20 | Nor | FIXE | setAutoCommit(true) when returning connection to the pool |
<tr>23304 | 2003-09-21 | Nor | FIXE | NullpointerException when no driverClassName is specified |
</table>
</li>
<br/>
<li>The following issues were resolved since v1.1RC1:
<table>
<tr>ID | Date | Sev | State | Summary |
<tr>22776 | 2003-09-30 | Nor | FIXE | DBCP should not be writing messages to stderr or stdout (removed unneeded logging in AbandonedObjectPool) |
<tr>23491 | 2003-10-13 | Cri | FIXE | Can't configure PerUserPoolDataSource for use with tomcat, more... |
</table>
</li>
<br/>
<li>The following issues were resolved since v1.1RC2:
<table>
<tr>ID | Date | Sev | State | Summary |
<tr>23843 | 2003-10-20 | Blo | FIXE | PerUserPoolDataSource.getConnection(username, pw) may return connection under wrong username |
</table>
</li>
</ul>
</p>
</section>
</body>
</document>
Other Commons DBCP examples (source code examples)
Here is a short list of links related to this Commons DBCP release-notes-1.1.xml source code file:
The search page
Other Commons DBCP source code examples at this package level
Click here to learn more about this project
