MySql not connecting to Eclipse even after manually including

**megabull** · 08-30-2012, 11:42 AM

Hey. I had started doing a project where i have to authenticate. I'm using a mysql database and was making a JSP. Now the issue is that its not connecting to the mysql driver even when i manually added it in the lib folder(yes, imported the j connector jar file in the lib). Need ur assistance and ideas

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
String userName = request.getParameter("userName");
String passWord = request.getParameter("password");

String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/userdb";
String dbName = "userdb";
String user = "root";
String password = "magic";
String sql = "SELECT * FROM userinfo WHERE USR_NAME = ? AND USR_PASS = ?";

Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
boolean login = false;
Class.forName("WEB-INF/lib/org/gjt/mm/mysql/Driver").newInstance();
try {

connection = DriverManager.getConnection(url, "root", "magic");
statement = connection.prepareStatement(sql);
statement.setString(1, userName);
statement.setString(2, password);
resultSet = statement.executeQuery();
login = resultSet.next();
} catch (Exception e) {
throw new ServletException("Login failed", e);
}
finally {
}

if (login) {
request.getSession().setAttribute("username", userName);
response.sendRedirect("logged.jsp");
} else {
out.println("Unknown username/password, try again");
request.getRequestDispatcher("home.jsp").forward(r equest, response);
}

%>
</body>
</html>

Here's the damned error

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:568)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:455)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)

root cause

javax.servlet.ServletException: java.lang.ClassNotFoundException: WEB-INF/lib/org/gjt/mm/mysql/Driver
org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:911)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:840)
org.apache.jsp.login_jsp._jspService(login_jsp.jav a:120)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)

root cause

java.lang.ClassNotFoundException: WEB-INF/lib/org/gjt/mm/mysql/Driver
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.login_jsp._jspService(login_jsp.jav a:88)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:722)

Need assistance asap

ps: If u find out errors in the syntax, do mention them. Though should i admit, some of them have been left intentionally since the mysql connection is the bigger issue at the moment

**megabull** · 08-30-2012, 12:46 PM

ps: tried org.gjt.mm.mysql.Driver as well as com.mysql.jdbc.Driver , nothing helped [:(]

**Tolls** · 08-30-2012, 02:34 PM

Java Code:

Class.forName("WEB-INF/lib/org/gjt/mm/mysql/Driver")

what's that WEB-INF/lib stuff doing in there?
And that should be a classname (including package) and not a path.

Oh, and that's not needed anymore with a modern Java (post 1.5 something?)

**DarrylBurke** · 08-30-2012, 03:05 PM

How to execute mysql command from text file

Will you need to be reminded about the code tags in every thread you start?

db

**megabull** · 08-30-2012, 05:01 PM

@Tolls : I had read on a forum where somebody had suggested me. Should i mention, i had initially used the classname as mentioned earlier. Though i dint knew about the address declaration post 1.5 thing

@Darryl : When the jdbc refuses to connect, and shows error on line 24, i dont care of there's an error on line 70. And btw, wht tags are u talking about? If u think that the empty finally is a mistake, kindly note i have already mentioned that "some of them have been left intentionally since the mysql connection is the bigger issue at the moment" and i dint care about other issues. An empty 'finally' doesnt affect much, does it?

**Tolls** · 08-30-2012, 05:55 PM

Please don't use txt spk.
It's not only annoying, but increases the likelihood of something being misinterpreted.

Class.forName() needs the full class name, which would be org.gjt.mm.mysql.Driver.

Of course it's generally recommended to use the current name for the Driver, which is com.mysql.jdbc.Driver.

If you are still getting an error then the jar file is probably not in the lib directory.

**Tolls** · 08-30-2012, 05:56 PM

While I'm here I may as well post my usual comment in cases such as this.
Do not do things like this in JSP page.
JSPs are for displaying data that has been pulled together by a servlet.

**megabull** · 08-31-2012, 06:16 AM

@tolls : That was my exact detection. i tried manually including the parameters too,but dint help :( Only after getting frustrated i posted here.

Well, yes. You're right in suggesting to not to try this manoeuvre with JSP. Well, i was trying to explore the limits. And i have seen people do mysql connections in JSP online. Check

Connecting JSP To Mysql Database Lesson

**megabull** · 08-31-2012, 08:27 AM

update: Got it. Was very tricky. had to reinstall mysql J connector , then copy it to the lib folder. Adding to the build path still doesnt help. I wonder what was the problem.

**Tolls** · 08-31-2012, 10:02 AM

You didn't mention an IDE.
Your build is probably simply not taking in all your required libraries, and putting things on the build path (which is really just the classes needed to compile your app and not necessarily required for running) does not mean they should be deployed.
It all depends on the IDE and how that operates.