Date: 2004-05-20T05:12:21 Editor: DirkVerbeeck <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] + + * [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 [EMAIL PROTECTED] - - * 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
