107 Server Managed JDBC Connection Pooling : Approach 3|Advance Java Servlet Programming Tutorial

#Server #Managed #JDBC #Connection #Pooling:(Using Approach 3):
#What is #Connection #Pool? #Advance #Java #Servlet #Programming #Tutorial
- Def: #JDBC Connection Pool is #factory that contains set of readily available JDBC #Connection #object's. If these Connection objects will be created and managed by Server(#Web/#Application), then its called #Server #Managed #JDBC #Connection #Pool.

- All connection objects in a Connection pool represents connectivity with same database software.

Ex: JDBC Connection pool for Oracle : All connection objects in that Connection pool represents connectivity with Oracle Database software only.

- DataSource (javax.sql.DataSource) object represents JDBC connection pool, so applications & components can use this DataSource object to access Connection object from Connection pool.

#Procedure to use #Connection #Object of Server Managed JDBC #Connection Pool in our Application to interact with #Database #Software:
================

With respect to this diag

1) Server uses Type 1/2/4/5 JDBC driver to interact with Database software & to create JDBC Connection Pool in server.

2) Programmer creates javax.sql.DataSource object in server representing JDBC COnnection pool.

3) Programmer keeps DataSource object reference in registry for global visibility having nick name/alias name

To provide global visibility to objects we need keep their references in JNDI registry software having some nickname/alias name.

Every server gives one built in JNDI Registry (Java Naming Directory Interface) to make client applications interacting with JNDI registry, Use JNDI Code.

Develop JNDI code by using classes and interfaces of javax.naming package.

4) Client applicatin gets DataSOurce object reference from JNDI registry.

5) 6) 7) Client appln calls getConnection() method on DataSource object to get one JDBC connection object from JDBC Connection Pool

8) Client appln Uses connection objecct to create other JDBC objects (like Statement, ResultSet etc...) & to develope JDBC persistence logic.

9)Client appln calls con.close() method to release JDBC Connection object back to Connection Pool. This released Connection object becomes free to give services to other client application.


#Practical Implementation to Create JDBC DataSource, JDBC Connection Pool for Oracle Database Software in Weblogic Server (by Creating Domain of Weblogic):
===============================

1) Start AdvJavaDomain server of Weblogic & open its admin console .

will contine in next Session


Thank you


...