I was doing reverse engineering in eclipse with hibernate tools, and I have followed steps stated in the

http://www.hibernate.org/hib_docs/tools ... e/en/html/

all was going alright, in the hibernate configuration window I can see my database , tables ,objects but when I click code generation the strange message appears :

org.hibernate.cfg.JDBCBinderException: Foreign key name ($1) mapped to different tables!

I use PostgreSQL 7.4.7 and jdbc driver pg74.216.jdbc3.jar
and here is the code of my database:

create table car_owner(id serial primary key,name varchar(20),
surname varchar(20),jmbg integer);
create table reg_plate(id serial primary key,plate_signature char(2),
plate_number integer unique,id_car_owner integer references car_owner);
create table address(id serial primary key,street varchar(20),
city varchar(20),country varchar(20),id_car_owner integer references car_owner);

I would be gratefull if some could help me.

use proper unique names for your foreign keys. (later postgress' does this automatically afaik, but until then you have to name them uniquely your self)

What did You mean under the term unique proper names , give an example ?

Even if I change the names of my foreign keys that doesn't matter a great thing with respect to stated error.

eh why don't you think

org.hibernate.cfg.JDBCBinderException: Foreign key name ($1) mapped to different tables!

will change if you change the automatically generated (by postgress) key name $1 to something unique ?

What you have said concerns postgres server, but all the time I was thinking that you are trying to say that my problem is connected with the DDL ,i.e. the tables which I have created.

eh yes and ?

It relates to both since you have not been naming your foreign keys uniquely which is needed on older postgress'

I have successfully solved my problem. The solution has been in the few lines of code

ALTER TABLE address ADD CONSTRAINT first_foreign_key FOREIGN KEY(id_car_owner) REFERENCES car_owner

ALTER TABLE reg_plate ADD CONSTRAINT second_foreign_key FOREIGN KEY(id_car_owner) REFERENCES car_owner

but manually changing of foreign keys are big burden if I have many tables, so I decided
to migrate to higher version of Postgress

SO MAX WHAT WOULD I DO WITHOUT YOUR SUGGESTIONS.
Nothing, sit and cry.

so now you don't need to sit and cry couldn't you use a minute or two to put some details about this via the wiki page described here http://forum.hibernate.org/viewtopic.php?t=956490 ?

Thanks!

Come on max, to post a litteraly correct prose isn't so easy as it may seems.
and you have to take in consideration that English is not my mother language.
But business must not take a burden and we users have to use such a great thing as hibernate is, without any obstacles on ours way.So I decided to get a 15minutes and post my problem, an example of the problem, and the solution at the stated page

http://forum.hibernate.org/viewtopic.php?t=956490 ?

I appreciate the description (and english is also not my mother language)

In any case, the *wiki* is still the correct place to put this - e.g. put it on the driver page in short form and link to the bigger description.

In any case, thanks for the description.

good idea, I will put it.