Description Mark Hoffmann 2007-08-23 10:21:29 EDT

Build ID: I20070621-1340

Steps To Reproduce:
1. Create a ManyToMany mapping
2. Try to select a table in the join table selection in JPA Details view
3. To get the annotation you can type-in you table name. YOu get the error that this table doesn't exist in your default schema.
4. Even using the notation database.table makes the error disappear

The Mapping works well in my testing-application.


More information:
It is not possible to select a join-table in general. Because of that it is not possible to set the joinColumns and inverseJoinColumns. It is always possible to overwrite the default-values but the validation in the editor doesn't work correctly.

example:

@ManyToMany(targetEntity=model.Contact.class)
@JoinTable(name = "contact_contact", joinColumns=@JoinColumn(name="source_id"), inverseJoinColumns = @JoinColumn(name="target_id")
Collection<Contact> otherContacts = new ArrayList<Contact>(1);

The error is:
Schema "default-schema" cannot be resolved for join table "contact_contact". I don't know where this default-schema name comes from. It is further not possible to select another schema in this JPA Detail. The entity itself is mapped to another schema.