How do you configure the minimum number of connections in Tomcat?

7 months ago

1 minute

In Tomcat, you can set the minimum number of connections by configuring a data source. Below is an example of a configuration file:

Open the context.xml file in the conf directory of Tomcat.

Add the following configuration information to the file.

<Resource name="jdbc/yourDataSourceName" auth="Container" type="javax.sql.DataSource"
           maxActive="100" maxIdle="30" maxWait="10000"
           username="yourUsername" password="yourPassword" driverClassName="com.mysql.jdbc.Driver"
           url="jdbc:mysql://localhost:3306/yourDatabaseName"
           initialSize="10" minIdle="5" />

In the above configuration, the initialSize property is used to set the initial number of connections for the data source, while the minIdle property is used to set the minimum number of idle connections for the data source.

Save the files and restart the Tomcat server to apply the configuration.

By following the above steps, you can set the minimum connection pool size in Tomcat.