I am using Oracle thin drive to test out few examples. For some reasons, hibernate code can locate my classes12.zip (oracle JDBC implementation). It is in my classpath because I can use direct JDBC call with no problems.

Thanks.

EXAMPLE CODE:

public class Test
{
public void someDBTest() throws Exception
{
String url = "jdbc:oracle:thin:@localhost:1521:was";
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn =
DriverManager.getConnection(url, "ejsadmin", "ejsadmin");
DatabaseMetaData meta = conn.getMetaData();
//ResultSet rs = meta.getTables(null, null, null, null);
ResultSet rs = meta.getSchemas();
while (rs.next())
{
System.out.println(rs.getString("TABLE_SCHEM"));
}
}

public static void main(String[] args) throws Exception
{
Test test = new Test();
//I'm only doing this to prove the point that I can see driver classes.
test.someDBTest();

//HERE IS THE ERROR PART???
SessionFactory factory =
new Configuration().configure().buildSessionFactory();
}
}



OUTPUT:

It prints out all the content I'm requested from the DB but give me
error when try to get SessionFactory as:

[FATAL] DriverManagerConnectionProvider - -JDBC Driver class not found: oracle.jdbc.driver.OracleDriver
Exception in thread "main" net.sf.hibernate.HibernateException: JDBC Driver class not found: oracle.jdbc.driver.OracleD
river
at net.sf.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:57
)
at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83
)
at net.sf.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:153)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:627)
at Test.main(Test.java:13)



HIBERNATE CONFIG FILE:

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

<!-- Generated file - Do not edit! -->

<hibernate-configuration>

<!-- a SessionFactory instance listed as /jndi/name -->
<session-factory name="HibernateFactory">

<!-- properties -->
<property name="connection.driver_class"> oracle.jdbc.driver.OracleDriver </property>
<property name="connection.url"> jdbc:oracle:thin:@localhost:1521:was </property>
<property name="connection.username"> ejsadmin </property>
<property name="connection.password"> ejsadmin </property>
<property name="dialect"> net.sf.hibernate.dialect.OracleDialect </property>
<property name="show_sql">false</property>
<property name="use_outer_join">false</property>


<!-- mapping files -->
<mapping resource="com/test/Customer.hbm.xml" />
</session-factory>

</hibernate-configuration>

must be

Remove extra whitespace inside property body

Hmmmm. we should trim, I suppose.