Forum:

Other IDEs, Version Control

need help

Greenhorn

Posts: 17

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

When I m trying to run my servlet from eclipse using JDBC coding I m getting ClassNotFoundException on line Class.forName("com.mysql.jdbc.Driver")

I have already placed mysql executable jar file into the build path of the project but still no luck.

public class Login extends HttpServlet {
	private static final long serialVersionUID = 1L;
      Connection con = null; 
      PreparedStatement ps = null;
      String firstName = null;
      String lastName = null;
      String emailID = null;
      String date = null;
      
      String query = "insert into student values('"+firstName+"','"+lastName+"','"+date+"','"+emailID+"')";
      String query1 = "select * from student";
    
    
    
	public Login()
    {
		
    }
	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("html/text");
		PrintWriter out =response.getWriter();
		firstName = request.getParameter("t1");
		lastName = request.getParameter("t2");
		date = request.getParameter("t3");
		emailID = request.getParameter("t4");
		
		
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
			if(!con.isClosed())
			{
				
				System.out.print("successfully connected");
			}
			
		ps = con.prepareStatement(query);
		int rs = ps.executeUpdate();
		out.println("<html>");
		out.println("<body>");
		out.println(rs);
		out.println("</body>");
		out.println("</html>");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			try {
				ps.close();
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}

m I need to do anything else to make this class available?

Please help me to sort out the problem!

Thanks
Cherry

Ulf Dittmer

Rancher

Posts: 43081

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

That library needs to be in whatever classpath is used at runtime. (The build path is used at compile time, not runtime.)

Deepak Bala

Bartender

Posts: 6663

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Also, please place your code inside the CODE tags

SCJP 6 articles - SCJP 5/6 mock exams - More SCJP Mocks

Cherry Gupta

Greenhorn

Posts: 17

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I have put the jar file in libraries folder from where all other jar files are executed at runtime but still saying ClassNotFoundException.

Please help me out.

Thanks
Cherry

Ulf Dittmer

Rancher

Posts: 43081

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Putting a jar file into a directory does not generally make that jar file available as part of the classpath. It does that only in certain circumstances, like if the directory in question is the WEB-INF/lib directory of a web app. Is that the case here? If it is, have you restarted the server, or at least the web app?

Cherry Gupta

Greenhorn

Posts: 17

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I have put the jar file like this

Do I need to place the jar file somewhere else also?

problem.JPG

Ulf Dittmer

Rancher

Posts: 43081

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

As I said, if it's a web app, then it needs to be in WEB-INF/lib.

Cherry Gupta

Greenhorn

Posts: 17

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

still the same problem.

I had put the jar file in lib folder to but no luck.

David Newton

Author

Posts: 12617

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Verify it's being deployed, however you're running the web app. Normally putting it in WEB-INF/lib would be enough.

Mark E Hansen

Ranch Hand

Posts: 650

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Cherry Gupta wrote:still the same problem.

I had put the jar file in lib folder to but no luck.

I think you need to double check everything. Are you sure you have the correct Jar? Open that Jar and make sure it contains the class your application is looking for.

Are you sure you've copied the Jar into the correct directory? You've said you copied it into a 'lib' directory, but not which lib directory.

Are you sure you re-build the application since making this change, then re-deployed it?

Are you creating War file for your application? Did you inspect the generated War file to make sure the Jar is actually in the correct location within the War file?

Peter Johnson

author

Posts: 5856

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Cherry, please retitle you post with a better heading than "Need Help". It is assume that every post in this forum is from someone who needs help and if they all used your same heading, how would anyone be able to differentiate among posts? The title should be very specific as to the problem you are facing. Thank you.

JBoss In Action

I found a beautiful pie. And a tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser