I'm probably making silly mistakes here, but I couldn't find the right documentation.

The problem is that I'm defining an association, but the reverse-engineering process ignores it.

Situation

Table G913 is a legacy table; it has no primary key but a unique key over the fields WGR and FI_NR.
Table REICHW is a table I'm free to redesign as needed. It uses the fields RWWGR and RWABC as primary key (I'm stripping the true list of PK fields here for brevity).

G913 provides human-readable texts for WGR codes.

Intent

I need to set up an association from REICHW to G913 so that the WGR texts become available.

As a JOIN condition, it would be written as
G913.WGR = REICHW.RWWGR AND G913.FI_NR = 1

My attempts

Here's my hibernate.reveng.xml (a pity that BBCode [ color ] doesn't work inside [ code ]):



For some reason, Hibernate Tool doesn't generate anything from the <foreign-key> tag.

Final details

I'm using Oracle 9i.

I'm using annotations, not generating .hbm.xml.

No association annotations are generated with or without the primary key definition for G913.

Association annotations and the corresponding fields and accessors are defined for a pair of unrelated tables that have a database-defined foreign key constraint.

Any help appreciated

Top priority would be getting the thing to fly, but hints and tips on improving the above hibernate.reveng.xml would be appreciated as well.

TIA!

(Daily bump)
Clues, anybody?

The decisive hint was on https://jira.jboss.org/jira/browse/JBID ... n_12412934:

Specifying the default schema in hibernate.reveng.xml is not enough, it must also be specified as a property in hibernate.cfg.xml, like this:



(Oracle does not have the concept of a catalog, so this needs to be specified as an empty string.)

(I consider this a bug and will try to report that via JIRA.)
(UPDATE: I can't register without activating Javascript, and I won't do that. I just had to reinstall Firefox to regain control over who's allowed to run JS in my browser and who isn't. In fact I'm generally weary of registration pages that require JS... I trust most people, but I know that in 1 of 20 cases I'm wrong, and the consequences of misplaced trust are too severe in today's times.)

Just a note to those reading this - putting an empty hibernate.default_catalog property will make Hibernate generate table names such as .SCHEMA.TABLE, which later fails with "Invalid table name".

The reveng tool even honors associations now. (Probably it's enough to add hibernate.default_catalog.)