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

Hibernate version:
3.2.5.ga

Mapping documents:

annotations 3.3.0

Name and version of the database you are using:

mysql 5.0

The generated SQL (show_sql=true):


Given the following mapping (where 'asin' is not the primary key), I am getting an invalid insert

insert
into
amazon_item_browsenodes
(asin, amazon_node_id)
values
(?, ?)

the asin value is the AmazonItem primary key,
Am I doing something wrong here?

Here is the relevant mapping

@CollectionOfElements
@ManyToMany(targetEntity=AmazonEcsBrowsenodes.class, fetch=FetchType.EAGER)
@JoinTable(name="amazon_item_browsenodes",
joinColumns=@JoinColumn(name="asin", referencedColumnName="asin"),
inverseJoinColumns=@JoinColumn(name="amazon_node_id", referencedColumnName="amazon_node_id")
)
private List<AmazonEcsBrowsenodes> amazonBrowsenodes = new ArrayList<AmazonEcsBrowsenodes>(0);