Hibernate Tools "Duplicate class" error on reverse engineering

Question

I am trying to reverse engineer a SQL Server 2005 using Hibernate Tools and am getting a strange error:

org.hibernate.cfg.JDBCBinderException: 
     Duplicate class name 'CheckConstraints' generated for
     'org.hibernate.mapping.Table(e2rm_maintenance_development2.sys.check_constraints‌)'. 
     Same name where generated for             
     'org.hibernate.mapping.Table(e2rm_maintenance_development2.sys.check_constraints‌)' 

    Duplicate class name 'CheckConstraints' generated for 
    'org.hibernate.mapping.Table(e2rm_maintenance_development2.sys.check_constraints‌)'. 
    Same name where generated for 
    'org.hibernate.mapping.Table(e2rm_maintenance_development2.sys.check_constraints‌)'

Dimitri Dewaele · Accepted Answer · 2013-07-26 06:54:42Z

19

A development user has typically access to multiple database schema s with similar tables. The Generation tool tries to generate output for all those databases and this results in duplicate class names (even if you ask for ddl generation).

Add a 'reveng' setup and limit the output to one database schema.

Also add necessary parameters from the selected 'Exporters'. Some are necessary, but this is not indicated in the overview.

Configure with reveng.xml

Add necessary variables

edited Jul 26, 2013 at 6:54

answered Jul 25, 2013 at 14:49

Dimitri Dewaele

10.8k22 gold badges84 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

KingFeming Over a year ago

What should i do after clicking on Add Exporter Property ? what should i give for values ??

Arpit Aggarwal Over a year ago

Selecting the specific Database Schema worked for me!

yu yang Jian Over a year ago

multiple database schema filter to single

Daniil Shevelev · Accepted Answer · 2013-07-11 14:09:09Z

4

I was able to avoid the error by creating "hibernate.reveng.xml" in which I excluded "sys" and "INFORMATION" schemas and only included "dbo" schema.

answered Jul 11, 2013 at 14:09

Daniil Shevelev

12.1k12 gold badges53 silver badges73 bronze badges

1 Comment

cp. Over a year ago

How did you exclude schema please? I am trying in NB8.02 even with explicit schema & explicit tables still get "'validname.CheckConstraints" on db.sys.check_constraint.

RMagen · Accepted Answer · 2018-02-04 11:32:03Z

1

as a continue to Daniil Shevelev answer (this is what worked for me ) in order to exlude schema add new reveng.xml then choose new and on the next screen click next -then click refresh on the buttom (takes some time to get the schemas) then stand on the relevant scheme and exclude it

answered Feb 4, 2018 at 11:32

RMagen

6222 gold badges10 silver badges23 bronze badges

Collectives™ on Stack Overflow

Hibernate Tools "Duplicate class" error on reverse engineering

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related