I am facing problem while using reverse engineering with exiting DB schema

Version which I am using are
Hibernate Core 3.2.5.ga
HibernateTools-3.2.0.beta9a


Below is the reverse engineering xml,

<hibernate-reverse-engineering>
<schema-selection match-schema="DB_SHM"/>

</hibernate-reverse-engineering>

I tried this using eclipse plugin. I am trying to generate mapping files,config files and domain java files.It generates all files properly for all tables from schema except for one table (PARTY_ROLE). I don't see any error log in the eclipse console during code generation.

PARTY_ROLE table has only two columns and both are part of primary key. This file has one to many relationship with table RELATIONSHIP.
Class files and mapping files for RELATIONSHIP table gets generated properly. Even mapping file for RELATIONSHIP shows relationship for PARTY_ROLE table.


Generated mapping file for RELATIONSHIP table,

<hibernate-mapping>
<class name="com.service.hibernate.Relationship" table="RELATIONSHIP" schema="ODSCUST_OWNER">
<id name="membershipId" type="big_decimal">
<column name="MEMBERSHIP_ID" precision="22" scale="0" />
<generator class="assigned" />
</id>
<many-to-one name="partyRoleByFkRoleTo" class="com.services.hibernate.PartyRole" fetch="select">
<column name="ROLE_ID_TO" precision="22" scale="0" />
<column name="PARTY_ID_TO" precision="22" scale="0" />
</many-to-one>
<many-to-one name="partyRoleByFkRoleFrom" class="com.services.hibernate.PartyRole" fetch="select">
<column name="ROLE_ID_FROM" precision="22" scale="0" />
<column name="PARTY_ID_FROM" precision="22" scale="0" />
</many-to-one>

</class>
</hibernate-mapping>

Could you tell me what is the reason for not generating required files ?

have you tried with the latest release ?

...if it still is a problem there let me know.

After copying eclipse plugin from HibernateTools-3.2.0.beta10 it throws ClassNotFound error whenever i try to load any Hibernate views.

I tried restarting eclipse, still the same error.

For example if try to open ReverseEngineering wizard
Plug-in org.hibernate.eclipse.console was unable to load class org.hibernate.eclipse.console.wizards.NewReverseEngineeringFileWizard.
.

I have checked these files are available under <eclipse_home>/plugins/org.hibernate.eclipse.console_3.2.0.beta10/org.hibernate.eclipse.console.jar

Other files are located as below,
<eclipse_home>/plugins/org.hibernate.eclipse.help_3.2.0.beta10
<eclipse_home>/plugins/org.hibernate.eclipse.mapper_3.2.0.beta10
<eclipse_home>/plugins/org.hibernate.eclipse_3.2.0.beta10
<eclipse_home>/plugins/org.jboss.ide.eclipse.freemarker_1.0.0.beta3
<eclipse_home>/plugins/org.hibernate.eclipse.jdt.apt.ui_3.2.0.beta10.jar
<eclipse_home>/plugins/org.hibernate.eclipse.jdt.ui_3.2.0.beta10.jar

feaures folder i have copied as below ,
<eclipse_home>/features/org.hibernate.eclipse.feature_3.2.0.beta10

Even after updating to HibernateTools-3.2.0.beta10 I still have orginal problem - still not generating PARTY_ROLE table. Behaviour is still the same as before.

I am using oracle 9.2 database and thin driver (ojdbc14.jar) I tried using org.hibernate.dialect.Oracle9iDialect and org.hibernate.dialect.Oracle9Dialect - output is same

add it to jira with the simplest schema and related files so i can reproduce it. thanks.