WallyHartshorn, Thanks to your post, I got it to work as well.
Here is what I did.
1. Reinstalled the Hibernate tools 3.2.0 beta9a
2. Used both hibernate.cfg.xml as well as the reveng.xml file together.
Hibernate.cfg.xml file as below:
Code:
<?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 name="mySessionFactory">
<!-- <property name="hibernate.bytecode.use_reflection_optimizer">false</property> -->
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.password">xxxxx</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@<hostname>:<port>:<sid></property>
<property name="hibernate.connection.username">yyyyyyy</property>
<property name="hibernate.default_schema">SCHEMA</property>
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
</session-factory>
</hibernate-configuration>
hibernate.reveng.xml file as below:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC
"-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd">
<hibernate-reverse-engineering>
<schema-selection match-schema="SCHEMA"/>
<table-filter match-schema="SCHEMA" match-name=".*"/>
</hibernate-reverse-engineering>
The difference I see from what I was doing earlier is that the reverse engineering file has a table filter element now as well, as against having only the schema selection element earlier.
Tanay