commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From commons-...@jakarta.apache.org
Subject [Jakarta Commons Wiki] Updated: DBCP
Date Thu, 20 May 2004 12:12:21 GMT
   Date: 2004-05-20T05:12:21
   Editor: DirkVerbeeck <dirkv@apache.org>
   Wiki: Jakarta Commons Wiki
   Page: DBCP
   URL: http://wiki.apache.org/jakarta-commons/DBCP

   Add overview + page layout

Change Log:

------------------------------------------------------------------------------
@@ -1,18 +1,37 @@
-Is this project still active or have they just not released anything in an excessive period
of time?
+= DBCP Overview =
 
-DBCP is still active.  It is an active area of discussion right now on the commons-dev mailing
list, and has had a number of recent commits.
+Commons-DBCP provides database connection pooling services.
 
-----
+A lot of information is available on the [http://jakarta.apache.org/commons/dbcp/ DBCP website].
+If you don't find the information you need you can always contact us using one of the [http://jakarta.apache.org/site/mail2.html#Commons
mailing lists].
+
+
+= External Resources =
+
+Here's a little diagram showing what datastructure DBCP sets up and how that datastructure
is used in case the DriverManager is employed to obtain Drivers at runtime. Please send any
corrections (for now) to d.tonhofer@m-plify.com. 
+
+  * [http://rei1.m-plify.net/Apache_DBCP/Apache_DBCP_Structure.pdf Apache_DBCP_Structure.pdf]
+  * [http://rei1.m-plify.net/Apache_DBCP/Apache_DBCP_Structure.vsd Apache_DBCP_Structure.vsd]
+  * [http://rei1.m-plify.net/Apache_DBCP/Apache_DBCP_Structure.png Apache_DBCP_Structure.png]
 
-What is the best way, ASIDE from running a query against the DB, to be sure that the connection
is still valid when it is retrieved from the pool?
+Diagrams hosted by http://rei1.m-plify.net
 
-1) this question may be better posed on commons-user or commons-dev.
+= FAQ =
 
-2) how would you do this without a pool?  I.e., what is the best way aside from running a
query to be sure that a connection is still valid when returned from DriverManager/DataSource.getConnection?
+Q: Is this project still active or have they just not released anything in an excessive period
of time?
+
+A: DBCP is still active. We don't do a lot of releases but 
 
 ----
 
-When upgrading from DBCP 1.0 to DBCP 1.1 you can encounter the following issue (reported
on commons-user): 
+Q: What is the best way, ASIDE from running a query against the DB, to be sure that the connection
is still valid when it is retrieved from the pool?
+
+A: How would you do this without a pool?  I.e., what is the best way aside from running a
query to be sure that a connection is still valid when returned from DriverManager/DataSource.getConnection?
+
+----
+
+When upgrading from DBCP 1.0 to DBCP 1.1 you can encounter the following issue (reported
on commons-user):
+
 We are accessing mainframe data using a JDBC
 driver, but it is not truly a database.  Specifically, the setAutoCommit and
 setReadOnly Connection methods fail.  Version 1.0 of DBCP silently discarded
@@ -46,10 +65,11 @@
 A more simple way to create a number of connections at startup is to use the pool.addObject()
method.
 (add the following after creating the PoolableConnectionFactory)
 
+{{{
 for (int i=0 ; i<initialsize ; i++) {
    connectionPool.addObject()
 }
-
+}}}
 ----
 
 Q: <nowiki>Does the current 1.1 release support the poolable/caching of PreparedStatements.
I noted that the PoolableConnectionFactory can take a KeyedObjectPoolFactory as a statement
pool factory. But there is not concrete implementation for the KeyedPoolableObjectFactory
which is required when creating a GenericKeyedObjectPoolFactory. If I pass in a null as shown
in the examples, does it cache prepared statements or should I do that in local objects?</nowiki>
@@ -59,14 +79,4 @@
 ----
 
 Q: Where do I get a concrete example of PerUserPoolDataSource? How do we use it in a situation
where multiple pools are required for different modules of a project and their properties
differ on the database transactional load?
-
-----
-
-Here's a little diagram showing what datastructure DBCP sets up and how that datastructure
is used in case the DriverManager is 
-employed to obtain Drivers at runtime. Please send any corrections (for now) to d.tonhofer@m-plify.com.

-
-  * http://rei1.m-plify.net/Apache_DBCP/Apache_DBCP_Structure.pdf 
-  * http://rei1.m-plify.net/Apache_DBCP/Apache_DBCP_Structure.vsd 
-
-There is also a *PNG* image but I don't include the link here because the Wiki includes it
directly and it's a tad large.
 

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


Mime
View raw message