JSP Project with Database

Asked

Viewed 79 times

1

I am working on a JSP project with database my driver is not being recognized.

I am using the following method to connect to the bank.

public ConnectionDB(){
    try {
        Class.forName("com.mysql.jdbc.Driver");

        String url = "jdbc:mysql://localhost:3306/loja";
        String user = "hxf";
        String password = "";
        con = (Connection)DriverManager.getConnection(url,user,password);

    } catch (SQLException e) {
        e.printStackTrace();
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
}

I am using Tomcat. The following error is returned.

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1891)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1734)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at DAO.ConnectionDB.<init>(ConnectionDB.java:13)

Does anyone have any idea what it might be?

java jdbc

  • added mysql driver to your project ?

  • 1

    Maybe this is a duplicate of this question: http://answall.com/q/141603/132 - Although the question is not exactly the same, I recommend the same answer.

1 answer

2

  • Thanks guys. I managed to solve. I added the driver in the WEB-INFO/lib folder and it worked.

Browser other questions tagged java jdbc

You are not signed in. Login or sign up in order to post.