Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.1.7

Using Oracle 10g

I'm trying to use middlegen to create mappings from our database schema. I'm using middlegen 2.0 since 2.1 doesn't work with our Oracle 10g database - it keeps complaining about a bad schema - the one we list is in the list that it gives as possible schemas...go figure.
Anyway, I have a table that has three columns in its primary key. Two of those columns come from another table (a foreign key). Middlegen creates a primary key portion or component-like structure for the primary key with those three columns. However when the hbm2java runs, it creates a constructor that only takes two parameters. One is the data field specific to my table. The other parameter is an object where the foreign keyed fields come from. It reports that there is a wrong number of columns - a mapping exception when trying to load the mappings from the hibernate.cfg.xml file. Any help would be greatly appreciated!

Stack trace:
Exception in thread "main" net.sf.hibernate.MappingException: identifier mapping has wrong number of columns: com.mostlyharmless.travel.hibernate.TlAirVendorPref type: com.mostlyharmless.travel.hibernate.TlAirVendorPrefPK
at net.sf.hibernate.mapping.RootClass.validate(RootClass.java:171)
at net.sf.hibernate.cfg.Configuration.validate(Configuration.java:633)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:799)
at com.mostlyharmless.travel.hibernate.util.TravelUtil.getSessionFactory(Unknown Source)
at com.mostlyharmless.travel.hibernate.util.TravelUtil.getSession(Unknown Source)
at com.mostlyharmless.travel.hibernate.HQL_MyAccount.getFees(HQL_MyAccount.java:33)
at com.mostlyharmless.travel.hibernate.HQL_MyAccount.main(HQL_MyAccount.java:75)

Composite-id mapping generated by middlegen:
<composite-id name="comp_id" class="com.mostlyharmless.travel.hibernate.TlAirVendorPrefPK">
<key-property
name="sequenceNumber"
column="SEQUENCE_NUMBER"
type="java.math.BigDecimal"
length="22"
/>
<!-- bi-directional many-to-one association to TlFlightPref -->
<key-many-to-one
name="tlFlightPref"
class="com.mostlyharmless.travel.hibernate.TlFlightPref"
>
<column name="CUSTOMER_ID" />
<column name="TRAVELER_ID" />
</key-many-to-one>
</composite-id>

The key-many-to-one property for composite keys is OK sometimes but in general you should not use them. In the case of Middlegen's generation of then there are cases that it will get the order incorrect. Middlgen can generate the composite key in both modes. Try the plain mode as it is more likely to work correctly.

As far as Middlegen 2.1 issues (with Oracle) there are some synom issues. I have not addressed them as yet. I can see the opportunity to catchup on a few things very coming up now that I just about to finsihed a project for a client.

I'm sorry, I can't find documentation on plain mode composite key creation with the middlegen tool. How do I set that parameter when I start middlegen?

I had been using Middlegen 2.0 because it hadn't been working with Oracle 10g. Then I couldn't find what you were talking about with the plain compoundkey. So I tried 2.1 again with the connection string that was working with 2.0. For some reason that works now - I wonder if it was a problem with our database that was fixed between the first time I tried it and now...
In any case I found the plain compound key property of tables in the 2.1 gui. I generated with 2.1 and it looks like that particular problem has been fixed. Now on to new bugs!!! :)
Thanks again!

Cool (and no problem).