I keep getting the following error: javax.servlet.ServletException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver" org.apache.jasper.runtime.PageContextImpl.doHandlePageException( PageContextImpl.java :825) org.apache.jasper.runtime.PageContextImpl.handlePageException( PageContextImpl.java:758) org.apache.jsp.TryDB_jsp._jspService(TryDB_jsp.java:113) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java :94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java :324) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java :292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
I am using Tomcat 5.0.28, JSDK 1.4.2_08 and MySQL 5.0.20a. Here is a list of what I can think of that I have tried and nothing resolves the "no suitable driver" error: 1) Made sure that mysql-connector-java-3.1.12-bin.jar contains the JDBC driver. 2) I have tried putting the MySQL JAR ( mysql-connector-java-3.1.12-bin.jar) in WEB-INF/lib, common/lib and shared/lib. 3) I have tried putting the MySQL JAR ZIP file mysql-connector-java-3.1.12.zip in WEB-INF/lib, common/lib and shared/lib 4) I have placed "<% Class.forName("com.mysql.jdbc.Driver"); %>" in the JSP page. 5) I changed localhost in the URL connection string to 127.0.0.1. 6) I added the MySQL server port 3306 to the URL connection string. 7) I have tried using another MySQL Jar mysql-connector-java-5.0.0-beta-bin.jar. 8) I have completely uninstalled Tomcat 5.0.28 and reinstalled it. 9) I have completely uninstalled MySQL and reinstalled it, resetting up the database. 10) I have triple checked the database privileges, login ID (wroxuser), password (wrox), table (products). Any suggestions for resolving the "No suitable driver" problem would be greatly appreciated.