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>