Servlets and database problem

[wdh321]

I have a servlet which performs some operations on a database i have already set up and had working.
I am only performing simple tasks so that i can add, remove and display the data. I have set up a small tester program to test my database methods separate form my servlet. This works fine and i can add, delete and display the data. When i use my servlet below, the browser redirects to a blank page and the console output says
INFO: SQLExceptionjava.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/university

I dont understand why i am getting a no suitable driver found message, when i am using the same connection method in my test program . . . the only difference is i am calling the method in the servlet below.

StudentOperations operation;
    public void doPost (HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
        try
        {
            operation = new StudentOperations();
            String delete = request.getParameter("delete");
            System.out.println(""+delete);
            operation.removeStudent(delete);
        } catch(ClassNotFoundException e) {
            System.out.println("ClassNotFoundException" + e);
        } catch(SQLException e) {
            System.out.println("SQLException" + e);
        }
        
    }

[doWhile]

No suitable driver found for jdbc:mysql

Is the mysql driver on the classpath of the servlet container? Based upon the exception the answer is no.

[wdh321]

I have set the classpath to the jar by right clicking on my libaries folder and linking to the .jar file.
Would i have to separately do this for the servlet files? how could i do this in netbeans?

[doWhile]

I have set the classpath to the jar by right clicking on my libaries folder and linking to the .jar file.
Would i have to separately do this for the servlet files? how could i do this in netbeans?

You need to consult the documentation of the servlet container (server) you are using for information on how to add libraries to the classpath. I do not use netbeans, I may be mistaken but doubt adding the jar to your project will deploy it the server.

[wdh321]

I have been looking over the documentation, can't find anything that has helped so far

[VanGo]

I am so new to Java it is not likely I will be of much help.
But I have been using Netbeans to connect to a mySQL database

On a windows machine I had to go to the "Control Panel" then to "Administrative Tools" then to "Data Sources ODBC" then to "System DNS" and here I had to Add the connection to my data base.
Sorry if this is just obvious stuff and you already know. Not doing it gave me the same error your getting.
Good luck.

[wsaryada]

For web application you can simply put all the libraries used by your web application under the WEB-INF/lib directory. So please put your MySQL Connector 4 Java in that directory so that your Servlet can load the JDBC driver.

For your other classes it should go the the WEB-INF/classes directory.

[gvnreddy145]

please refer to mysql documentation link MySQL :: MySQL 5.1 Reference Manual :: 21.3.6 JDBC Concepts

[doWhile]

I have been looking over the documentation, can't find anything that has helped so far

You have not provided any information regarding the server you are using, without which it leaves people guessing.

[wdh321]

Sorry i thought i had said, i am using glassfish. After reading through a lot of documentation i found a number of different locations the .jar file can be placed. These included the WEB-INF/lib folder, domain1/lib and also domain1/lib/applibs. To save time incase these didn't work i put the jar in all 3 locations and it seems to be working! I am sure i have tried using the jar file in these three locations separately before but it did not work. I will try and see which location it is getting used from now.