java lang ClassNotFoundException oracle jdbc driver OracleDriver

Question

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  amp  amp  i    1    i    Statement SUCCESS NO INFO                    out println   lt html gt  lt head gt  lt title gt Login lt  title gt  lt  head gt  lt body gt                     out println   lt center gt  lt h2 gt Skypark com lt  h2 gt                     out println   lt table border 0 gt  lt tr gt                     out println   lt td gt UserName E-Mail lt  td gt                     out println   lt form action login method post                    out println   lt td gt  lt input type text name uname gt  lt  td gt                     out println   lt  tr gt  lt tr gt  lt td gt Password lt  td gt                     out println   lt td gt  lt input type password name pass gt  lt  td gt  lt  tr gt  lt  table gt                     out println   lt input type submit value Login gt                     out println   lt  form gt  lt  body gt  lt  html gt                   else                   out println   lt html gt  lt head gt  lt title gt Error  lt  title gt  lt  head gt  lt body gt                     out println   lt center gt  lt b gt Given details are incorrect lt  b gt                     out println   Please try again lt  center gt  lt  body gt  lt  html gt                     RequestDispatcher rd   req getRequestDispatcher  registration html                    rd include req  resp                   return                          catch  ClassNotFoundException cnfe                out println   lt html gt  lt head gt  lt title gt Error  lt  title gt  lt body gt                 out println   lt b gt  lt i gt Class not found     cnfe     lt  i gt  lt  b gt                 out println   lt  body gt  lt  html gt               catch  SQLException sqle                out println   lt html gt  lt head gt  lt title gt Error  lt  title gt  lt body gt                 out println   lt b gt  lt i gt Unable to process try after some time Sql error lt  i gt  lt  b gt                 out println   lt  body gt  lt  html gt               catch  ParseException e                out println   lt html gt  lt head gt  lt title gt Error  lt  title gt  lt body gt                 out println   lt b gt  lt i gt Unable to process Parseint exc     e     lt  i gt  lt  b gt                 out println   lt  body gt  lt  html gt                        out flush            out close              My class path is    C   Windows  system32  gt  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

User · Answer

team   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

User · Answer

Go 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

User · Answer

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

User · Answer

try to add ojdbc6 jar through the server lib  C  apache-tomcat-7 0 47 lib    Then restart the server in eclipse

User · Answer

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

User · Answer

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

User · Answer

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

[java] java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Examples related to java

Examples related to servlets

Examples related to jdbc

Examples related to tomcat7