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
CPUs |
Response Time (msec) |
Op/Sec |
---|---|---|
1 |
4223.66 |
529.14 |
2 |
1508.53 |
966.74 |
4 |
153.19 |
1634.94 |