i've read about the automatic generation of class and map files and i've tried it with
eclipse. but i got and error and i don't know why.

when i start the artifact generation i get the follow:

>>> org.hibernate.cfg.JDBCBinderException: Foreign key name mapped to different tables! <<<

my database is the following:

create sequence users_index_seq minvalue 1 cycle;

create table users (
userid INTEGER NOT NULL DEFAULT
NEXTVAL('users_index_seq'),
dw VARCHAR(4) NOT NULL,
pin VARCHAR(10) NOT NULL,
name VARCHAR(30) NOT NULL,
pic BYTEA NOT NULL,
stateindex INT8 NOT NULL DEFAULT(0),
lastaction TIMESTAMP NOT NULL DEFAULT
now(),
date TIMESTAMP NOT NULL DEFAULT
now(),
PRIMARY KEY (userid)
);

create table logged (
index INT8 NOT NULL,
userid INTEGER NOT NULL,
state INTEGER NOT NULL DEFAULT(1),
came TIMESTAMP NOT NULL,
gone TIMESTAMP,
exported BOOLEAN NOT NULL DEFAULT('false'),
inworktab BOOLEAN NOT NULL DEFAULT('false'),

PRIMARY KEY (index, userid),
FOREIGN KEY (userid) REFERENCES users(userid)
);


create table workLogs (
index INT8 NOT NULL,
loggedid INT8 NOT NULL,
userid INTEGER NOT NULL,
state INTEGER NOT NULL DEFAULT(1),
came TIMESTAMP NOT NULL,
gone TIMESTAMP,
typ INTEGER NOT NULL DEFAULT(1),
comment TEXT NOT NULL DEFAULT(''),

PRIMARY KEY (index, userid),
FOREIGN KEY (userid) REFERENCES users(userid),
FOREIGN KEY (typ) REFERENCES typ(index)
);




the error only comes when i create the workLogs table with the foreign-key to the users table.

here my question: Why may i not have two foreign keys to on table !?!?!?!?!?




Hibernate version: 3 rc1

Mapping documents:

Full stack trace of any exception that occurs:

Name and version of the database you are using: postgres 7.4.2

The generated SQL (show_sql=true): no sql output

Debug level Hibernate log excerpt:

you dont show any mapping generated so that would help ,)

oh sorry misread you posting.

sounds like a bug yes. please post it in jira with DDL and db/driver name.

my ddl:

<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.url">jdbc:postgresql://pc54/edzeit</property>
<property name="hibernate.cglib.use_reflection_optimizer">true</property>
<property name="hibernate.connection.username">ml</property>
<property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
<property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<mapping resource="Worklogs.hbm.xml"/>
<mapping resource="Typ.hbm.xml"/>
<mapping resource="Logged.hbm.xml"/>
<mapping resource="Users.hbm.xml"/>
</session-factory>
</hibernate-configuration>


the ddl is autogenerated by eclipse by a hibernate tool plugin too.



i've tried it with two versions of the postgres jdbc driver:
pg74.215.jdbc3.jar and pg80jdbc3.jar

the same error with both drivers.

that is not DDL / that is your hibernate.cfg.xml.

i would like if you could put the SQL DDL into a jira issue and write what you do to get to the error - including a full stack trace.

/max

sorry, but i'm a new user of hibernate.
so, could you explain what you mean with "sql ddl" and where can i find the jira - forum

DDL = Data Definition Language.

The language you use when you write "create table ..." etc.

Jira is available from our frontpage: http://www.hibernate.org/217.html

...and please next time try to use google or any other search engine that could answer these two questions faster than me ,)

/max

I'm using the latest hibernate tools, hibernate 3.1, postgresql 8.0.3 and latest driver pg74.214.jdbc3.jar if not mistaken and get the classes and mapping files generate but the relationship from fk are not there. The warning in eclipse console is

WARN Worker-5 org.hibernate.cfg.JDBCBinder - Exception while reading foreign keys for org.hibernate.mapping.Table(public.category) [org.hibernate.exception.GenericJDBCException: Error while reading exported keys meta data for public.category]

The exception is
org.hibernate.exception.GenericJDBCException: Error while reading exported keys meta data for public.category
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$5.handleSQLException(JDBCMetaDataDialect.java:282)
at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:50)
at org.hibernate.cfg.reveng.JDBCReader.processForeignKeys(JDBCReader.java:114)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:80)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:691)
at org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:113)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:85)
at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40)
at org.hibernate.eclipse.launch.CodeGenerationLaunchDelegate$2.execute(CodeGenerationLaunchDelegate.java:244)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:68)
at org.hibernate.eclipse.launch.CodeGenerationLaunchDelegate.buildConfiguration(CodeGenerationLaunchDelegate.java:241)
at org.hibernate.eclipse.launch.CodeGenerationLaunchDelegate.doFinish(CodeGenerationLaunchDelegate.java:125)
at org.hibernate.eclipse.launch.CodeGenerationLaunchDelegate.launch(CodeGenerationLaunchDelegate.java:66)
at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:590)
at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:515)
at org.eclipse.debug.internal.ui.DebugUIPlugin.buildAndLaunch(DebugUIPlugin.java:733)
at org.eclipse.debug.internal.ui.DebugUIPlugin$6.run(DebugUIPlugin.java:931)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:76)
Caused by: org.postgresql.util.PSQLException: The column name FKTABLE_CAT not found.
at org.postgresql.jdbc1.AbstractJdbc1ResultSet.findColumn(AbstractJdbc1ResultSet.java:673)
at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSet.java:475)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect$5.convertRow(JDBCMetaDataDialect.java:272)
at org.hibernate.cfg.reveng.dialect.ResultSetIterator.next(ResultSetIterator.java:47)
... 17 more


If I change to the 8.1 driver error doesn't changes

WARN Worker-25 org.hibernate.cfg.JDBCBinder - Exception while reading foreign keys for org.hibernate.mapping.Table(public.category) [org.hibernate.exception.GenericJDBCException: Error while reading exported keys meta data for public.category

The DDL for category and file

CREATE TABLE file
(
id serial NOT NULL,

CONSTRAINT id_pk PRIMARY KEY (id),
CONSTRAINT file_category_id_fkey FOREIGN KEY (category_id)
REFERENCES category (id) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE RESTRICT
)


CREATE TABLE category
(
id int4 NOT NULL DEFAULT nextval('public.category_id_seq'::text),
parent_id int4 DEFAULT 0,

CONSTRAINT category_pkey PRIMARY KEY (id)
)

Q

postgres has known bugs in their metadata handling, especially using wrong column names. Use a more uptodate driver.

When I'm using the latest driver postgresql-8.2dev-501.jdbc3.jar
I get much less warnings but it's a show stoper, nothing get's generated

There's an error, it comes in a popup...

org.hibernate.cfg.JDBCBinderException: Foreign key name (file_id) mapped to different tables! previous: org.hibernate.mapping.Table(public.webfolio_file_keyword) current:org.hibernate.mapping.Table(public.webfolio_payment)

how does your foreign key definition look like for file_id ? These names should be globally unique normally.

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/reference/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.