Question 160886 in Mysql Question posted in
The official MySQL documentation can be found here.

Can’t load JDBC driver ‘com.mysql.cj.jdbc.Driver.class’?

I’m trying to connect Context.xml file to my Demo.java(Servlet) on Eclipse.
Cannot load JDBC driver class ‘com.mysql.cj.jdbc.Driver.class’.
Please let me know where I’m wrong.
Please help.
Demo.java(servlet) with console
Context.xml file

mysql-connector jar is added wherever possible. still not able to resolve the exception

Tags:

2

Answers


  1. 0

    It seems your context.xml has com.mysql.cj.jdbc.Driver.class mentioned. You should not mention .class there. Just mention com.mysql.cj.jdbc.Driver. This is the fully qualified class name. If you add .class at the end, then Driver becomes the package, and it tries to search for a driver class by name class in the Driver package, which it won’t find.

    So,

    driverClassName="com.mysql.cj.jdbc.Driver"
    Login or Signup to reply.
  2. 0

    it seems that the issue is related to the JDBC driver class not being found by your servlet. Here are some possible solutions that you can try:

    1. Make sure that the JDBC driver JAR file is included in your project’s classpath. You can do this by adding the JAR file to the "lib" folder of your web application, or by adding it to the build path of your project in Eclipse. If you have already added the JAR file, make sure that it is the correct version and that it is not corrupted.

    2. Check the spelling of the JDBC driver class name. The error message indicates that the driver class name is "com.mysql.cj.jdbc.Driver.class", but it should be "com.mysql.cj.jdbc.Driver". Make sure that you are using the correct class name in your code.

    1. Check the format of your JDBC connection URL in your servlet code. It should be in the format "jdbc:mysql://hostname:port/databaseName", where "hostname" is the name of the server where MySQL is running, "port" is the port number on which MySQL is listening (usually 3306), and "databaseName" is the name of the database you want to connect to.

    2. If you are using Tomcat as your servlet container, make sure that your context.xml file is located in the correct location (under the "META-INF" folder of your web application) and that it is properly formatted. You can also try adding the JDBC driver configuration to your Tomcat server configuration file (usually located at "$TOMCAT_HOME/conf/server.xml").

    Check that your MySQL server is running and that the user credentials you are using in your JDBC connection URL have the necessary permissions to access the database.

    I hope this helps! Let me know if you have any further questions or if any of these solutions solve your issue.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search