How to generate class path from schema name

Blackbrrd · **Joined:** Wed Sep 28, 2005 6:45 pm **Posts:** 56

I have got two tables with the same names in two different schemas. When I try to reverse engineer I get this error message:

org.hibernate.cfg.JDBCBinderException: Duplicate class name 'no.Image' for 'org.hibernate.mapping.Table(etel.image)'. Same name where generated for 'org.hibernate.mapping.Table(etel.image)'

I would like to generate two classes (from the two tables: crm.Image and etel.Image), called no.crm.Image and no.etel.Image instead of one class called no.Image.

(There are two similair tables in the same database because two legacy databases were merged)

I can't do it in a two step process because the two schemaes are getting integrated by foreign keys...

max · **Posted:** Sat Jun 17, 2006 3:48 am

use a reveng.xml to rename the destination class for the conflicting class.

Blackbrrd · **Joined:** Wed Sep 28, 2005 6:45 pm **Posts:** 56

It seems I need to have unique entitynames as well, because otherwise I get the following error message:

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

This isn't strange at all since I have got two entities like this:

Code:

package crm;
@Entity
@Table(name = "timage", schema = "crm", uniqueConstraints = {})
public class Timage implements java.io.Serializable {
...

package etel;
@Entity
@Table(name = "timage", schema = "etel", uniqueConstraints = {})
public class Timage implements java.io.Serializable {
...

If I edit the java files manually to:

Code:

package crm;
@Entity(name="crm.Timage")
@Table(name = "timage", schema = "crm", uniqueConstraints = {})
public class Timage implements java.io.Serializable {
...

package etel;
@Entity(name="etel.Timage")
@Table(name = "timage", schema = "etel", uniqueConstraints = {})
public class Timage implements java.io.Serializable {
...

it works, but I would like to be able to reverse-enginer without any manual steps.

What I want is to have the Entities name like this @Entity(name="schemaname.tablename") instead of just @Entity which is the same as writeing @Entity(name="tablename")

I already have a reverse-engineering strategyfile that extends DelegatingReverseEngineeringStrategy so that the files use the sequences in postgres, but I can't see any method in DelegatingReverseEngineeringStrategy for changeing the entityname.

Thanks in advance for any help :)

max · **Posted:** Tue Jun 20, 2006 7:03 am

you need to return the proper class name from tableToClassName(TableIdentifier tableIdentifier); and it should just work.

Blackbrrd · **Joined:** Wed Sep 28, 2005 6:45 pm **Posts:** 56

I don't really want to change the classname Timage to EtelTimage.

I just want to change the entityname if that is possible - or adviceable?

max · **Posted:** Tue Jun 20, 2006 7:23 am

huh ? Your should return the *full* class entityname then it will work.

You don't need to have EtelTimage, but just (as you already have shown) have two classes TImage in two different packages.)

In this case different entityname occurs automatically and thus you don't need explicit different entitynames.

the tools doesn't support reveng entitynames!=classname, but it does support same simple classname in different packages.

Blackbrrd · **Joined:** Wed Sep 28, 2005 6:45 pm **Posts:** 56

I think I have not been good at explaining the problem, or maybe I am misunderstanding your answer :(

The problem occurs when I try to create the session factory with code like this:

Code:

sessionFactory = new AnnotationConfiguration().buildSessionFactory();

the hibernate.cfg.xml looks like this:

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>
        ....
        <mapping class="crm.Timage" />
        ....
        <mapping class="etel.Timage" />
        ...
    </session-factory>
</hibernate-configuration>

My hibernate.reveng.xml file looks like this:

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>
  ...
  <table-filter match-schema="etel" package="etel" match-name="timage"/>
  ...
  <table-filter match-schema="crm" package="crm" match-name="timage"/>
  ...

As far as I can understand, the AnnotationException occurs because the entity names aren't specified, so the entity names defaults to the classname, not packagename+classname. Therefore, there are two entities with the same name, Timage...

I don't get how overriding tableToClassName will help me, as it is already returning etel.Timage and crm.Timage as far as I can understand...

max · **Posted:** Tue Jun 20, 2006 7:55 am

hmm....annotationconfiguration imo should work outofthebox with this...maybe you need to disable auto-import or something.

i'll need to check with emmanuel.

Blackbrrd · **Joined:** Wed Sep 28, 2005 6:45 pm **Posts:** 56

I think the subject might be mentioned here:
http://opensource.atlassian.com/project ... se/ANN-341

but I am not really any closer to a automatic solution :(

max · **Posted:** Tue Jun 20, 2006 8:12 am

looks like a correct match.

so to fix this in your setup go in and change the templates to always add an @Entity("fullqualifiedclassname") to the class.

Blackbrrd · **Joined:** Wed Sep 28, 2005 6:45 pm **Posts:** 56

That was what I wanted to do, but I don't know how to do it :)

max · **Posted:** Tue Jun 20, 2006 9:13 am

copy pojo/Ejb3TypeDeclaration.ftl from hibernate-tools.jar to a directoy, e.g. "templates/pojo" (do remember to keep the pojo directory name)

change it's name assignment to $pojo.qualifiedDeclarationName and then set template path to point to the "templates" directory.

Blackbrrd · **Joined:** Wed Sep 28, 2005 6:45 pm **Posts:** 56

Thanks, that was just what I needed :)