How Can I Configure Tomcat to Connect to a MySQL Database?

Configuring Tomcat to Connect with MySQL

Question:

How can I set up Tomcat to communicate with a MySQL database?

Answer:

1. mysql-connector-java-5.1.13-bin Placement

The placement of the JDBC driver depends on where connections are managed. For a connection pool managed by Tomcat, place the JAR file in Tomcat/lib. For basic connections using DriverManager#getConnection(), the driver can be placed either in Tomcat/lib (applies to all deployed webapps) or YourApp/WEB-INF/lib (overrides the Tomcat/lib driver for the specific webapp).

2. Configuration Files (context.xml or server.xml)

• JNDI Datasource:

  • Configure the datasource using YourApp/META-INF/context.xml.

• Basic DriverManager:

  • Configuration is not handled by Tomcat. Can be managed manually using hardcoding, properties files, XML files, etc.

3. web.xml

• Always provide a web.xml file.
• Configure resources and define servlets, filters, listeners, etc.

Example (JNDI Datasource):

context.xml

<context>
    <resource name="jdbc/yourdb" type="javax.sql.DataSource" maxactive="100" maxidle="30" maxwait="10000" url="jdbc:mysql://localhost:3306/yourdb" driverclassname="com.mysql.jdbc.Driver" username="yourname" password="yourpass"></resource>
</context>

web.xml

<resource-env-ref>
    <resource-env-ref-name>jdbc/yourdb</resource-env-ref-name>
    <resource-env-ref-type>javax.sql.DataSource</resource-env-ref-type>
</resource-env-ref>

Additional Resources:

• [JDBC Connections in Servlet Applications](https://www.baeldung.com/java-jdbc-connection-pool)
• [DAO Tutorial](https://www.tutorialspoint.com/java-dao)

The above is the detailed content of How Can I Configure Tomcat to Connect to a MySQL Database?. For more information, please follow other related articles on the PHP Chinese website!