Why I am getting class not found exception for Class.forName("com.mysql.jdbc.Driver");

Question

I am developing an web app Using : eclipse IDE(Marse), Java 8, Apache tomcat 8, MySQL. My code for user registration is as follows: ``` System.out.println("Connecting...."); Class.forName("com.mysql.jdbc.Driver"); System.out.println("Class found...."); String url="jdbc:mysql://localhost:3306/db"; String user="root"; String password="root"; System.out.println("success"); Connection conn = DriverManager.getConnection(url,user,password); String query = "insert into login (username,password,emailid,country,city) values (?,?,?,?,?)"; PreparedStatement ps = conn.prepareStatement(query); ps.setString(1,b.getUsername()); ps.setString(2,b.getPassword()); ps.setString(3,b.getEmailid()); ps.setString(4,b.getCountry()); ps.setString(5,b.getCity()); int count=ps.executeUpdate(); ps.close(); conn.close(); ``` My code is also correct and also I added mysql-connector-java-5.1.36 by using Build path>add_external_jar option in eclipse. But still why it gives me such a exception ? Connecting.... java.la…

Accepted Answer

Right click on the Project, go to `Properties`. Choose `Deployment Assembly` (if not found, read the update part) from the left pane. Check if `Java Build Path Entries` are provided. If not, click on `Add` and include it. If it is already present, click `Add` to include your connector jar as `Archive`. Do a `Project`>`Clean`, restart your Server.

Update

If the Project is not being Faceted, you will not find this option. You can click on `Project Facets`, convert to faceted structure and add `Dynamic Web Module` and related dependencies.

Update

Web Deployment Assembly Problem. This answer is helpful in most cases.

Why I am getting class not found exception for Class.forName("com.mysql.jdbc.Driver");

Solution

Problem

Related problems