I read a few links on stackoverflow, mkyong and offical docs of Tomcat JDBC Pool. And I am too confused.
Points to be Noted:
1) I understand Oracle Universal Connection Pooling is a new concept and is unstable. In this link the person asks about OracleDataSource(please note it) Link1
2) So Lets say UCP is totally different. Now Mkyong(RESPECT) has this tutorial available. Link2
3) And then there is this Link on Tomcat's offical Docs Link3
What is or is there a difference between OracleDataSource and Commons DBCP ? Is it something like we configure OracleDataSource using Commons DBCP
What method of Datasource Pool Configuration is MKYONG Using?
And what is Tomcat JDBC Connection Pool? Link4
You need to read some more up to date documentation.
UCP is neither new nor unstable.
The OracleDataSource is how you connect to the Oracle database from Java.
Commons DBCP is a database connection pool.
Yes, you would/could use Commons DBCP to pool connections from an OracleDataSource.
MKYOUNG is using Commons DBCP. Tomcat automatically uses Commons DBCP for all DataSources.
Tomcat JDBC is an alternative to connection pool. It has significant advantages in multi-threaded environments compared to Commons DBCP 1.x. When compared to Commons DBCP 2.x the differences are much smaller. Between the two I'd recommond Commons DBCP 2.x by default - it appears to be more actively maintained.
UCP(Universal Connection Pool) has been around since 126.96.36.199. UCP along with RAC, RAC One and ADG is a tested and certified combination for handling database failovers. For more details on UCP, refer to UCP Developer's guide.