I recently saw a summary of the use of the connection pool on the Forum. Unfortunately, I only summarized Oracle and SQL Server. Now, I want to add the connection pool technology of IBM DB2. For your reference!
Tomcat configuration:
<Context path = "/name entered in the browser" docBase = "absolute path"
Debug = "5" reloadable = "true" crossContext = "true">
<Logger className = "org. apache. catalina. logger. FileLogger"
Prefix = "localhost_MysqlTest_log." suffix = ". txt"
Timestamp = "true"/>
<Resource name = "jdbc/Database name" auth = "Container" type = "javax. SQL. DataSource"/>
<ResourceParams name = "jdbc/Database name">
<Parameter>
<Name> factory </name>
<Value> org. apache. commons. dbcp. basicperformancefactory </value>
</Parameter>
<Parameter>
<Name> maxActive </name>
<Value> 100 </value>
</Parameter>
<Parameter>
<Name> maxIdle </name>
<Value> 30 </value>
</Parameter>