By Gokhan Gungor on May 03, 2012
Almost all enterprise java applications require a database resource which is a very expensive and limited resource. The simplest way of using this resource requires performing the following steps; loading JDBC driver, obtaining a connection from the database manager, performing database operation, closing the connection. This method is inefficient and obtaining a database connection that way is an expensive operation because of the overhead involved in the process. It is a better approach to create the pool of database connections and reuse them for each incoming request or method call. That way we retrieve a connection from the pool when necessary and return it back to make it available for other programs. In WebLogic Server we can use jdbc data sources to create database pools, connect databases and manage database access.