BEST PractICE 6 Uses JDBC Connection Pooling
To avoid obtaining high consumption of JDBC Connection, WebSphere Application Server provides JDBC Connection Pool based on JDBC2.0. Servlets App Use the database connection pool in WebSphere Application Server instead of using JDBC drivers to get database connections. The JDBC database connection pool in WebSphere Application Server includes the use of Javax.Sql.DataSources. How to use Javax.Sql.DataSources correctly can be found in Best Practice 7 Reuse DataSources for JDBC Connections.
Figure 6A shows an error method for obtaining a JDBC connection. Figure 6b shows the correct method, and Figure 6C compares the throughput of both.
