错误-java.lang.ClassNotFoundException：oracle.jdbc.driver.OracleDriver [英] Error -java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

问题描述

我想连接到Java Web应用程序中的数据库。我在servlet中编写了此代码，并添加了相关的jar文件（ojdbc），但是当我运行它时，它给了我这个错误：
java.lang.ClassNotFoundException ：oracle.jdbc.driver.OracleDriver

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);
        }
...

我该怎么办？

推荐答案

我遇到了同样的问题。您需要在项目的部署程序集中包括ojdbc6.jar文件：

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

1. 右键单击项目


2. 选择属性


3. 选择部署程序集选项卡


4. 在其中添加ojdbc6.jar文件。 / li>
   

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

...问题已解决。

这篇关于错误-java.lang.ClassNotFoundException：oracle.jdbc.driver.OracleDriver的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！