java.lang.ClassNotFoundException for sql

[yiannakop]

Hi everyone. I write a jsp file that needs to read data from a sql database (I use mysql). Here is some code:

String myName = request.getParameter("username");
String myPass = request.getParameter("password");

String SQuery = "select * from users where userName="+myName+"";

ResultSet rs = null;
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("org.gjt.mm.mysql.Driver");

Connection db = DriverManager.getConnection("jdbc:mysq;://localhost:3306/JspData");
Statement s = db.createStatement();
rs = s.executeQuery(SQuery);

if (rs.next())
{
// USER ACCEPTED!!!
}
else
{
// USER NOT ACCEPTED!!!
%><jsp:forward page="notUser.jsp"/><%
}
}
catch (Exception e)
{
out.print (e.toString());
}


The problem is that when the jsp is loaded, i get a ClassNotFoundException java exception. Problably there is a problem when defining the driver. What should I do? Please help, I am new to jsp - sql.

[Davey]

Have you included the jar file for the database drivers in the WEB-INF/lib directory of your application?

[yiannakop]

Thanx alot. It works fine now. :wave: