problem in connecting to mysql database

[nancyv]

Hi all
I tried to run the following code..to connect to the database but getting Exception: com.mysql.jdbc.Driver....

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class dataservlet extends HttpServlet {



public void doGet (HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException
{
int emid=0;
PrintWriter out = resp.getWriter();
resp.setContentType("text/html");

String url = "jdbc:mysql://localhost/shipment";

String query = "SELECT user_id FROM tbl_user";


try {

Class.forName("com.mysql.jdbc.Driver").newInstance ();


Connection con = DriverManager.getConnection(url,"nancy","");

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery (query);

while(rs.next())
{
emid=rs.getInt("user_id");
}
out.println(emid);

rs.close();
stmt.close();
con.close();

}

catch (SQLException ex) {

out.println ("SQL Exception: " + ex.getMessage());


}

catch (java.lang.Exception ex) {


resp.setContentType("text/html");
out.println ("Exception: " + ex.getMessage ());
}

}


}

I cannot connect to the database at all..I have created the database and tables correctly...Please help in finding my mistake...Thank you

[cheeryTomato]

Maybe you can try to change the class driver for this one and see whether it can solve the problem:
Class.forName("org.gjt.mm.mysql.Driver");

If still doesn't work, you can try to set the jdbc using the ip address instead of localhost and see whether it works or not.

[geeta_ravikanti]

where u r doing the program actually from console or Eclipse editor
If its from console may be the calss path connection
u just verify classpath is set corectly or not to u realted jar file

[geeta_ravikanti]

Me also getting the same problem
Did u get the solution how u relove u r problem
Please tell me how did u solve that

[DonCash]

Have you checked the sqljdbc.jar (JDBC driver) is set correctly in the classpath??

[geeta_ravikanti]

thnQ for the reply

I solved my problem some one suggets add the ojdbc14.jar file into web-inf\lib directory then i got the ans correctly

[DonCash]

Brilliant! Nice one.

Can you please now mark this thread as Solved. Thank you.