HibernateException: JDBC Driver class not found: oracle.jdbc.driver.OracleDriver

[Deepak Kumar Jena]

Trying to create a standalone application using Hibernate 3.0 and Oracle 10g. The Client Application, POJO class, Mapping File and Configuration File are placed in the same folder, and all the required jar files including ojdbc14.jar are included in the classpath. Compilation is Fine, but during execution throwing HibernateException: JDBC Driver class not found: oracle.jdbc.driver.OracleDriver.

The driver_class, url, username, password are mapped in configuration file and using the same in normal jdbc application able to insert data in the table. But in this case it is throwing exception.

Please suggest.

[Bosun Bello]

Verify your classpath settings for the location of that driver. That driver cannot be resolved, which points to a classpath issue.

[Philip Thamaravelil]

Your missing the oracle jdbc jar.

http://findjar.com is a handy resource.

[Deepak Kumar Jena]

The ojdbc14.jar has been copied from the Oracle installation folder and placed in a folder named Libraries. The jar has been added to the classpath. I am able to write/run normal jdbc applications and even the same in Struts application. But in case of Hibernate it is generating exception.

[Waswani Naresh]

Please provide your DB configuration file.

Regards,
Naresh

[Philip Thamaravelil]

How are you compiling and executing? Ant?

Your hibernate jar's are in the same directory as the oracle jdbc jar correct?

[Deepak Kumar Jena]

I am compiling the files using javac in command prompt. The hibernate.jar and ojdbc14.jar are placed under the same folder i.e. C:\Libraries and both has been added to the classpath.

[Deepak Kumar Jena]

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
	<!-- Database connection settings -->
        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
        <property name="connection.username">scott</property>
        <property name="connection.password">tiger</property>
        
        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.OracleDialect</property>      

      	<!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

	<mapping resource="employee.hbm.xml"/>
</session-factory>
</hibernate-configuration>

[Paul Clapham]

Deepak Kumar Jena wrote:I am compiling the files using javac in command prompt. The hibernate.jar and ojdbc14.jar are placed under the same folder i.e. C:\Libraries and both has been added to the classpath.

That has nothing at all to do with errors which happen at run time.

[Philip Thamaravelil]

Are you compiling a executable jar file?

If so, have you included the oracle jar path in the executable jar's Manifest?


Ant usually eliminates (or minimizes) these types of issues.

[Deepak Kumar Jena]

import org.hibernate.*;
import org.hibernate.cfg.*;

public class EmployeeClient
{
	public static void main(String args[]) throws Exception
	{
		try
		{
			Session session = new Configuration().configure().buildSessionFactory().openSession();

			Transaction txn = session.beginTransaction();

			EmployeeBean emp = new EmployeeBean();

			emp.setEmpNo(10);
			emp.setEmpName("Tom");
			emp.setEmpAddr("London");

			session.save(emp);

			txn.commit();

			session.close();

			//factory.flush();
		}
		catch(HibernateException he)
		{
			//System.out.println("Hibernate Exception :: "+he);
			he.printStackTrace();
		}
	}
}

[Deepak Kumar Jena]

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
  <class name="EmployeeBean" table="EMPLOYEE">
	  <id name="empNo" column="EMPNO" >
	  </id>

	  <property name="empName" column ="EMPNAME" />
	  <property name="empAddr" column ="EMPADDR" />
  </class>
</hibernate-mapping>

[Deepak Kumar Jena]

public class EmployeeBean implements Serializable
{
	private int empNo;
	private String empName;
	private String empAddr;

                //getter and setter methods folows here
}

[Deepak Kumar Jena]

I am getting error during compilation (Not using Ant). The jar files are placed in the classpath and they are visible in command prompt (using classpath). Database is also up. I have doubts about the version of the JARS. Suggest about all the required JARS with version detail.

[Philip Thamaravelil]

Sounds like to are compiling EmployeeBean with the c:\libraries classpath set in javac,
then run the EmployeeBean class directly with the java command right?


Here's what I would do if I had this problem:

I would change the directory structure:

myproject\
myproject\lib <-- put all jars in this directory.
myproject\src <-- your EmployeeBean and other java files here.
myproject\build
myproject\build.xml

Then using ant, I would compile the code in src to create a jar file that has a class-path specified relative to the current location..


Here's a sample:

<project name="test1"  basedir=".">


	<path id="classpath">
		<pathelement location="lib/oraclejdbc.jar" />
		<!-- list your jars here..-->
	</path>

	<target name="build_jar">
		<mkdir dir="build"/>

    		<javac srcdir="src" destdir="build">
      			<classpath refid="classpath"/>
    		</javac>

		
		<jar destfile="YOUR_JAR_FILE.jar" >
    			<fileset dir="${build}"  />
			<manifest>
        			<attribute name="Main-Class" value="your.signature.to.EmployeeBean" />
				<attribute name="Class-Path" value="lib/jar1.jar lib/jar2.jar lib/jar3.jar" /> <!-- again, include all jar's -->
      			</manifest>
  		</jar>


	</target>

</project>

Then from your command line...run the ant tasks defined for compiling and building..

afterwords..once you compile your runnable jar...you can simply run it by...

#>java -jar myRunnableJar.jar

[Philip Thamaravelil]

What is your command syntax for compiling and executing?

[Deepak Kumar Jena]

I am using javac *.java at the command prompt. The POJO class (EmployeeBean.java) is getting compiled into .class file while the Hibernate Client Application (EmployeeClient.java) is throwing Exception during compile-time.

Actually, I am interested in compiling the files manually through Command prompt, but not interested in using tools like Ant for this purpose.

[Philip Thamaravelil]

You will consistently run into these types of issues with your build process.

[Deepak Kumar Jena]

I am looking forward to debug the issue to find out the root cause. Using tools to avoid the errors is not a good move. As per my knowledge the issues are related to the dtd schema (XML) and may be specific to the environment (jar versions, classpath settings,etc). Even the same Exception is getting generated in MyEclipse.