# Managing the connection pool by using Tomcat

By default, a third-party application (c3p0) has been embedded into the configuration file of Talend Administration Center, to manage the connection pool.

The following procedure allows Tomcat to manage directly the connection pool. You can also apply this procedure to JBoss.

## Procedure

1. In the <ApplicationPath>/WEB-INF/classes folder, change the default setting of the configuration.properties file to:

   database.useContext=True
2. In the WEB-INF folder, edit the web.xml file and add the following piece of code before the closing tag </web-app>:
   ```
   <resource-ref>

        <description>Our Datasource</description>
        <res-ref-name>jdbc/ADMINISTRATOR_CONNECTION</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>

   </resource-ref>
   ```
3. In the WEB-INF folder, edit the context.xml file and configure the parameters of connection to the database by modifying the following elements:
   | Element name | Value |
   | --- | --- |
   | url | <ul> <li><span>jdbc:mysql://{ip_address}:3306/{db_name}</span><p>For MySQL, where <span>ip_address</span>                                       corresponds to the database IP address and                                          <span>db_name</span> corresponds to its name.</p></li> <li><span>jdbc:oracle:thin:@{ip_address}:1521:{db_name}</span><p>For Oracle, where <span>ip_address</span>                                       corresponds to the database IP address and                                          <span>db_name</span> corresponds to its name.</p></li> <li><span>jdbc:jtds:sqlserver://{ip_address}:1433/{db_name}</span><p>For SQL Server, where                                          <span>ip_address</span> corresponds to the database IP                                       address and <span>db_name</span> corresponds to its                                       name.</p></li> <li><span>jdbc:h2:file:{dir_path/}&lt;db_name&gt;;MVCC=TRUE;AUTO_SERVER=TRUE;                                       LOCK_TIMEOUT=15000</span><p>For H2, where                                          <span>dir_path</span> corresponds to the database path                                       and <span>db_name</span> corresponds to its                                    name.</p></li> </ul> |
   | username | The username used to log in to your database,<br>talend\_admin by default. |
   | password | The password used to log in to your database,<br>talend\_admin by default. |
   | driverClassName | <ul> <li><span>org.gjt.mm.mysql.Driver</span> for                                    MySQL</li> <li><span>oracle.jdbc.driver.OracleDriver</span>                                    for Oracle</li> <li><span>net.sourceforge.jtds.jdbc.Driver</span>                                    for SQL Server</li> <li><span>org.h2.Driver</span> for H2</li> </ul> |
4. Copy the relevant .jar file corresponding to the database in which your data is stored in &lt;TomcatPath&gt;/lib/.