Hi,

I'm having a problem figuring this error message out.

Foreign key (FK3C7A6DB3B11727E9:inventory_item_map [inventory_number])) must have same number of columns as the referenced primary key (inventory [user_number,idx])

I understand that the foreign key needs to reference the same as the primary key.

The primary key is not composite, just one column, so I don't know why I get this message at all.

I have a similiar map and that one works fine, but not this table for some reason. They are identical except for table name in the database.

here is what i'm trying to do,

<map name="inventoryItems" table="inventory_item_map">
<key column="inventory_number"/>
<map-key-many-to-many column="item_number" class="com.inifim.commerce.data.Item"/>
<element type="integer" column="quantity"/>
</map>

Thanks,
Jay

I'd guess Hibernate thinks the primary key in the inventory table consists of two columns: inventory [user_number,idx]

Right, that's what I think as well.

But the primary key reference consists of only one column.

So I am at a loss as to why.

I'm not sure what idx is, possibly postgresql's index?

Thanks.

How about posting class and mapping for "inventory"?

That's a good idea.

<hibernate-mapping>
<class name="InventoryManager" table="inventory">
<id name="inventory_number" column="inventory_number">
<generator class="increment"/>
</id>
<map name="inventoryItems" table="inventory_item_map">
<key column="inventory_number"/>
<map-key-many-to-many column="item_number" class="Item"/>
<element type="integer" column="quantity"/>
</map>
<one-to-one name="owner" class="User"/>
</class>
</hibernate-mapping>

create table inventory(
inventory_number bigint,
user_number bigint,
primary key(inventory_number),
foreign key(user_number) references users(id)
);

create table inventory_item_map(
inventory_number bigint,
item_number bigint,
quantity int,
primary key(inventory_number,item_number),
foreign key(inventory_number) references inventory(inventory_number),
foreign key(item_number) references item(item_number)
);

Thanks.

Something is seriously messed up.

The primary key of inventory should be inventory_number, but the error message mentiones user_number and idx

So here is what I would do:

- post the inventoryManager class

- search the complete source code for user_number and idx

- create a small but complete testcase, reducing it until there is only the problem left.

OKay. I'll try that.

Do you think it could be a circular foreign key problem or something strange?

I have the same tables and mapping for a different class. It works just fine, I really can't see the difference between this and that.

Thanks.