Description Christopher Hunter-Jonson 2016-02-26 17:35:12 EST

Named Query for ManyToMany generates incorrect referencing column by table name instead of alias:

ptnr01.DTYPE should be t0.DTYPE

SELECT DISTINCT ptnr01.DTYPE FROM ptnr04 t0, ptnr01 t1 WHERE (((t0.ptnr_role_id = ?) AND (t1.tenant_id = ?)) AND (t0.tenant_id = ?)




Application is JPA in Glassfish using PostGresql as the database.

Multitenant is single table:

@Multitenant(SINGLE_TABLE)
@TenantDiscriminatorColumn(name="tenant_id",discriminatorType=STRING,length=50,contextProperty="tenantId")

Definition of ManyToMany

owning side
@Table(name="ptnr01")
public class PartnerBase implements Serializable {
..
@ManyToMany
 @JoinTable(name="ptnr06",
   joinColumns=@JoinColumn(name="partner_id"),
   inverseJoinColumns=@JoinColumn(name="ptnr_role_id"))
 private List<PartnerRole> roles;   
..
}

dependant side
@Multitenant(SINGLE_TABLE)
@TenantDiscriminatorColumn(name="tenant_id",discriminatorType=STRING,length=50,contextProperty="tenantId")
@Table(name="ptnr04")
public class PartnerRole implements Serializable {
..
@ManyToMany(mappedBy = "roles")
 private List<PartnerBase> partners;

..
}

named query:
@NamedQuery(name = "partnersByRole",query ="select p from PartnerBase p join PartnerRole r  where r.ptnrRoleId = :roleId ")

SQL generated:
SELECT DISTINCT ptnr01.DTYPE FROM ptnr04 t0, ptnr01 t1 WHERE (((t0.ptnr_role_id = ?) AND (t1.tenant_id = ?)) AND (t0.tenant_id = ?)