Difference between OracleDataSource, Oracle UCP, Commons DBCP and Tomcat Connection Pool?
I have read several links on stackoverflow, mkyong and Tomcat JDBC Pool official docs. And I'm too embarrassed.
Points to consider:
1) I understand that Oracle Universal Connection Pooling is new concept and unstable. In this regard, the person is asking about OracleDataSource (please note it) Link1
2) So UCP is completely different. Now Mkyong (RESPECT) has this tutorial. Link2
3) And here is this link to official Tomcat Link3 docs
What is the difference between OracleDataSource and Commons DBCP ? This is something like setting up OracleDataSource using Commons DBCP
What is the data source pool configuration method that MKYONG uses?
What is Tomcat JDBC Connection Pool? Link4
source to share
You need to read the additional documentation.
UCP is neither new nor volatile.
OracleDataSource is how you connect to Oracle database from Java.
Commons DBCP is a pool of database connections.
Yes, you could use the DBCP Commander to merge connections from OracleDataSource.
MKYOUNG uses Commons DBCP. Tomcat automatically uses Commons DBCP for all data sources.
Tomcat JDBC is an alternative to connection pooling. It has significant advantages in multi-threaded environments over Commons DBCP 1.x. Compared to Commons DBCP 2.x, the differences are much smaller. In between, I recommended Commons DBCP 2.x by default - it seems to be more actively supported.
source to share
UCP (Universal Connection Pool) has been around since 11.1.0.7. UCP, together with RAC, RAC One and ADG, is a proven and certified combination for database failure handling. For more information on UCP, see the UCP Developer Guide .
source to share