JSP: Unable to connect to mysql in local drive [Solved]

[You can straight away move to the last post to see the error message]
I am trying to connect to the local mysql database from the Jsp file. The username is root and I have the valid password with me. The file is shown below..any help is appreciated.

The error the system reports is...by the way I am running jdk1.5..don't know that info helps...

type Exception report
 
message 
 
description The server encountered an internal error () that prevented it from fulfilling this request.
 
exception 
 
javax.servlet.ServletException: com.mysql.jdbc.Driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.myfiles.sampleConnectivity_jsp._jspService(sampleConnectivity_jsp.java:72)
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)
 
 
root cause 
 
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1340)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:148)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:69)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:164)
org.apache.jsp.myfiles.sampleConnectivity_jsp._jspService(sampleConnectivity_jsp.java:56)
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)

[ January 02, 2006: Message edited by: Raghavan Chockalingam ]

[ January 02, 2006: Message edited by: Raghavan Chockalingam ]

[ January 02, 2006: Message edited by: Raghavan Chockalingam ]
[ January 02, 2006: Message edited by: Raghavan Chockalingam ]

do you have the mysql.jar with you?

To be frank, I do not know what you are talking of...can you take a little time and explain me in detail what you want me to look for....thanks

In order to connect to a database using JDBC, you need to have a JDBC driver for the specific RDBMS you are using. In this case the driver would be mysql.jar.

You can download this from mysql.org (not sure of the exact link).
Once you get it, put it in your application's WEB-INF/lib directory.

Later if you decide to move up to container managed connection pooling, you'll have to move it but put it there for now.

It was really a good explanation....when I looked out mysql.jar file I came across this link...
http://dev.mysql.com/downloads/connector/odbc/3.51.html
can you tell me will this be any useful...do I have to just run the .exe version of Windows???

I installed the .exe file, it installed itself somewhere in C: I guess but it was not useful....it actually calls itself as mysql-connector-odbc-3.5.1....

ODBC is for connecting from Microsoft technologies.
You can get the JDBC driver here:
http://www.mysql.com/products/connector/j/

I think I have got rid of that driver problem by putting the jar file in web-inf/lib but now it gives a different error saying that I do not have access. I can directly run the mysql command line client so I am sure of the right password....can you guess what the problem is...thanks for continuing support...

I thought this info would be useful

[ January 01, 2006: Message edited by: Raghavan Chockalingam ]

It looks like you've got all your files in the right place on the server so this is not really a JSP issue anymore.

I'll see if I can get this thread moved to JDBC where the database savvy hang out.

Moved to the JDBC forum.

Sorry...i forgot to include the error message...here it is...

javax.servlet.ServletException: Invalid authorization specification message from server: "Access denied for user 'root;password'@'localhost' (using password: NO)"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.myfiles.sampleConnectivity_jsp._jspService(sampleConnectivity_jsp.java:72)
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)

root cause 
 
java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user 'root;password'@'localhost' (using password: NO)"
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1907)
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:2524)
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:818)
com.mysql.jdbc.Connection.createNewIO(Connection.java:1808)
com.mysql.jdbc.Connection.<init>(Connection.java:452)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.myfiles.sampleConnectivity_jsp._jspService(sampleConnectivity_jsp.java:57)
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 have finally found the problem. The driver has to be changed and the URL was wrong so I altered the program as below...

Thanks for all your help...