Summary

Today, you first saw where JDBC fits into the architecture of the J2EE system. You then saw the JDBC architecture and the layers that constitute it.

The four kinds of JDBC drivers were then introduced:

• Type 1 driver JDBC-ODBC bridge

• Type 2 driver JDBC-native bridge

• Type 3 driver Three-tier driver with a middleware system

• Type 4 driver Pure Java driver

You then saw the limitations of each kind of driver.

You saw what the driver manager does when an application requests a connection. The need for the functionality of connection pooling was made evident.

WebLogic provides a set of drivers to access all kinds of databases. Today, you learned the kinds of drivers that WebLogic provides. You then saw how to configure a connection pool in WebLogic. You examined the details of configuring a pool through the Administration Console. The details of each of the properties of the connection pool to be configured were discussed.

You studied the steps for configuring a pool dynamically. The details for configuring a pool through the API are available in the WebLogic documentation.

You then learned what MultiPools are. You read about each of the properties to be set in the Administration Console while configuring MultiPools.

DataSource objects and their configuration through the Administration Console were the next topic of discussion. The final discussion was about how to optimize application performance after using the WebLogic methods.

Over the past week, you began to familiarize yourself with the components of WebLogic Server and the J2EE concepts and technologies supported by WebLogic Server. To begin your study of WebLogic Server, you installed and configured a WebLogic application server. After getting your development environment in place, you started off by studying the first technology supported by WebLogic server, Java servlets, and then proceeded to JavaServer Pages (JSP).

Today you were introduced to Java Database Connectivity (JDBC). In the next week you will learn about advanced JDBC topics and also the other J2EE technologies, such as the Java Naming and Directory Interface (JNDI) and session and entity Enterprise JavaBeans (EJBs).