JPA : Inheritance - Discriminator value not taken into account in generated SQL
        Posted  
        
            by Julien
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Julien
        
        
        
        Published on 2010-04-12T08:33:29Z
        Indexed on 
            2010/04/12
            22:53 UTC
        
        
        Read the original article
        Hit count: 416
        
I try to use this mapping :
@Entity
@Table(name="ecc.\"RATE\"")
@Inheritance(strategy=InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name="DISCRIMINATOR", discriminatorType= DiscriminatorType.STRING)
public abstract class Rate extends GenericBusinessObject {
...
}
@Entity
@DiscriminatorValue("E")
public class EntranceRate extends Rate { 
 @ManyToOne
 @JoinColumn(name = "\"RATES_GRID_ID\"")
 protected RatesGrid ratesGrid;
...
}
@Entity
@Table(name="ecc.\"RATES_GRID\"")
public class RatesGrid extends GenericBusinessObject {
 /** */
 @OneToMany(mappedBy = "ratesGrid",  targetEntity = EntranceRate.class, fetch=FetchType.LAZY)
 private List<EntranceRate> entranceRates;
}
When I try to access my entranceRates list from a ratesGrid object, I get this error :
Object with id: 151 was not of the specified subclass: com.ecc.bo.rate.EntranceRate (loaded object was of wrong class class com.ecc.bo.rate.AnnualRate)
Looking at the sql generated, I found no trace of "discriminator=" in the where clause. What am I doing wrong ?
I use a PostGreSQL database and a Hibernate as JPA provider.
© Stack Overflow or respective owner