I'm having problems with tomcat connecting to a mysql database<br><br>The following file works when placed in directory tests under tomcat's /usr/share/tomcat6/webapps/ROOT/tests directory<br><br><%@page language="java" contentType="text/html"%><br>
<%@page import="java.sql.*"%><br><html><head><title>JDBC test</title></head><body><br><%<br>  Class.forName("com.mysql.jdbc.Driver");<br>  Connection conn = DriverManager.getConnection(<br>
      "jdbc:mysql://localhost:3306/shop", "root", "password");<br>  Statement stmt = conn.createStatement();<br>  ResultSet rs = stmt.executeQuery("select * from books");<br>  %><table border= "1"><%<br>
  ResultSetMetaData resMetaData = rs.getMetaData();<br>  int nCols = resMetaData.getColumnCount();<br>  %><tr><%<br>  for (int kCol = 1; kCol <= nCols; kCol++) {<br>    out.print("<td><b>" + resMetaData.getColumnName(kCol) + "</b></td>");<br>
    }<br>  %></tr><%<br>  while (rs.next()) {<br>    %><tr><%<br>    for (int kCol = 1; kCol <= nCols; kCol++) {<br>      out.print("<td>" + rs.getString(kCol) + "</td>");<br>
      }<br>    %></tr><%<br>    }<br>  %></table><%<br>  conn.close();<br>  %><br></body></html><br><br>and accessed as <br><br><a href="http://localhost:8080/tests/jdbc.jsp">http://localhost:8080/tests/jdbc.jsp</a><br>
<br>However, if I deploy a war file with the following web.xml file<br><br><?xml version="1.0" encoding="ISO-8859-1"?><br><web-app id="WebApp_ID" version="2.5"<br>  xmlns="<a href="http://java.sun.com/xml/ns/j2ee">http://java.sun.com/xml/ns/j2ee</a>"<br>
  xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"<br>  xsi:schemaLocation="<a href="http://java.sun.com/xml/ns/j2ee">http://java.sun.com/xml/ns/j2ee</a> <a href="http://java.sun.com/xml/ns/j2ee/web-app_2_5.xsd">http://java.sun.com/xml/ns/j2ee/web-app_2_5.xsd</a>"><br>
    <display-name>eshop</display-name><br>    <servlet><br>        <description><br>        </description><br>        <display-name>ShopServlet</display-name><br>        <servlet-name>ShopServlet</servlet-name><br>
        <servlet-class>eshop.ShopServlet</servlet-class><br>      <init-param><br>        <param-name>base</param-name><br>        <param-value>/eshop/shop</param-value><br>        </init-param><br>
      <init-param><br>        <param-name>imageURL</param-name><br>        <param-value>/eshop/images/</param-value><br>        </init-param><br>      <init-param><br>        <param-name>jdbcDriver</param-name><br>
        <param-value>com.mysql.jdbc.Driver</param-value><br>        </init-param><br>      <init-param><br>        <param-name>dbURL</param-name><br>        <param-value>jdbc:mysql://localhost:3306/shop</param-value><br>
        </init-param><br>      <init-param><br>        <param-name>dbUserName</param-name><br>        <param-value>root</param-value><br>        </init-param><br>      <init-param><br>
        <param-name>dbPassword</param-name><br>        <param-value>password</param-value><br>        </init-param><br>      </servlet><br>    <servlet-mapping><br>        <servlet-name>ShopServlet</servlet-name><br>
        <url-pattern>/shop/*</url-pattern><br>      </servlet-mapping><br>  </web-app><br><br>I get the following error:<br><br>Could not connect to DB: No suitable driver found for<br><br>I've searched the various forums on mysql and I see this problem reported many times before, but was never able to find and answer.<br>
<br>Does anybody know what I'm doing wrong?<br><br>Thanks,<br>Paolo<br>