CODEWITHSUNDEEP
javamysqlhibernatejdbc
Arthur
Arthur

Reputation: 3797

Hibernate - ClassNotFoundException: com.mysql.jdbc.Driver

I'm trying to retrieve data from a MySQL database through Hibernate, but I'm stuck with this error:

Failed to create sessionFactory object.org.hibernate.service.classloading.spi.ClassLoadingException: Specified JDBC Driver com.mysql.jdbc.Driver could not be loaded

java.lang.ClassNotFoundException: Could not load requested class : com.mysql.jdbc.Driver
[...]

I use a class called DAOFactory to get the hibernate session:

public class DAOFactory {

    private static boolean isInstance = false;  
    private static SessionFactory sessionFactory;
    private static ServiceRegistry serviceRegistry; 
    private static Session session;

    private DAOFactory() throws ExceptionInInitializerError{        
        if( !isInstance ) {
            try {               
                Configuration cfg   = new Configuration().configure();              
                serviceRegistry     = new ServiceRegistryBuilder().applySettings(cfg.getProperties())
                                                .buildServiceRegistry();
                sessionFactory      = cfg.buildSessionFactory(serviceRegistry);
            } catch (Throwable ex) {
                System.err.println("Failed to create sessionFactory object."+ ex);
                throw new ExceptionInInitializerError(ex);
            }
            session = sessionFactory.openSession();         
            isInstance = true ;
        }               
    }

    public static DAOFactory getInstance() {        
        return new DAOFactory() ;
    }

    public Session getSession() {
        return session ;
    }
}

hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
                                         "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory name="">
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/enigma</property>
        <property name="connection.username">root</property>
        <property name="connection.password"></property>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="connection.pool_size">1</property>
        <property name="current_session_context_class">thread</property>
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
        <property name="show_sql">true</property>
        <property name="hbm2ddl.auto">update</property>
    </session-factory>
</hibernate-configuration>

And mysql-connector-java-5.1.26-bin.jar is already in the classpath:

classpath

Does anyone see what I'm missing ?

Upvotes: 21

Views: 74185

Answers (7)

sanwar hossain
sanwar hossain

Reputation: 11

Faced the same issue with mysql-connector-java-5.1.48-bin.jar. To fix this issue I changed the driver class name from

com.mysql.cj.jdbc.Driver to

com.mysql.jdbc.Driver

Upvotes: 1

jyotinadda
jyotinadda

Reputation: 61

Download mysql-connector-java-8.0.20.jar from https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.20/ Add the jar to class path

Run -> Run Configurations... -> Classpath -> Add external JAR.

Upvotes: 0

Sagar Trehan
Sagar Trehan

Reputation: 2446

Faced the same issue with mysql-connector-java-5.1.48-bin.jar. To fix this issue I changed the driver class name from 

<property name="connection.driver_class">com.mysql.cj.jdbc.Driver</property>

to 

<property name="connection.driver_class">com.mysql.jdbc.Driver</property>

Upvotes: 6

Nirmal Seneviratne
Nirmal Seneviratne

Reputation: 111

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.15</version>
    <scope>provided</scope> 
</dependency>
  • I had above dependency in Maven.
  • The scope tag had caused the error.
  • Removing scope tag solved the problem.

Upvotes: 0

ROMANIA_engineer
ROMANIA_engineer

Reputation: 56616

For those who use Maven: add the following dependency in pom.xml.

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.17</version>
</dependency>

or choose another version from here.

Then you can get the artifact using:

mvn dependency:resolve

(if you don't use the IDE).

Upvotes: 25

Dzmitry Alifer
Dzmitry Alifer

Reputation: 439

In some cases it can be not a suitable solution to add jar to classpath via Run -> Run Configurations... -> Classpath -> Add external JAR.

First case

When the jar file cannot be put into classpath folder, there is alternative way to load class from the another place. You just need to instantiate URLClassLoader and then invoke loadClass() on it (was mentioned here):

URLClassLoader urlCL = new URLClassLoader(new URL[] {"path_to_jar"});
Class driverClass = urlCL.loadClass("com.mysql.jdbc.Driver");

Second case

If you would like to add your class to classpath at runtime (I prefer the answer of Ranjit Aneesh here), for this purpose you may create a very simple custom class loader extending URLClassLoader with the only overridden addUrl method:

public class DynamicURLClassLoader extends URLClassLoader {

    public DynamicURLClassLoader(URLClassLoader classLoader) {
        super(classLoader.getURLs());
    }

    @Override
    public void addURL(URL url) {
        super.addURL(url);
    }
}

Then invoke it:

URLClassLoader urlCL = (URLClassLoader) ClassLoader.getSystemClassLoader();
new DynamicURLClassLoader(urlCL).addURL("path_to_jar");

Upvotes: 2

Arthur
Arthur

Reputation: 3797

Thanks to Reimeus for the answer. mysql-connector-java-5.1.26-bin.jar needs to be in the runtime classpath.

Run -> Run Configurations... -> Classpath -> Add external JAR.

Clean everything, try again, and the Exception is gone.

Upvotes: 32

Related Questions