Error -java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Question

I want to connect to database in java web application.I wrote this code in servlet and i add related jar file(ojdbc) but when i run it,it gives me this error: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

public class DBConnection extends HttpServlet {
    private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public DBConnection() {
        super();
        // TODO Auto-generated constructor stub
    }

    public void service(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {

        Connection con = null;  

        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
              con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.101.84:1521:orcl","XXXX","XXXX");
              if(con!=null)
                 System. out.println("Connection Successful");
              else
                  System.  out.println("error");

        }
        catch (Exception e) {
            //System.out.println(e);
        }
...

what should i do?

Where did you put the JAR ? Put classes12.jar under WEB-INF/lib . — AllTooSir
– AllTooSir, Commented Jul 23, 2013 at 7:23
Do you have that jar in the class path ? Where do you put that jar ? Which application server you are using ? — Veera
– Veera, Commented Jul 23, 2013 at 7:24
I put my jar in Referenced library,I right-click in my project-properties-java build path-add external... — John
– John, Commented Jul 23, 2013 at 7:25
You have to put the relevant jars in the server WEB-INF/lib folder too . It will be picked up from that location during runtime. — AllTooSir
– AllTooSir, Commented Jul 23, 2013 at 7:26

pjmorse · Accepted Answer · 2014-10-01 17:47:48Z

9

I was having the same issue. What you need is to include the ojdbc6.jar file in the Deployment Assembly of the Project:

Right click on the project
select "Properties"
Select "Deployment Assembly" tab
Add your ojdbc6.jar file in it..

...and the problem is solved.

edited Oct 1, 2014 at 17:47

pjmorse

9,3349 gold badges57 silver badges126 bronze badges

answered Oct 1, 2014 at 17:18

Sridhar Pujekar

1061 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user2607985 · Accepted Answer · 2013-07-23 08:54:23Z

0

You can try this by adding your jar of oracle driver into classpath environment variable just for testing purpose. or you can also load it at runtime by supplying the library into endorsed directory of your server (TOMCAT) otherwise you can copy your library file into common lib of your application server . It's just related to the oracle driver library which is not loading at startup of your application..

answered Jul 23, 2013 at 8:54

user2607985

573 silver badges9 bronze badges

Comments

raghu · Accepted Answer · 2014-07-14 17:56:44Z

0

I have faced the same problem but got it fixed Right click on the project->properties and add your jar(ojdbc6 or 14) file in the deployment assembly then it will work...

answered Jul 14, 2014 at 17:56

raghu

11

Comments

Min Phyo · Accepted Answer · 2014-08-15 19:22:33Z

-1

I was having the same issue and what you need is

You must include the ojdbc6.jar file in the Deployment Assembly of the Project.......

1)Right click on the project

2)select "Properties"

3)Select "Deployment Assembly" tab

4)Add your ojdbc6.jar file in it..

and the problem solve.

answered Aug 15, 2014 at 19:22

Min Phyo

112 bronze badges

Collectives™ on Stack Overflow

Error -java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related