![java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver [duplicate]](https://liberty.io/uploads/java-lang-classnotfoundexception-oracle-jdbc-driver-oracledriver-duplicate_720.jpg)
I wrote a Java Servlet program but when I run it, it was showing the Exception
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver My code is
package skypark; import java.io.*; import javax.servlet.*; import java.text.*; import javax.servlet.http.*; import java.sql.*; import java.sql.Date; public class Registration extends HttpServlet { private static final long serialVersionUID = 1L; public static Connection prepareConnection() throws ClassNotFoundException, SQLException { String dcn = "oracle.jdbc.driver.OracleDriver"; String url = "jdbc:oracle:thin:@JamesPJ-PC:1521:skypark"; String usname = "system"; String pass = "tiger"; Class.forName(dcn); return DriverManager.getConnection(url, usname, pass); } public void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); try { String phone1, dofb, date1, month, year, uname, fname, lname, address, city, state, country; String pin, email, password, gender, lang, qual, relegion, privacy, hobbies, fav; uname = req.getParameter("uname"); fname = req.getParameter("fname"); lname = req.getParameter("lname"); date1 = req.getParameter("date"); month = req.getParameter("month"); year = req.getParameter("year"); address = req.getParameter("address"); city = req.getParameter("city"); state = req.getParameter("state"); country = req.getParameter("country"); pin = req.getParameter("pin"); email = req.getParameter("email"); password = req.getParameter("password"); gender = req.getParameter("gender"); phone1 = req.getParameter("phone"); lang = ""; qual = ""; relegion = ""; privacy = ""; hobbies = ""; fav = ""; dofb = date1 + "-" + month + "-" + year; int phone = Integer.parseInt(phone1); DateFormat formatter; java.util.Date dob; formatter = new SimpleDateFormat("dd-MM-yy"); dob = formatter.parse(dofb); Connection con = prepareConnection(); String Query = "Insert into regdetails values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; PreparedStatement ps = con.prepareStatement(Query); ps.setString(1, uname); ps.setString(2, fname); ps.setString(3, lname); ps.setDate(4, (Date) dob); ps.setString(5, address); ps.setString(6, city); ps.setString(7, state); ps.setString(8, country); ps.setString(9, pin); ps.setString(10, lang); ps.setString(11, qual); ps.setString(12, relegion); ps.setString(13, privacy); ps.setString(14, hobbies); ps.setString(15, fav); ps.setString(16, gender); int c = ps.executeUpdate(); String query = "insert into passmanager values(?,?,?,?)"; PreparedStatement ps1 = con.prepareStatement(query); ps1.setString(1, uname); ps1.setString(2, password); ps1.setString(3, email); ps1.setInt(4, phone); int i = ps1.executeUpdate(); if (c == 1 || c == Statement.SUCCESS_NO_INFO && i == 1 || i == Statement.SUCCESS_NO_INFO) { out.println("<html><head><title>Login</title></head><body>"); out.println("<center><h2>Skypark.com</h2>"); out.println("<table border=0><tr>"); out.println("<td>UserName/E-Mail</td>"); out.println("<form action=login method=post"); out.println("<td><input type=text name=uname></td>"); out.println("</tr><tr><td>Password</td>"); out.println("<td><input type=password name=pass></td></tr></table>"); out.println("<input type=submit value=Login>"); out.println("</form></body></html>"); } else { out.println("<html><head><title>Error!</title></head><body>"); out.println("<center><b>Given details are incorrect</b>"); out.println(" Please try again</center></body></html>"); RequestDispatcher rd = req.getRequestDispatcher("registration.html"); rd.include(req, resp); return; } } catch (ClassNotFoundException cnfe) { out.println("<html><head><title>Error!</title><body>"); out.println("<b><i>Class not found " + cnfe + "</i></b>"); out.println("</body></html>"); } catch (SQLException sqle) { out.println("<html><head><title>Error!</title><body>"); out.println("<b><i>Unable to process try after some time Sql error</i></b>"); out.println("</body></html>"); } catch (ParseException e) { out.println("<html><head><title>Error!</title><body>"); out.println("<b><i>Unable to process Parseint exc " + e + "</i></b>"); out.println("</body></html>"); } out.flush(); out.close(); } } My class path is :
C: \Windows\ system32 > echo % classpath % E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ oui\ jlib\ classes12.jar; E: \app\ JamesPJ\ product 11.2.0\ dbhome_1\ jlib\ orai18n.jar; E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ jdbc\ lib\ ojdc6_g.jar; E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ BIN; C: \Program Files\ Java\ jdk1.7.0_09\ bin; C: \Users\ JamesPJ\ Documents; E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ jdbc\ lib; E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ jlib; E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ jdbc\ lib\ ojdbc6.jar; E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ oc4j\ jdbc\ lib\ orai18n.jar; E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ oc4j\ jdbc\ lib\ ocrs12.jar; E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ owb\ wf\ lib\ ojdbc14.jar; C: \Program Files\ Apache Software Foundation\ Tomcat 7.0\ lib\ servlet - api.jar When I give the
java oracle.jdbc.driver.OracleDriver command in command prompt, it was showing following lines
Error: Main method not found in class oracle.jdbc.driver.OracleDriver, please define the main method as: public static void main(String[] args) 7 Answers
Have you copied classes12.jar in lib folder of your web application and set the classpath in eclipse.
Right-click project in Package explorer Build path -> Add external archives...
Select your ojdbc6.jar archive
Press OK
Or
Go through this link and read and do carefully.
The library should be now referenced in the "Referenced Librairies" under the Package explorer. Now try to run your program again.
15Go through C:\apache-tomcat-7.0.47\lib path (this path may be differ based on where you installed the Tomcat server) then past ojdbc14.jar if its not contain.
Then restart the server in eclipse then run your app on server
3team! For execute SQL-query from your Servlet you should add JDBC jar library in folder
WEB-INF/lib After this you could call driver, example :
Class.forName("oracle.jdbc.OracleDriver"); Now Y can use connection to DB-server
==> 73!
1try to add ojdbc6.jar through the server lib "C:\apache-tomcat-7.0.47\lib",
Then restart the server in eclipse.
I was getting same kinda error but after copying the ojdbc14.jar into lib folder, no more exception.(copy ojdbc14.jar from somewhere and paste it into lib folder inside WebContent.)
I had the same problem but was able to fix it by doing the following:
Right-click on the project -> Properties, then add the JAR (odjbc6 or 14) file in the deployment assembly.
1I was getting same kinda error but after copying the ojdbc14.jar into lib folder, no more exception.(copy ojdbc14.jar from somewhere and paste it into lib folder inside WebContent.)
