I'm using Hibernate 3.1 with both Oracle 10G and MySql. The app server is WebSphere 6 under RAD 6.

MySql works fine.

But Oracle mysteriously switches from org.hibernate.dialect.OracleDialect to net.sf.hibernate.dialect.Oracle9Dialect. A file search shows that the string "net.sf.hibernate.dialect.Oracle9Dialect" occurs nowhere in any of my ascii files.

Here is the relevant stack trace portion:

[8/26/06 14:23:20:729 GMT-05:00] 00000017 SystemErr R org.hibernate.HibernateException: Dialect class not found: net.sf.hibernate.dialect.Oracle9Dialect
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:81)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:42)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:378)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:110)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1869)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1162)
at testhibernate.MyAppContextListener.contextInitialized(MyAppContextListener.java:31)

Here is the relevant hibernate configuration file - hibernate_oracle.cfg.xml:

<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory
name="java:hibernate/OracleSessionFactory">
<property name="connection.datasource">jdbc/MyOracleDataSource</property>
<property name="dialect">org.hibernate.dialect.OracleDialect</property>

<mapping resource="testhibernate/Employee.hbm.xml"/>

</session-factory>

</hibernate-configuration>

I had the same problem and found in order to fix it I did not need to include ehcache in my project/classpath. Make sure you include the jar files the docs say to.
For me to fix it I wrote a log4j.properties file as follows:

and included the following in my Oracle config file:

If any of the above doesnt work for then do some reading in doc files cos thats where I found all this stuff . Good luck.

Oops Sorry I replied to the wrong post. Im crawling back into my hole.