Avoiding Hibernate Annotation Exception when using two identically named tables in two different schemas

Question

I have two tables, both named Language in two different schemas, lets call them schema1 and schema2.

When I annotate the models for each of these tables, my code looks like this: @Entity @Table(name="language", catalog="schema1") public class Language {

.....................

 @Entity
 @Table(name="language", catalog="schema2")
 public class Language {

But when doing this, I get an annotation Exception error as follows:

org.hibernate.AnnotationException: Use of the same entity name twice: Language

So, does this mean I can't have identically named tables in two different database schemas or am I just annotating my models wrong?

Thank you,

Elliott

Did you try to use schema attribute of Table annotation instead of catalog? — svaor
– svaor, Commented Nov 1, 2011 at 16:56

NeoAcheron · Accepted Answer · 2013-08-06 11:32:50Z

4

I've had the same issue, in a complex class structure, and the answer above is just a workaround. You can define the @Entity annotation with a name variable to distinguish the two classes from each other. Ex:

Class 1:

@Entity(name="language_v1")
@Table(name="language", catalog="schema1")
public class Language {

Class 2:

@Entity(name="language_v2")
@Table(name="language", catalog="schema2")
public class Language {

This will allow you to keep your class structure.

answered Aug 6, 2013 at 11:32

NeoAcheron

1116 bronze badges

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

Comments

Elliott · Accepted Answer · 2011-11-01 19:11:18Z

0

It turns out that the model in schema 2 was an object that was an extension of the model object in schema 1. Hibernate does not like this kind of construction when the two tables are named the same. Making the second object not an extension of the first, eliminated the problem.

answered Nov 1, 2011 at 19:11

Elliott

5,61711 gold badges52 silver badges91 bronze badges

Collectives™ on Stack Overflow

Avoiding Hibernate Annotation Exception when using two identically named tables in two different schemas

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related