JDBC Connection Pooling with OCI Driver

This test tested the scalability and performance of the JDBC connection pooling module. In this test a simple servlet requests a row from a large database and prints its content. An Oracle database and the Oracle OCI driver were used for the test. JDBC connection pool resource configuration is shown below (server.xml).

<RESOURCES>
       <JDBCRESOURCE jndiname="jdbc/tpcwDB" poolname="TpcwPool" 
enabled="true">
       <JDBCCONNECTIONPOOL name="TpcwPool" 
datasourceclassname="oracle.jdbc.pool.OracleDataSource"
steadypoolsize="1000" maxpoolsize="1000" poolresizequantity="2"
idletimeout="0" maxwaittime="0" 
connectionvalidationrequired="false"
connectionvalidationmethod="auto-commit" 
validationtablename="string" failallconnections="false" >
    <PROPERTY name="URL" 
value="jdbc:oracle:oci8:@(description=(address=(host=mach-3)
(protocol=tcp)(port=1521))(connect_data=(sid=10K)))">
 <PROPERTY name="user" value="tpcw">
 <PROPERTY name="password" value="tpcw">
              </JDBCCONNECTIONPOOL>
 </RESOURCES>

Number of clients: 3600

Figure 7–10 JDBC Connection Pool