How to configure Tomcat to connect with MySQL

by

1: Where to place mysql-connector-java-5.1.13-bin in Tomcat directory? Should I place it under Tomcat 6.0\webapps\myapp\WEB-INF\lib?

That depends on where the connections are to be managed. Normally you would like to create a connection pooled JNDI datasource to improve connecting performance. In that case, Tomcat is managing the connections and need to have access to the JDBC driver. You should then drop the JAR file in Tomcat/lib.

But if you’re doing it the basic way using DriverManager#getConnection(), then it in fact don’t matter if you drop it in Tomcat/lib or YourApp/WEB-INF/lib. You however need to realize that the one in Tomcat/lib will apply for all deployed webapps and that the one in YourApp/WEB-INF/lib will override the one in Tomcat/lib for only the particular webapp.

2: Do I need to confirgure context.xml or server.xml files?

That depends on where the connections are to be managed. When using a JNDI datasource, it suffices to configure it using YourApp/META-INF/context.xml like follows (just create file if not exist):

<?xml version="1.0" encoding="UTF-8"?>
<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"
    />
</Context>

and the YourApp/WEB-INF/web.xml as follows:

<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>

If you’re doing it the basic DriverManager way, then it’s all up to you. Hardcoded, properties file, XML file, etcetera. You should manage it youself. Tomcat won’t (and can’t) do anything useful for you.

Noted should be that the YourApp/META-INF/context.xml is specific to Tomcat and clones. Each servletcontainer/appserver has its own way of defining JNDI resources. In Glassfish for example, you’d like to do that through the webbased admin interface.

3: Should I write web.xml file and need to place under Tomcat 6.0\webapps\myapp\WEB-INF? If Yes, then what should be the contents of file?

You should always supply one. It’s not only to configure resources, but also to define servlets, filters, listeners and that kind of mandatory stuff to run your webapp. This file is part of the standard Servlet API.

See also:

More Related Contents:

  1. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  2. Connect Java to a MySQL database
  3. How to get UTF-8 working in Java webapps?
  4. Is it safe to use a static java.sql.Connection instance in a multithreaded system?
  5. Using “like” wildcard in prepared statement
  6. Android JDBC not working: ClassNotFoundException on driver
  7. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  8. MySQL and JDBC with rewriteBatchedStatements=true
  9. JDBC MySql connection pooling practices to avoid exhausted connection pool
  10. What is recommended way for spawning threads from a servlet in Tomcat
  11. Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  12. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  13. Unable to compile class for JSP: The type java.util.Map$Entry cannot be resolved. It is indirectly referenced from required .class files
  14. Returning a ResultSet
  15. How to change MySQL timezone in a database connection using Java?
  16. Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”
  17. _jspService is exceeding the 65535 bytes limit
  18. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  19. Exposing resources from jar files in web applications (Tomcat7)
  20. how to get list of Databases “Schema” names of MySql using java JDBC
  21. Is there a url rewriting engine for Tomcat/Java?
  22. Access denied for user ‘root’@’localhost’
  23. Detecting client disconnect in tomcat servlet?
  24. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  25. How to call a method before the session object is destroyed?
  26. How to use prepared statement for select query in Java?
  27. How to add response headers based on Content-type; getting Content-type before the response is committed
  28. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  29. A persistent connection with JDBC to MySQL
  30. Disable all default HTTP error response content in Tomcat

Leave a Comment