how to specify the foreing key names on reverse engineering

dleal · **Posted:** Thu Feb 23, 2006 7:53 pm

Dear members,

I have a relation like this:

Code:

Shareholder         ShareholderType
type              --> shareholder_type_id

so type is a foreign key of shareholder_type_id. I would like to get on the generated class the attribute name of type to be mapped into type instead of default generation setting which is: shareholderType.
on the Shareholder.hbm.xml file I get (using hbm2hbmxml)

Code:

    <many-to-one name="shareholderType" class="com.schinvest.lra.domain.ShareholderType" fetch="select">
            <column name="type" not-null="true" />
        </many-to-one>

but I would like to get instead shareholderType name the simple name type.

Looking into the Hibernate Tool documentation, you can redefine some properties on the reverse enginerring process, but for me it is confuse, because there is information about the foreign key setting on multiple places, for example, on column node:

Code:

<column
 name="column_name"
 jdbc-type="java.sql.Types type"
 type="hibernate_type"
 property="propertyName"
 exclude="true|false"
 foreign-catalog="catalogName"
 foreign-schema="schemaName"
 foreign-table="tableName"
 foreign-column="columnName"
/>

and also there is a node <foreign-key> inside the node table with the following information:

Code:

<foreign-key
  name="foreignKeyName"
  foreign-catalog="catalogName"
  foreign-schema="schemaName"
  foreign-table="tableName"
 >
 <column-ref local-column="columnName" foreign-column="foreignColumnName"/>
</foreign-key>

where do I have to change the information in order to really get type on the Shareholder class?

(Note: The root table definition should be something like this:

Code:

<table 
 catalog="catalog_name"
 schema="schema_name"
 name="table_name"
 class="ClassName"
>
 <primary-key...>
 <column...>
 <foreign-key...>
</table>

)

The table definition is:

Quote:

CREATE TABLE shareholder_type (
shareholder_type_id INT(2) UNSIGNED NOT NULL AUTO_INCREMENT
, name VARCHAR(10) NOT NULL
, PRIMARY KEY (shareholder_type_id)
)TYPE=InnoDB;

CREATE TABLE shareholder (
shareholder_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT
, type INT(2) UNSIGNED NOT NULL
, CONSTRAINT fk_shareholder_2 FOREIGN KEY (type)
REFERENCES shareholder_type (shareholder_type_id)
)TYPE=InnoDB;
ALTER TABLE shareholder COMMENT='Share holders information'

I have tried with some change combinations but I didn't get the expected result.

Thanks in advance,

David Leal

max · **Posted:** Fri Feb 24, 2006 7:51 am

it is not possible yet via reveng.xml (when it will be possible it will most likely be in the <foreign-key> region but haven't made a decision yet).

anyway, it is controllable via code by implementing reverseengineeringstrategy that returns what you want for the methods foreignKeyToEntityName and foreignKeyToCollectionName.

dleal · **Posted:** Fri Feb 24, 2006 9:52 am

Max,

Thanks again, I am any way surpise about your comment because on the User Manual Documentation (it is true that it is a bet version) it seems to be possible to configure it with some of these keys.

It is no so much important for me, I will wait until you make a desition about how to setup vía reveng.xml.

Thanks again,

David

max · **Posted:** Fri Feb 24, 2006 10:07 am

where in the docs does it state this ?

dleal · **Posted:** Fri Feb 24, 2006 11:05 am

look here Max:

http://www.hibernate.org/hib_docs/tools ... e/#d0e1122

max · **Posted:** Fri Feb 24, 2006 12:08 pm

ok...i can see the ambigious point here ;)

The property column is only used for properties not collections nor many-to-one...but i guess it could make sense to use it for the many-to-one part.